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 […]
Category: News
On the Third Day…
Mais Oui! 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 […]
On the Second Day…
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 […]
On the First Day…
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 […]
Let’s Talk About Joins
T-SQL Tuesday #37 This month please join us in the TSQL blog party that happens on the second tuesday of the month. It is hosted this month by Sebastian Meine (@sqlity). Sebastien has a month long blog […]
Backup History
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 […]
Differential Restore Fail
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 […]
Most Interesting People…
Here are the most interesting people I met at PASS Summit 2012 Mickey Stuewe (sqlmickey) Neil Hambly (neil_hambly) Bob Hovious Gail Shaw (sqlinthewild) Ed Watson (SQLGator) This is the […]
Last Known Good CheckDB
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 […]
T-SQL Tuesday #36 SQL Community
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 […]