I forget when I first discovered newsgroups. After all, I have been online for what seems like my entire life and have bounced from one forum to another. But as the Internet has evolved one thing remains true for me: newsgroups are an awful way to communicate and get help. Would you consider posting a … Read more
Well today was one of those days where there just does not seem to be enough time to take care of everything on your plate. Of course you want to finish what you have, after all it is just sitting there, and it would be rude to not finish your meal, your host might be … Read more
Every now and then I see requests come to our team that say “hey, buddy, when was the last time that database was restored?” My first thought has been, historically, “how the hell am I supposed to know that?” After all, the management tools given to us (EM, SSMS) never list a “last restore date” … Read more
Last week I attended another Hands-On-Lab at the MTC center in Waltham, MA. One of the new SQL 2008 features I was able to kick around was SQL 2008 SQL Server Audit. Truthfully, I did not even know about this feature until I was handed the lab sheet. Fortunately I was already planning on spending the day … Read more
I hate database triggers. Whew. It feels good to get that out in the open. I have been holding that in for almost ten years. It got harder to admit after I became a DBA, and as time went by it started to feel as if I was trapped in a story by Edgar Allen … Read more
One of my favorite new features for SQL 2008 is the ability to run commands against all your registered instances immediately. For me that saves time as I have over 150 instances (and growing). The other day I was reading Tim Ford’s blog entry about xp_logininfo which led to an exchange of emails between Tim … Read more
