Lost in Translation – Deprecated System Tables – sysfulltextcatalogs

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

SQL In The City: Seattle

If you missed all the great speakers on the five city tour of SQL in the City, don’t despair. Many...

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