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
688 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,606 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,198 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,620 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,613 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,700 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
662 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,042 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,163 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,891 reads
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
Local Agents
Comments posted to this topic are about the item Local Agents
Detecting Deadlocks
Comments posted to this topic are about the item Detecting Deadlocks
Introducing the Relational Embedding Retrieval Pattern: Storing and Querying Vector Embeddings in SQL Server
Comments posted to this topic are about the item Introducing the Relational Embedding Retrieval...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers