Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: October 2012

Pro SQL Server 2012 Practices Released Today


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

1 comments, 0 reads

Posted in StrateSQL on 31 October 2012

Learn Good / Do Good


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

1 comments, 458 reads

Posted in StrateSQL on 31 October 2012

PASS 2012 Countdown – 1 Week To Go

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

5 comments, 437 reads

Posted in StrateSQL on 30 October 2012

Last Weeks Top 10 “Reading” Links #4

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

0 comments, 345 reads

Posted in StrateSQL on 29 October 2012

Reblog: October 19 to October 25

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

0 comments, 301 reads

Posted in StrateSQL on 26 October 2012

PASS 2012 Countdown – 2 Weeks To Go

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

0 comments, 408 reads

Posted in StrateSQL on 25 October 2012

Discovering Binary Pages In Sys.Indexes

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

4 comments, 455 reads

Posted in StrateSQL on 24 October 2012

Decoding first, root, and FirstIAM in Sysindexes

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

5 comments, 1,201 reads

Posted in StrateSQL on 23 October 2012

What Happened to rowmodctr from Sysindexes?

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

10 comments, 962 reads

Posted in StrateSQL on 22 October 2012

Last Weeks Top 10 “Reading” Links #3

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

0 comments, 347 reads

Posted in StrateSQL on 22 October 2012

Ask The Unicorn: SQL Saturday Registration Is Closed

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

0 comments, 354 reads

Posted in StrateSQL on 20 October 2012

Reblog: October 12 to October 18

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

0 comments, 238 reads

Posted in StrateSQL on 19 October 2012

PASS 2012 Countdown – 3 Weeks To Go

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

0 comments, 893 reads

Posted in StrateSQL on 17 October 2012

Indexing Book Winner

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

2 comments, 286 reads

Posted in StrateSQL on 17 October 2012

Last Weeks Top 10 “Reading” Links #2

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

0 comments, 317 reads

Posted in StrateSQL on 15 October 2012

Ask the Unicorn: How to become a DBA?

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

0 comments, 348 reads

Posted in StrateSQL on 12 October 2012

Older posts