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

A Firm Foundation

Last week I sent out an invite for the monthly TSQL Tuesday party.

The theme for the party is a take on the words resolve or resolution.  I was hoping the theme would encourage some reflection and sharing of real life experiences that have led to a difference being made. Read more

4 comments, 376 reads

Posted in SQL RNNR on 8 January 2013

SSRS Subscriptions Report

As a part of my series leading up to Christmas 2012, I shared a script to Report on SSRS Subscriptions.  It was soon found to have a bug with SQL Server 2008 R2 SP2.  IN the comments on that post, I promised to post an updated script.  Here is… Read more

0 comments, 709 reads

Posted in SQL RNNR on 7 January 2013

T-SQL Tuesday #38 – Standing Firm


Welcome back for the 38th installment in the wildly popular blog party for the SQL Server community.  This is the party that happens on the second Tuesday of each month.  The party was started by Adam Machanic (B|T) just over three years ago.

Each month… Read more

10 comments, 1,014 reads

Posted in SQL RNNR on 2 January 2013

On the Twelfth Day…

Bacon wrapped frog legs (twelve of them) for Christmas.  No more drumming for these guys!!

What could be better than bacon wrapped frog legs?  Oh yeah, more Virtual lab setup.

We will delve into setting up a SQL Cluster today.  We will also cover some high level tips for dealing… Read more

0 comments, 501 reads

Posted in SQL RNNR on 25 December 2012

On the Eleventh Day…

Yesterday we had an introduction into setting up a virtual lab to help the DBA learn and test new technologies while improving his/her own skill set.

Today we will continue to discuss the building of a virtual lab.  Today we will get a little closer to the SQL portion of… Read more

0 comments, 409 reads

Posted in SQL RNNR on 24 December 2012

On the Tenth Day…

Silver and Gold have a way of really bringing the look and feel of the Christmas season.

Silver and Gold also seem to represent something of greater value.

We are now into the final three articles of the 12 Days of pre-Christmas.  And with these three articles, I hope to… Read more

1 comments, 559 reads

Posted in SQL RNNR on 22 December 2012

On the Ninth Day…

It’s the end of the world as we know it.  And as the song goes…I feel fine!  But hey, we didn’t start the fire.

Those are a couple of songs that pop into my head every time somebody starts talking doomsday and doomsday prophecies.

If you are reading… Read more

2 comments, 484 reads

Posted in SQL RNNR on 21 December 2012

On the Eighth Day…

Today’s post is merely an illusion.  The illusion being that we have finally stopped talking about the msdb database.  I’ll explain about that later in this post.

This should be a good addition to the script toolbox for those Mere Mortal DBAs out there supporting their corporate SSRS environment.  Everybody… Read more

5 comments, 817 reads

Posted in SQL RNNR on 20 December 2012

On the Seventh Day…

So far this series has been a bit of fun.  We have discussed a fair amount of useful things to date.  And here we are only on the seventh day.

Today we will be reverting our attention back to the msdb database.  This time not as a means of maintaining… Read more

1 comments, 758 reads

Posted in SQL RNNR on 19 December 2012

On the Sixth Day…

What better way to kick off the sixth day of pre-Christmas than with six slices of foie-gras?  No animals have been hurt in the making of this post!

This could be a pretty festive dish thanks in part to those geese.  I enjoy a little foie gras every now and… Read more

3 comments, 883 reads

Posted in SQL RNNR on 18 December 2012

On the Fifth Day…

Today we will have a quick change of pace.  This will be less about maintenance and more about internals.

Today’s topic is one of particular interest to me as well.  The topic is a small section of a presentation I like to give at User Groups and at SQL Saturdays. Read more

1 comments, 376 reads

Posted in SQL RNNR on 17 December 2012

On the Fourth Day…

We have come to the fourth day in this mini-series.  So far I have laid down some under-carriage maintenance for one of our favorite databases.  That database being the msdb database.  The maintenance discussed so far has covered a few different tables and processes to try and keep things tidy… Read more

1 comments, 408 reads

Posted in SQL RNNR on 16 December 2012

On the Third Day…

Mais Oui!

But of course, we must have some french hens for today!  Today we have the third day of pre-Christmas.  And as was mentioned we have more undercarriage work in store.

So far we have talked about the following:

  1. Maintenance Plan Logs on the First Day
  2. Service Broker lost…

Read more

0 comments, 458 reads

Posted in SQL RNNR on 15 December 2012

On the Second Day…


Yesterday, I introduced the 12 Days of pre-Christmas.  In that first article, I gave you a gift to help maintain your msdb undercarriage.  Today I want to continue in that vein.

As is the tradition with the 12 Days of Christmas, each of these gifts should provide more value… Read more

2 comments, 658 reads

Posted in SQL RNNR on 14 December 2012

On the First Day…

Many of us have heard the song “The Twelve Days of Christmas.”  Some are familiar with how that song has some connection with the Holiday season for Christians.  Fewer are aware that this song is connected to the tradition of giving traditions on each of the days of Christmas.  Fewer… Read more

2 comments, 404 reads

Posted in SQL RNNR on 13 December 2012

Let’s Talk About Joins

T-SQL Tuesday #37

This month please join us in the TSQL blog party that happens on the second tuesday of the month.  It is hosted this month by Sebastian Meine (@sqlity).

Sebastien has a month long blog going this month all about Joins.  You can read all about… Read more

1 comments, 1,835 reads

Posted in SQL RNNR on 11 December 2012

Backup History

This is a quick rewrite of the script I just posted a few days ago.  The script had a few flaws if trying to run it on a SQL 2005 box.  I have updated it to run against SQL 2005 and up.

This version is done using Dynamic SQL to… Read more

5 comments, 1,276 reads

Posted in SQL RNNR on 30 November 2012

Differential Restore Fail

We have all heard that backup is not complete until you test it by restoring it.  We also know that part of a DR plan involves the testing of those backups through restores.

I recently had the opportunity to run through a test scenario and ran into a substantial failure.… Read more

8 comments, 980 reads

Posted in SQL RNNR on 28 November 2012

Most Interesting People…

Here are the most interesting people I met at PASS Summit 2012


Mickey Stuewe (sqlmickey)

Neil Hambly (neil_hambly)

Bob Hovious

Gail Shaw (sqlinthewild)

Ed Watson (SQLGator)






This is the short list of the many many many… Read more

0 comments, 550 reads

Posted in SQL RNNR on 21 November 2012

Last Known Good CheckDB

Diligent DBAs like to check their databases for a little thing called corruption.  Some of those DBAs are masterful at keeping records and logging that the database was checked and came up with a clean bill of health.

There are many different ways of logging this kind of activity.  Today… Read more

1 comments, 1,424 reads

Posted in SQL RNNR on 20 November 2012

Newer posts

Older posts