Going to PASS Summit 2014

PASS Summit 2014 Homepage

I’m lucky enough to take part in the largest SQL Server conference in the world, the PASS Summit 2014 held in Seattle. This will be my second Summit, first one being the 2013 one held in Charlotte. While I’ve had the privilege of attending quite a few training sessions during my career, none have been even close to the level of learning offered in PASS Summit. The knowledge of the speakers, many of who are renown experts in their own fields, and the quality of the sessions is nothing short of awe inspiring. In 2013 Summit I remember being quite impressed how well things were organized. I was even more impressed when I learned that the amount of volunteer work hours for it was over 500,000.

That is a lot of hours and I believe it tells about the kind of commitment the SQL Server community has for making this event a reality.

(more…)

Microsoft releases SQL Server 2008 R2 Service Pack 3

Just a quick post about the fact that Microsoft has finally released the SQL Server 2008 R2 Service Pack 3 (Build 10.50.6000.34) few days ago. This will be the last Service Pack to the SQL Server 2008 R2 version and it is mainly just a roll up of all the previously released Cumulative Updates, with few additional fixes.

(more…)

What the Cluster Validation Test doesn’t tell you.

When I’m dealing with a problem on a Failover Cluster (not very often, but sometimes) one of the first steps I do is to run the Validation Test. It’s a great tool that’ll usually show what might be the problem, but apparently not always…

For the last couple days I’ve been busy wrecking havoc on a cluster with a Microsoft Cluster PFE on a Cluster Disaster Recovery workshop. Among the scenarios we’ve gone through causing, fixing and then documenting there was one that had a small surprise in store for both of us.

(more…)

Database Design Tip: Involve the Production DBA

I was reading this blog post by Thomas LaRock (@SQLRockstar) about a database design mistakes and I’ll warmly recommend that anyone who is involved with database design should read it as well. It also got me into thinking about one database design issue which, in my opinion, is not taken into consideration often enough; Database Administration.

(more…)

Alternatives to KILL (SPID)

A few days ago there was a question in Twitter about options to KILL (SPID) with a long running transaction that was causing a lot of blocking in a mission-critical system. The person asking the question got some helpful tips on how to fix the problem, such as looking at the tables and the indexes and some tools were pointed out to him, like Adam Machanics Sp_WhoIsActive.

(more…)

SAN migration in Windows Failover Cluster

I recently did a migration from one SAN to another and decided to write a quick blog post about the procedure I used. In this particular case the difficult part was handled by the SAN administrator as we were moving from one manufacturer to another. He had the pleasure of trying to add disks from two different storage systems to two nodes, which required not a small amount of dismantling features such as MPIO. We did have some problems with disks showing up multiple times, but nothing we couldn’t work around with.

(more…)