Spring is in the air, I think.
Chad Crawford will be presenting to the group on the tastiness that is Service Broker.
Service Broker in Action
SQL… Read more
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
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
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
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
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
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
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
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
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
The topic was on “Standing Firm” and can be found by… Read more
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
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
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
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
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
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
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
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
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