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

Lost that Single-User Connection?

You have changed your database to single_user mode to do a task.  As you go about your business, you lose track of which connection was the single_user connection.  You start closing connections and mistakenly close the session that was your single_user connection.  Now you are unable to start a new… Read more

0 comments, 235 reads

Posted in SQL RNNR on 6 May 2013

MCM Road Less Traveled

I began this post back in October of 2012 after learning that I had passed the SQL Server 2008 MCM Knowledge exam.  I had set it aside in hopes of polishing it off after my first lab attempt at Summit 2012.  Notice I said first attempt?  I failed that first… Read more

10 comments, 262 reads

Posted in SQL RNNR on 16 April 2013

Las Vegas April 2013 UG Meeting

AlwaysOn – Finally, A usable ‘mirror’!

In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are great, but the mirror/secondary database is not very usable since it is not online. Finally, AlwaysOn solves this limitation by merging both multi-node Clustering and mirroring. AlwaysOn also… Read more

0 comments, 302 reads

Posted in SQL RNNR on 10 April 2013

T-SQL Tuesday #040: File and Filegroup Wisdom


Each month the SQL community comes together for an important party.  This is the blog party that was the brain child of Adam Machanic (Twitter) known as T-SQL Tuesday.

The party is a very good collaboration among data professionals on a pre-determined topic.  This month, for TSQL… Read more

3 comments, 406 reads

Posted in SQL RNNR on 12 March 2013

March 2013 LV UG Meeting

Another month and we have another installment (meeting) for the Data Professionals of the Las Vegas area.

This month we will be getting back on schedule with the usual meeting time and place.  We had a slight divergence last month due to that heartsy holiday.

We are excited about some… Read more

0 comments, 309 reads

Posted in SQL RNNR on 11 March 2013

Las Vegas February 2013 UG

I know it is right in the middle of TSQL2SDAY when this post is to go live.  If you don’t know what that is, you should go check out this months edition here.  The topic this month is good and should drive up a lot of participation.

It also… Read more

0 comments, 222 reads

Posted in SQL RNNR on 12 February 2013

Is your LOG backed up?

You have been doing a fantastic job of late.  You have all of your databases being backed up on a regular schedule.  Now you get an alert that your transaction log just keeps growing.  Why is that?

You decide to do a little investigation and find that you have your… Read more

1 comments, 566 reads

Posted in SQL RNNR on 11 February 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,193 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, 451 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, 385 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, 356 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, 367 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, 407 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, 770 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,040 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, 541 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, 437 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, 603 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, 534 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, 864 reads

Posted in SQL RNNR on 20 December 2012

Newer posts

Older posts