Happy Halloween! Are you looking for the perfect treat for your SQL Server costume?

Well, if so – I have the treat for you, today Apress releases a new book that provides a cover all book of wisdom on SQL Server.  The book is described as:

Expert SQL Server Practices…

Read more

Obviously the title of this post is an exercise in bad grammar, but it’s a little catchy.  Well, maybe not, but a post needs a title.

But let’s get to the point.  Turns out a few days ago Kalen Delaney (Blog | @SQLQueen) got a letter from Operation… Read more

Oh, dear! One more week until this year’s PASS Summit.  If you haven’t registered yet, you’re really cutting it close.  It’s really easy to do, click on the banner below and enter some information about you and your finances – invest in your career by just typing in a… 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 sysindexkeys returns information on the key and… 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 sysindexes returns one row for every index… 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. What Did You Do? is…

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

I’m not sure how we got to 2-weeks until this year’s PASS Summit.  If you haven’t registered yet it’s really getting to be time to do that.  It’s really easy to do, click on the banner below and enter your information and your neighbor’s credit card, but I didn’t… Read more

In a previous post, we looked at how to take the the binary page values in sysindexes and convert the values into file id and page id for the first and root index page and first IAM page for each index.  This information can be useful when you need to… Read more

Have you ever looked at the first, root, and FirstIAM columns in sysindexes and wondered…

“What do these values mean?”

Recently, I took the time to dig into these values to figure out what they meant.  And then, how to take the information that they contain and turn it into… Read more

In my blog series Lost in Translation – Deprecated System Tables, I’ve been going through the compatibility views in SQL Server and translating and mapping them over to catalog views and dynamic management objects.  One of the ones that I was working on recently was mapping sysindexes to sys.indexes 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. Adam Machanic : Thinking Big…

Read more

Right before the last Minnesota SQL Saturday, I was asked a few questions about learning about SQL Server which led me to recommending that the person attends the local SQL Saturday.  Shortly after that recommendation, I received the following reply:

Darn, I just tried to register for [the Minnesota…

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

Another week down and there are now 3-weeks until this year’s PASS Summit.  Take a moment and register now if you haven’t.  It’s really easy to do, click on the banner below and enter your information and your manager’s credit card information.  She called me earlier today, go ahead and… Read more

Back on October 3, I put up a post about a free indexing book.  And specifically about Expert Performance Indexing for SQL Server 2012; which I wrote earlier this year  with Ted Krueger (Blog | @Onpnt).

I forgot to mention it, but Sarah Strate (Blog 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 sysfulltextcatalogs is used to describe full text… 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 sysforeignkeys returns information on the columns in… 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. Free SQL Server training? Now…

Read more

Every now and then I get a question in e-mail and I usually just reply and leave it at that.  I figured since I’m spending the time to answer the questions, I might as well wrap them up and share them with others. And, yeah, this is a good place… Read more