So you want to write a book
I had posted a while back on the process of book writing. It was an attempt to educate while scaring...
2010-12-08
687 reads
The Scary DBA
Review: Idera SQL Doctor
Recently, a co-worker practically slammed me up against the wall, exclaiming “You have to check out this new tool, right...
2010-12-06
2,601 reads
SQL Spackle
I previously mentioned how SQL Server Central was listing ideas for articles, primarily for short, quick, pointed articles that they...
2010-12-02
1,195 reads
Regressions
Hannah Dustin, Upset about Regression
One of the most important take-aways from David Dewitt’s presentation at the PASS Summit was the...
2010-11-30
1,617 reads
FreeCon
I got my FreeCon. What’s more, I did it in public and didn’t get in trouble.
FreeCon is the brain child...
2010-11-24
1,607 reads
Do Foreign Key Constraints Help Performance?
Most people are very aware of the fact that having a foreign key constraint in place on your tables adds...
2010-11-22
1,690 reads
Un-SQL Friday: Branding?
Following in Midnight DBA’s more interesting half new blog fest topic.
My branding? I don’t have a clue. There, I said...
2010-11-19
659 reads
Reason for Early Termination of Statement
Wouldn’t you like to know why the optimizer stopped tuning the execution plan you’re looking at? It’s actually possible and...
2010-11-18
3,036 reads
SQL Server Team-Based Development
The new book is available in a free download from Red Gate. I had a lot of fun working on...
2010-11-16
1,159 reads
Switching Off Parameter Sniffing
Or, another way to put it, in most cases, shooting yourself in the foot.
I was not aware that the cumulative...
2010-11-15
2,888 reads
Blogs
A Broken Copilot Query
By Steve Jones
I was testing the new SSMS (v22 Preview 3) with Copilot and ran into...
SQL Server Alerts
By Kevin3NF
Don’t Let Trouble Sneak Up on You Most SQL Servers run quietly. Until...
Prompt AI helping with Auditing
By Steve Jones
I had a conversation with a customer asking this question: how can I tell...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Building a RESTful API with FastAPI and PostgreSQL
Comments posted to this topic are about the item Building a RESTful API with...
The Journey to PostgreSQL (or anything)
Comments posted to this topic are about the item The Journey to PostgreSQL (or...
Question of the Day
A Common Split
What happens when I run this code:
DECLARE @s VARCHAR(1000) = 'apple, pear, peach' SELECT * FROM STRING_SPLIT(@s, ', ')See possible answers