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

Archives: January 2013

Audit Configuration Changes

Do you know the last time a Server Property was changed on your instances of SQL Server?

Are you wondering when the setting for max degree of parallelism was changed?

Do you know who changed the setting?

In some environments there are a lot of hands trying to help mix… Read more

3 comments, 3,466 reads

Posted in SQL RNNR on 24 January 2013

Last Time CheckDB was Run

Back in November 2012, I shared a story about checking the last known good checkdb in the boot page of a database.  You can read that story here.

This is an important enough topic that it is worth repeating frequently if I wanted to do that.  If  for no… Read more

10 comments, 1,213 reads

Posted in SQL RNNR on 17 January 2013

T-SQL Tuesday #38 Recap

This is the wrap up for TSQL Tuesday #38.  We had a good turnout this month with some new faces and with some regulars.  In total, we had 22 entries.  All of the entries this month were very good.

The topic was on “Standing Firm” and can be found by… Read more

1 comments, 984 reads

Posted in SQL RNNR on 15 January 2013

January S3OLV 2013

I hope you are ready for some free SQL learning.  Coming up on Thursday January 10th at 6:30 PM Pacific (GMT – 8 ) we will have a stellar opportunity to do just that – Learn!

Edwin Sarmiento will be presenting for us this at the upcoming monthly Las Vegas… Read more

0 comments, 832 reads

Posted in SQL RNNR on 9 January 2013

Fast Starts

We are barely under way with the New Year and it is shaping up to be a busier year already.  Not quite as busy as has been published by the folks at Confio – but busy nonetheless.

The first thing up for me is to get my SQL Learn on.… Read more

1 comments, 978 reads

Posted in SQL RNNR on 8 January 2013

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

5 comments, 1,135 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, 1,829 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,568 reads

Posted in SQL RNNR on 2 January 2013