A better fire alarm is still a fire. Many SQL Server incidents I get called about were preventable with controls…
Browsing: SQL
It’s been some time since I provided a car update, so I decided to showcase a few things I’ve learned…
An anonymous interview with a database professional who did everything the company asked. There is no lesson at the end…
An architecture scenarioImagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales owns sales transactions, Finance owns budgets, and…
Security on your SQL Server is important. That doesn’t need any explaining. But where do you start when evaluating the…
Everyone writes about AI generating queries. Nobody writes about the strange jobs it is actually doing inside real database teams.…
I got a notification from a question I’d posted at SQL Server Central: Getting the Average. A user had posted…
SQL Server sa Account Security: Rename, Disable & Best PracticesIn the Windows administration world, it’s pretty much a standard practice…
Everyone is waiting for AI training at work. It took me a hundred conversations to understand what they are actually…
No two SQL Server environments are alike. A fix that resolves a performance issue in one environment may not work…