Developer Builds Free SSMS Extension to Prevent Accidental Destructive SQL Queries

·1 views

A developer created SQL Guard, a free extension for SQL Server Management Studio (SSMS), after a colleague accidentally deleted 47,000 production rows by running a DELETE query without a WHERE clause. The tool intercepts potentially destructive SQL commands — such as DELETE, UPDATE, TRUNCATE, or DROP statements lacking proper filters — at the moment of execution and prompts the user to confirm before proceeding. SQL Guard performs lightweight pattern matching entirely within the SSMS process in under a millisecond, with no query data sent to external servers. Whitelisting is intentionally granular, allowing exceptions only for specific tables and specific rules, rather than offering a blanket bypass. The extension is available free at sqlguard.app and supports SSMS versions 18 through 22, though the developer emphasizes it is a safeguard and not a replacement for backups and a formal recovery plan.

Read the full story at DEV Community

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

A Physical Therapist Shares Four Coding Fixes That Closed Silent Gaps in Hospital Tools

A physical therapist who develops internal hospital tools using AI documented four small but impactful changes made to improve system reliability over several weeks. Inspired by posts from other developers, they tested their static security scanner by planting known vulnerabilities, discovering it missed three and also exposed three live API keys in already-reviewed code. They also added a dead-man's switch after realizing their health-check had no oversight — meaning a silent failure would have appeared identical to a healthy system. A standing rule was introduced for their AI agents to always commit to a single recommendation with a stated reason and a named assumption, and counting actual compliance revealed the rule leaked precisely where exceptions had been quietly self-granted. Finally, they replaced eyeball-based color contrast checks with an automated script after acknowledging manual review was wrong roughly 40 percent of the time.

0 comments Read more at DEV Community

ProgrammingHacker News ·

Hacker News User Seeks Advice on Promising RL Research Directions for MSc

An incoming master's student posted on Hacker News seeking guidance on which reinforcement learning subfields hold the most research potential today. The student is beginning their MSc program and is trying to identify a suitable research direction within the broad RL landscape. They expressed particular interest in two areas: embodied AI and brain-computer interfaces. The post garnered five upvotes but had not yet received any comments at the time of publication.

0 comments Read more at Hacker News

ProgrammingDEV Community ·

How to Build a Personalized AI Music System From Your YouTube Watch History

A developer has outlined a multi-month project to create a self-learning music recommendation system powered by a user's own YouTube viewing behavior. The system involves a browser extension that silently tracks watch time, skips, and replays on YouTube videos to capture implicit listening preferences. This data is sent to a FastAPI backend, stored in PostgreSQL, and processed nightly by machine learning pipelines that classify content, resolve song metadata, and generate audio embeddings. The goal is to produce personalized playlists that reflect actual listening habits rather than platform-driven recommendations. The project is designed as a full-stack learning exercise spanning browser extensions, backend APIs, databases, and ML models.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Developer Launches ToolEka With 14+ Free Online Tools Built in One Week

A developer has launched ToolEka, a free online tools platform built in just one week using Next.js, TypeScript, Tailwind CSS, and Cloudflare Workers. The platform's first release includes over 14 tools spanning health calculators, finance calculators, developer utilities, and text tools. ToolEka was designed as a faster, ad-free, and mobile-friendly alternative to existing online tool websites. All tools are accessible without requiring users to create an account. The developer has outlined a public roadmap targeting 100+ tools, AI-powered utilities, and improved accessibility in future updates.

0 comments Read more at DEV Community