SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: January 2012

System Base Tables

On January 19th, I published a post about the Dedicated Administrator Connection.  I spoke very briefly of the system base tables in that article.  Today, I want to dive into these tables a little bit more.

First, let’s get the Microsoft definition for these tables.  ”System base tables are… Read more

0 comments, 960 reads

Posted in SQL RNNR on 30 January 2012

Slammer, Alive…Barely


By now you must have heard of the SQL Slammer worm.  It was quite an infectious little nuisance.  The harm it caused came largely due to unpatched, unprotected SQL Servers.

We are now 9 years out from the initial discovery of this worm.  The worm has made its way… Read more

1 comments, 2,422 reads

Posted in SQL RNNR on 24 January 2012

S3OLV February 2012

Do you recognize this person?


If you are from the Colorado Springs area, you probably do.  This is:




Troy Ketsdever (twitter)

Troy will be presenting to the Las Vegas SQL User Group on February 9, 2012 @ 6:30 Pacific.  Here is his bio:

Troy… Read more

1 comments, 769 reads

Posted in SQL RNNR on 23 January 2012

S3OLV – Jan 2012 Meeting Recap

Last week (Jan 12, 2012), we held the user group meeting for the SQL Server Society of Las Vegas (a.k.a S3OLV or SSSOLV).

Presenting at that meeting was Josh Lewis (Twitter).  Josh presented on a pretty tough topic in my opinion.  He chose to present to us the… Read more

1 comments, 625 reads

Posted in SQL RNNR on 20 January 2012

Dedicated Administrator Connection

Recently you may have read my article about some hidden functions in SQL Server.  In that article you learned that those functions were in some DMOs and that you could get at them through the resource database.

Today I found myself learning more about the resource database.  Due to what… Read more

3 comments, 963 reads

Posted in SQL RNNR on 19 January 2012


What more can I say.  I disagree with the kind of legislation that is being presented via SOPA and PIPA.

In support of the community, my site will be dark 18 Jan 2012 between 10:30 and 21:30 GMT-8.

Normal services will return after that.


You can see support of… Read more

0 comments, 792 reads

Posted in SQL RNNR on 18 January 2012

A Trio of Functions

I found myself perusing an execution plan the other day.  I know, big surprise there.  This execution plan showed me some interesting things I had never really paid much attention to in the past.  When I started paying attention to these things, I found myself jumping down a rabbit hole. Read more

2 comments, 1,154 reads

Posted in SQL RNNR on 17 January 2012

Meme15 Twitter

Twitter and Your Career

With the new blog party on the block, we have Jason Strate (blog | twitter) asking us this month these two questions:

  1. Why should average Jane or Joe professional consider using twitter?
  2. What benefit have you seen in your career because of twitter?

But… Read more

0 comments, 660 reads

Posted in SQL RNNR on 16 January 2012

Missing Indexes

SQL Server has means built into it to track possible missing indexes.  This used to be found through the use of the Index Tuning Wizard.  The process has improved over time (you can sort of see that from my April Fools post).

As luck would have it, I was… Read more

10 comments, 3,699 reads

Posted in SQL RNNR on 12 January 2012

TSQL Tuesday #26 or #23 – Identity Crisis

The first opportunity of this New Year to participate in TSQLTuesday, we have been invited by David Howard (blog) to take a second shot at a previous TSQLTuesday.

This second shot is giving me fits.  I have no clue if it is TSQLTuesday 26 or if it is… Read more

2 comments, 876 reads

Posted in SQL RNNR on 10 January 2012

S3OLV update and Reminder

We are now just a few days away from our first meeting of 2012.  We have some good content lined up.  Check it out here.

I am looking forward to the presentation on XML and would really love to be able to bring Josh back to finish out the… Read more

0 comments, 634 reads

Posted in SQL RNNR on 9 January 2012

Meme Monday January 2012

Meme Monday was pushed back this month to the second Monday of the month.  That is a good thing or maybe a bad thing or maybe a non-discussion at all.  I guess it really depends on the person.  For me, I would have been rushing the post so I am… Read more

0 comments, 558 reads

Posted in SQL RNNR on 9 January 2012


At the recommendation of Jorge Segarra (Blog | Twitter),  I got the book Daemon.  Well, I actually got that about a year ago as a gift – but it was on my list of books to read because Jorge recommended it.

I have finally finished reading it… Read more

1 comments, 886 reads

Posted in SQL RNNR on 4 January 2012