Well, he went and did it again, Chris Shaw started yet another web chainpost. This time he tagged Brent Ozar and Brent tagged me and put the pressure on me to be “witty” in my response. I swear, it’s like he doesn’t even know me. So, this quiz is a two parter, which makes me … Read more
Every now and then I get an email asking me if I can remove some of the databases on server ‘X’ that have not been used in quite some time. I am always curious as to how someone has already ascertained that the database has not been used so I ask them the question and I … Read more
What are you doing on September 2nd, 2009 around midnight Greenwich Mean Time? No plans yet, you say? How would you like to take part in the inaugural 24 Hours of PASS event? You would? Wonderful! Go here and register: http://24hours.sqlpass.org/ Still not sold yet? Well then, check out the sessions and just look at … Read more
I wrote a couple of posts previously on SQL Server consolidation. The first post tried to give some insight on some of the problems and associated motivating factors that most companies have for consolidation efforts. The second post was an attempt to cover some of the decision factors that could drive a company to decide … Read more
I had a tip published over at MSSQLTips yesterday and wanted to drop a quick post to brag tell people about it. The tip is very straightforward, it uses xp_fileexist to verify if your database dumps are still on disk or not. Keep in mind that xp_fileexist is one of those undocumented stored procedures, which … Read more
Consider for a moment that you have a deck attached to your house. It is one story above ground level and is growing weaker with each passing year. The former homeowner painted (!) the deck making your options for upkeep quite limited. And what would those options be? Well, most people would look to have … Read more
