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
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
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 our attention back to the msdb database. This time not as a means of maintaining… Read more
This could be a pretty festive dish thanks in part to those geese. I enjoy a little foie gras every now and… Read more
Today we will have a quick change of pace. This will be less about maintenance and more about internals.
Today’s topic is one of particular interest to me as well. The topic is a small section of a presentation I like to give at User Groups and at SQL Saturdays. Read more
We have come to the fourth day in this mini-series. So far I have laid down some under-carriage maintenance for one of our favorite databases. That database being the msdb database. The maintenance discussed so far has covered a few different tables and processes to try and keep things tidy… Read more
But of course, we must have some french hens for today! Today we have the third day of pre-Christmas. And as was mentioned we have more undercarriage work in store.
So far we have talked about the following:
Yesterday, I introduced the 12 Days of pre-Christmas. In that first article, I gave you a gift to help maintain your msdb undercarriage. Today I want to continue in that vein.
As is the tradition with the 12 Days of Christmas, each of these gifts should provide more value… Read more
Many of us have heard the song “The Twelve Days of Christmas.” Some are familiar with how that song has some connection with the Holiday season for Christians. Fewer are aware that this song is connected to the tradition of giving traditions on each of the days of Christmas. Fewer… Read more
T-SQL Tuesday #37
Sebastien has a month long blog going this month all about Joins. You can read all about… Read more
This is a quick rewrite of the script I just posted a few days ago. The script had a few flaws if trying to run it on a SQL 2005 box. I have updated it to run against SQL 2005 and up.
This version is done using Dynamic SQL to… Read more
We have all heard that backup is not complete until you test it by restoring it. We also know that part of a DR plan involves the testing of those backups through restores.
I recently had the opportunity to run through a test scenario and ran into a substantial failure.… Read more
Mickey Stuewe (sqlmickey)
Neil Hambly (neil_hambly)
Gail Shaw (sqlinthewild)
Ed Watson (SQLGator)
This is the short list of the many many many… Read more
Diligent DBAs like to check their databases for a little thing called corruption. Some of those DBAs are masterful at keeping records and logging that the database was checked and came up with a clean bill of health.
There are many different ways of logging this kind of activity. Today… Read more
Community – What is it?
Community is something that is improperly defined with words alone. Community is best defined through first person experience. Community is a feeling and a sense more than it is a definition in “pick your dictionary here.”
So how do you experience this thing we call… Read more
Will you be at Summit 2012?
I will be. I will even be pretty easy to find on multiple occasions. If you haven’t seen my schedule already – you can check it out here. You’ll probably notice that there are a few times where I… Read more
In case you have been living under a rock (I know it’s not under my rock), here is your notice that Summit 2012 is just a few days away at this point.
I will soon be boarding a jet bound for Seattle for a week full of all things SQL.… Read more
You may not know that this past Saturday ( October 20, 2012) was SQLSaturday 153 in Salt Lake City. If you knew about it, awesome. If you attended – even better. You probably don’t know that I was there presenting this year. I was a huge slacker in getting the… Read more