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

2 comments, 1,240 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, 478 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, 408 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, 369 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, 378 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

4 comments, 436 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, 798 reads

Posted in SQL RNNR on 7 January 2013

T-SQL Tuesday #38 – Standing Firm

Introduction

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

Posted in SQL RNNR on 2 January 2013