Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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, 430 reads

Posted in SQL RNNR on 30 January 2012

Slammer, Alive…Barely

Slammer

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, 1,858 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, 265 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, 294 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

2 comments, 313 reads

Posted in SQL RNNR on 19 January 2012

Blackout

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, 362 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

0 comments, 592 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, 274 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, 2,320 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, 321 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, 323 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, 256 reads

Posted in SQL RNNR on 9 January 2012

Daemon

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, 282 reads

Posted in SQL RNNR on 4 January 2012