Someone asked why I would use TRY_PARSE after I posted a question at SQL Server Central: Getting the Average. Isn’t…
Browsing: SQL
Validating AI-generated index recommendations is the step between a persuasive script and a change you can defend in production.AI-generated index…
Disclaimer: Rather than spending time writing a test scenario from scratch, I used Claude Code to generate the test scenarios…
This month we have a new host, which I am grateful for. So many people have stopped blogging that it’s…
SQL Server cost optimization has a problem nobody puts on the slide. The savings are real, the dollars are real,…
I was recently trying to handle a simple task with a few AI tools to see how well things worked.…
A better fire alarm is still a fire. Many SQL Server incidents I get called about were preventable with controls…
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…