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 […]
Category: Corner
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
On the Seventh Day…
So far this series has been a bit of fun. We have discussed a fair amount of useful things to date. And here we are only on the seventh day. Today we will be reverting […]
On the Sixth Day…
What better way to kick off the sixth day of pre-Christmas than with six slices of foie-gras? No animals have been hurt in the making of this post! This could be a pretty festive dish […]