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 sysprotects returns rows for permissions within a… Read more

Welcome to this Friday’s reblog summary post.  The aim of these posts is to bring some old posts that newer readers may not have seen back to the forefront.  As with many technology blogs, just because a post is old, doesn’t mean it doesn’t still have value.

Some posts from… 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 sysservers provides information on linked servers, or… 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 sysremotelogins returns a row for every remote… Read more

As a few of you know, I took the Microsoft Certified Master (MCM): SQL Server 2008 lab at this year’s PASS Summit.  Now, I’ve been working on this certification for a while.  With the knowledge exam, I failed before retaking and passing.  A couple months later, I took 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 sysreferences returns a row for every foreign… Read more

In a previous post, there was a comparison between sysperfinfo and sys.dm_os_performance_counters which included the use of a simple query.  The query just returned the contents of the dynamic management view, but didn’t provide the data from the view in a manner that immediately useful for all performance counters.

The… Read more

Did you know that a SQL Saturday in Fargo is in the works?  If not them, hey… there’s a SQL Saturday coming to Fargo.  And it’s happening this coming spring on April 27!

Now what’s the big deal about Fargo, you might be wondering.  Well, it’s one of the… Read more

Ever thought you could learn a little bit more about indexing?  Now here’s the perfect opportunity.  Today only you can purchase Expert Performance Indexing for SQL Server 2012 for $15 as an e-book directly from APRESS.

That’s right!  Only $15.  This Monday… as in today… the holiday season has… Read more

Throughout the week, I like to tweet links to the things that I’ve been reading.  Since they all come out through out the day, I figured that I’d share a list of those that were most popular last week.

Last week’s top 10 “Reading” Links

1. PASS Summit 2012 in a…

Read more

Welcome to this Friday’s reblog summary post.  The aim of these posts is to bring some old posts that newer readers may not have seen back to the forefront.  As with many technology blogs, just because a post is old, doesn’t mean it doesn’t still have value.

Some posts from… 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 sysperfinfo 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 sysobjects 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 sysusers returns a row for every Windows… 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 syspermissions returns rows that describe permissions granted… 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 systypes returns one row for data type… 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 sysopentapes returns one row for tape devices… 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 sysoledbusers returns a row for every login… 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 sysmessages returns one row for every error… Read more

Throughout the week, I like to tweet links to the things that I’ve been reading.  Since they all come out through out the day, I figured that I’d share a list of those that were most popular last week.

Last week’s top 10 “Reading” Links

1. Are The Bells Tolling For…

Read more