Painful or Helpful? No SSMS Multiserver Results if One Instance Errors

I've been going back and forth with this question for a few days now.

If one instance in a multiserver query presents an...

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 able to take exclusive lock”. I have killed all...

Refreshing A SQL Mirrored Database Using Powershell

 
SQL mirroring is a means of providing high availability for your SQL database. It is available in Standard Edition and...

Continuous Integration/Delivery without Testing!

Anything we can do to automate our builds and deployment should be considered. After all, the point isn’t just to...

Last Weeks Top “Reading” Links #98

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow...

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...

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...

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...

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...

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...