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

Troubleshooting Performance Problems in SQL Server 2008

A new great whitepaper to bookmark amongst your favourites:   Troubleshooting Performance Problems in SQL Server 2008 http://msdn.microsoft.com/en-us/library/dd672789.aspx   This documentation provides step-by-step guidelines for diagnosing and troubleshooting common performance problems by using publicly available tools such as:   SQL Server Profiler System Monitor (in the Windows Server 2003 operating system) or Performance Monitor (in…

0

Download SQL Server 2008 SP1

SQL Server 2008 SP1 final version has been released.   It contains all the announced great new features that we were all looking forward to, especially the slipstream and uninstall ones, which could save a lot of time (and headhackes) at installation time.   So just to recap, new features are:   Slipstream – You…

0

I’ back to Italy… and I’m loving IT!

Well well, long time without posting once again.   This time I have a good enough reason… which is my relocation back to… La Dolce Vita.   Yes, exactly, I am back in Italy, back to Milan, back to the place I grown up and where I have all of my family! Working in Microsoft…

0

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…

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