SQL Server Support, Failover Clustering and Virtualization

On May 19th, Microsoft has updated the Support Policy for Microsoft SQL Server products that are running in a hardware virtualization environment, which you can find at the following link: http://support.microsoft.com/kb/956893/en-us   The main update is related to guest failover clustering, therefore when you create a SQL Server failover cluster inside a virtual machine where…

0

Whitepaper - Disk Partition Alignment Best Practices for SQL Server

I’ve blogged some time ago about Microsoft recommendations for maximizing the performances of your disks subsystem for a SQL Server implementation:   SQL Server – Speed up your Disks! http://blogs.technet.com/beatrice/archive/2008/06/09/sql-server-speed-up-your-disks.aspx   Collection of SQL Server Storage Best Practices http://blogs.technet.com/beatrice/archive/2008/04/07/collection-of-sql-server-storage-best-practices.aspx   Finally there’s available directly from the SQL CAT Team a new whitepaper stating which are the …

0

Old MPS Reports Dismissed - New Version Ready!

A new version of MPS Reports has been released late April, at the following link: Microsoft Product Support Reports http://www.microsoft.com/downloads/details.aspx?FamilyId=CEBF3C7C-7CA5-408F-88B7-F9C79B7306C0&displaylang=en   Amongst the main differences:   With the new MPS reports, there is only one download, based on your system architecture (x86 or x64).  The supported Operating Systems for the new tool are Windows XP,…

0

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…

0

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…

0

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

Are you based in Manchester? Two upcoming FREE SQL events for your agenda!

If you are based in Manchester or nearby, there are two interesting FREE SQL Server events planned in town!   5th February: UK SQL Server Usergroup Agenda has still to be confirmed, and will be posted here: http://www.sqlserverfaq.com/events/147/Manchester-SQL-User-Group-Meeting.aspx   28th March: SQL Bits IV Agenda (once again) has still to be confirmed, but keep the…

0

How To - Proactively Know Upcoming SQL Server CUs and SPs

Umh, it has been a long time since my last post. I must admit, I’ve had brilliant holidays (relax and skiing) followed by a very bad flue, which summed up with all the XMas parties of 2008 makes 3 weeks without any post on my professional blog :-).   Well, if anybody out there had missed me,…

0

Released - Cumulative Update Package 1 for SQL Server 2005 Service Pack 3

Microsoft has just shipped the first Cumulative Update for SQL Server 2005 SP3.   This CU contains only hotfixes that were released in Cumulative Update 10 for SQL Server 2005 Service Pack 2 and Cumulative Update 11 for SQL Server 2005 Service Pack 2. These hotfixes are not included in SQL Server 2005 Service Pack…

1