Using indexed views on ANY core SQL server edition

I was having a discussion the other day and was quite surprised to hear that there still appears to be...

Cumulative Update – 3 for SQL Server 2014 RTM Is Now Available !

The 3rdcumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative...

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