Monthly Archives: May 2011

SP1 for 2008R2

Time to install the Servicepack 1 for Windows 2008 R2? Be prepared to wait because this screen is what you will be looking at for almost one hour. Then suddenly it completes and your done! One hour, for a servicepack. … Continue reading

Posted in Windows Server | Leave a comment

Review of Quest Spotlight on SQL Enterprise

I’ve been using Quest – Spotlight on SQL Enterprise for a while and here are my thoughts. First some positive things about Spotlight on SQL Very easy to install. All you need is a server, preferably a dedicated for hosting … Continue reading

Posted in DBA | Leave a comment

Me, the exceptional DBA?

So I’ve nominated myself to the Exceptional DBA even though I don’t think I’m qualified to win. I’m in it just to participate, and that’s what Internet Communities are for! What is the Exceptional DBA? “Do you take the time … Continue reading

Posted in DBA | Leave a comment

Moving databases

When copying or moving databases to a new server, your new database server will probably have new logins with the same name but the logins will each one have a different sid. To verify this, run this after you’ve completed … Continue reading

Posted in SQL Server | Leave a comment

Shrinking database files

First rule of SQL Server is – You should not shrink files. Second rule is – You should not use auto shrink. Your log files should be enough big to have plenty of room for your data growth without the … Continue reading

Posted in SQL Server | Leave a comment

Large result sets

When doing a sort or other manipulation on a large result set, try to limit it down even though you use “top 100” in your select statement. A “top 100” won’t do any good when running an “order by” cause … Continue reading

Posted in SQL Server, Tips | Leave a comment

Deadlines

Has it ever happened that just days before the big release date, you get a new set of scripts to deploy in production? But it’s just a small change the developers say! Caramba! How are you going to verify those … Continue reading

Posted in DBA | Leave a comment