“Well that’s on the SAN, so it’s good,” better never be a part of your recovery plan. If it is? You just lost. As I type this I’m on the way home from a city from an old client that just lost their SAN – their SAN that every VM was on, their SAN that their company … Read more
Alright so maybe that was a little misleading of a title… SQL Server join syntax changed awhile ago, when ANSI-92 joins became the norm. And Microsoft was threatening to remove it for awhile. The older outer join syntax just doesn’t work in SQL Server 2012. We All Knew SQL Server Joins Were Changing… I know… … Read more
Updated [2016] This post continues to be a popular destination for searches like “How do I shrink a database?” I made some copy edits. I also wanted to reiterate a default position: It isn’t usually a good idea to shrink your SQL Server database. There are exceptions, but they are exceptions. This post is part 1 in a series … Read more