Archive | SQL Server DBA RSS feed for this section

How Do You Prevent a SAN Failure?

… Well, prevent a SAN failure from ruining your week anyway. Because you can never fully prevent a failure 100% – even in a SAN, even when your SAN vendor says it’ll never happen (hint: anytime a vendor tells you never – be afraid.. Be very afraid). So that’s what this whole post series is [...]

Share

Yes Virginia, SANs Can Fail

“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 [...]

Share

SQL Server Join Syntax: It’s Changed!

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… I’m not [...]

Share

Don’t Touch that Shrink Database Button!

Update [1-31-09] I wrote a follow-up to this regarding some of the questions that I see Google Search bringing folks to this blog. Check out my my additional post for some of the more common questions in the post, “Shrinking Databases is a Popular Topic“.
Updated [11/16/13] This post continues to be a popular destination for [...]

Share