SQL RNNR

      The Long and Winding Road It is time for another installment in the monthly blog party for SQL Server professionals known as TSQL Tuesday. This month we have the pleasure of being hosted by Wendy Pastrick (blog | twitter).  The topic for the month requires a bit of introspection (almost like the[...]

Spring is in the air, I think. With that scent in the air, we have a nice juicy topic coming up this month for any and all that are interested. Chad Crawford will be presenting to the group on the tastiness that is Service Broker. Service Broker in Action SQL Server Service Broker is a[...]

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 single_user session.  It would seem[...]

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 attempt.  This is a bit[...]

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 allows the secondary database to[...]

Backstory 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 Tuesday #40, the topic is on Files and[...]

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 of the upcoming speakers and[...]

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 happens that this week we have[...]

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 recovery model set to full[...]

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 the pot.  Sometimes more hands[...]

Thanks Patrick

Congratulations Jason. I know how much effort is required to get through tis qualification.

Thanks Mike. Long time no speak. We need to chat.

Congratulations Jason, well deserved!

Thanks Wayne!

Jason - CONGRATULATIONS!!! It turned out to be a longer journey that you expected, but your perseverance to see this through ...

I neglected to mention Neil Hambly in my post. I got to know Neil through Summit and on SQLCruise. ...

Thanks Matt. I am glad I stuck it out too

Thanks Wendy

Thanks Kevin