How to kill a negative SPID (like SPID -2 or -3) in SQL Server?
Today, I face issue during one database restore. I am not able to restore because “Database is in use, Not...
2014-08-25
7,562 reads
The amazing never shrinking heap
This is a quick demo of a little “trick” with heaps I’ve known about for a couple of years. However...
2014-08-25
622 reads
Automated Source Control: A Librarian For Your Database Objects, Part 2
I assume that by now you’ve tried the script from Part 1, and have seen how easy it is to...
2014-08-29 (first published: 2014-08-25)
6,950 reads
The Good the Bad and the Ugly of my extended job search
Now that I’ve finally started a new job (explains why I haven’t blogged for a while) I can discuss my...
2014-08-25
393 reads
Parameterization Part 2: Seven Ways to Execute Your Query
This is the second post in my series on parameterization. In the first post I wrote about plan caching and...
2014-08-28 (first published: 2014-08-25)
9,145 reads
Speaking at SQLSaturday #336 Holland
I received some great news this week, my session about wait statistics is selected for SQLSaturday #336 in Utrecht, Holland!
This...
2014-08-23
715 reads
Security Updates released in MS14-044, and An Approach Microsoft’s Incremental Servicing Model
On August 12th, 2014, another infamous ‘patch-Tuesday,’ Microsoft released a series of Security Updates for multiple versions of SQL Server,...
2014-08-22
2,027 reads
Reblog: August 15 to August 21
Photo credit – Mike Lynch
A good cure to a creepy doll is a good old post that is still useful. In...
2014-08-22
1,024 reads
SQLSaturday Orlando Marketing Plan-Part 38
I just checked in again on our LinkedIn campaign, had a couple days with good impression counts. We can still...
2014-08-22
493 reads
The ALS Ice Bucket Challenge
A few friends challenged me yesterday, including Grant Fritchey and Aaron Bertrand. Last night, when I got to the Denver...
2014-08-22
1,316 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Trigger isn't working
Hi, I have a trigger, that works fine elsewhere but is not working at...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers