Inserted and Deleted are One Table?

Inserted and deleted tables are 2 pseudo tables preseting the before and after images of modified rows. They can only...

Querying database usage

A question that a DBA will often be asked is what databases are actively being used on my SQL Server?...

Another Stop-Gap Solution for the SQL Server 2012 Identity Crisis

                I haven’t seen this many fake ID’s since I was in college.

                Back on April 26, Grant Fritchey (of execution...

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

Thirteen Years Old

A very cool shot of our company at 13.

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

MDS: Copying models and data to another server

Having recently completed a model in Master Data Services (MDS), I needed to move the model from a development environment...

Lost in Translation – Deprecated System Tables – sysforeignkeys

This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...

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