Windows Server 2008 Cluster: Understanding the Cluster Log Behavior

In any system, logs are very important to troubleshoot the issue. In the case of windows cluster, cluster logs are...

Generate Uniqueidentifier with SSIS

If you are trying to generate Uniqueidentifier/Newid() in SSIS data flow, you will soon realize that there is no out-of-the-box...

RML Utilities and SQL Server 2012

I’m working through some code that I haven’t touched recently and I’m running it for the first time on a...

SQL Server 2012 CU4 Is Now Available !

The 4thcumulative update release for SQL Server 2012 is now available for download at the Microsoft Support site. Cumulative Update...

SQL Server 2012 RTM Cumulative Update 4

Microsoft has released SQL Server 2012 RTM Cumulative Update 4, which is build 11.00.2383.0. By my count, there are 25...

SQL Server Quickie #4 – IAM Pages

Today I have uploaded the 4rd SQL Server Quickie to YouTube. In this episode I’m talking about IAM Pages in...

SQL Server Quickie #4 – IAM Pages

Today I have uploaded the 4rd SQL Server Quickie to YouTube. In this episode I'm talking
about IAM Pages in SQL...

SSAS #28 – Setup to Learn SSAS Stored Procedures

Having worked with SSAS for a while and done some reporting with MDX queries, I started to explore opportunities to...

Thirteen Years Old

A very cool shot of our company at 13.

I first heard of Red Gate back in 2001 and they were...

Which SQL Instance is Killing Your CPU?

You have 5 instances running.  How do you know which one is killing your CPU?

As you can see from Windows...