SQL Server 2008 Service Pack 1 (SP1) CTP

Just woke up ready to celebrate my birthday (do not try to ask a woman how old she is :-P) and discovered the CTP version of SQL Server 2008 Service Pack 1 (SP1) is now available. Hum, well, I will check it out but definitely not today I am afraid as I have other plans in…


SQL Server 2005 Service Pack 2 is not successfully updated when you try to install or to uninstall a security update

If you recently found yourself in installing latest SQL Server 2005 Security Update (you did installed it right?):   Microsoft Security Bulletin MS09-004 – Important http://www.microsoft.com/technet/security/bulletin/MS09-004.mspx   ..and had a look to the known issues page… You might have had a heart attack (as I did at first) in seeing the following:   SQL Server…

1

DBCC DBREINDEX (aka INDEX REBUILD in 2005) and Statistics Update

So – today I’ve been made this question.   “I have a DB, AUTO_UPDATE_STATISTICS option OFF (very bad idea, anyway :-)), I rebuild my indexes every week.  I do not have major changes in my database. As update statistics with fullscan is a side effect of DBCC DBREINDEX (aka INDEX REBUILD in 2005), can I…


Microsoft Security Bulletin MS09-004 – Important

  For your joy (and especially for the joy of my customer :)) yesterday Microsoft has released a new Security Bulletin for SQL Server:   Microsoft Security Bulletin MS09-004 – Important http://www.microsoft.com/technet/security/bulletin/MS09-004.mspx   This update is marked as important, which stands for: “A vulnerability whose exploitation could result in compromise of the confidentiality, integrity, or…


Best Practices for installing SQL Server service packs, hotfixes, cumulative updates

There isn’t much information around (other than the readme for service packs) on which are the best practices on installing Service Packs, Cumulative Updates, Hotfixes on SQL Server installation. …well till today really 🙂   This is nothing official from Microsoft but still the following are the best practices recommended from my PFE colleague Uttam…

3