After about a year of work and a month of waiting, the book I wrote with Ted Krueger (Blog | @Onpnt) is finally out and available on Amazon.com.  When I first considered putting a book together, I thought about the books out there and wondered why I… Read more

This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective dynamic management objects. You can find a list of all of the deprecated views in the introduction post.

The compatibility view sysdatabases returns rows for each database on… Read more

This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective dynamic management objects.  You can find a list of all of the deprecated views in the introduction post.

The compatibility view syscurconfigs returns rows for each configuration option… Read more

I was thinking about the contest that SQL Sentry is running for a week of SQLskills Immersion Training, and the only thing that came to mind were sheep.  Now don’t get me wrong, there’s nothing wrong with sheep.  Rumor has it there is a sheep’s costume floating around the SQKskills… Read more

This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective dynamic management objects.  You can find a list of all of the deprecated views in the introduction post.

The compatibility view sysconstraints returns rows for all of the… Read more

This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective dynamic management objects.  You can find a list of all of the deprecated views in the introduction post.

The compatibility view sysconfigures returns rows for each configuration option… Read more

This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective dynamic management objects.  You can find a list of all of the deprecated views in the introduction post.

The compatibility view syscomments returns rows for each view, rule,… Read more

This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective dynamic management objects.  You can find a list of all of the deprecated views in the introduction post.

The compatibility view syscolumns returns one rows for each column… Read more

The year is half over and for many of us, specifically those in the United States, it’s a tricky week to get work done.  With a national holiday on Wednesday, the US Independence celebration, a lot of us will be left with a partial work week and a real challenge… Read more

This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective dynamic management objects.  You can find a list of all of the deprecated views in the introduction post.

The compatibility view syscacheobjects returns one row for every object… Read more

This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective dynamic management objects.  You can find a list of all of the deprecated views in the introduction post.

The compatibility view sysaltfiles returns one row for every file… Read more

When SQL Server 2005 launched, it included a slew of dynamic management objects (DMOs) that were meant to replace the system tables from previous SQL Server versions.  As a stopgap, and part of the deprecation process, compatibility views for the system tables were provided. Their time is nearly up.  If… Read more