SQL Best Practices for MOSS

Hello all,  One question that arises often is how can we correctly configure SQL Server to work with MOSS?. Although the majority of best practices for SQL does apply, there are some diferences that it is important to be aware of. 1 – Architecture recommendation 1.1 – Limit content database size to enhance manageability Plan…


Cumulative update package 11 for SQL Server 2005 Service Pack 2

Hi everyone,   Our great SQL Server Releases Services Team, just release what I think it will be the last Cumulative Update for SQL Server 2005 SP2:  http://blogs.msdn.com/sqlreleaseservices/archive/2008/12/15/cumulative-update-11-for-sql-server-2005-service-pack-2.aspx This CU includes corrections for a good set of problems. Check the details in the KB Article: http://support.microsoft.com/kb/958735/en-us We’ll be waiting for the Service Pack 3! Greetings…


RML Utilities, version 9.01 Released

A new version of the RML Utilities for SQL Server, version 9.01, was released (with support for SQL Server 2008): http://blogs.msdn.com/psssql/archive/2008/11/12/cumulative-update-1-to-the-rml-utilities-for-microsoft-sql-server-released.aspx Review, also, the last minute update regarding a small issue when trying to run the installation setup with non-Admin privileges enabled: http://blogs.msdn.com/psssql/archive/2008/11/12/prb-rml-utilities-setup-may-always-prompt-for-report-viewer-2008-redistributable.aspx Cheers,  

How to script all my database objects? Here is the answer.

One question that sometimes arises is “How can we script all database objects throught some kind of automation?” You have several ways to do it.For both SQL 2000 and SQL 2005 you have Microsoft SQL Server Database Publishing Wizard that generates a single SQL script file which can be used to recreate a database (both…


CPU Drift and SQL Server timing values

We recently had an issue on a 2 node SQL cluster that led us to take profile traces. Soon we realized that some timing values from the traces didn’t make sense. After some research we turned to this:  SQL Server timing values may be incorrect when you use utilities or technologies that change CPU frequencies…


SQL Server – Performance Counters, Thresholds, etc.

These are normal questions:   What counters should I select to monitor my SQL Server instance? What thresholds or values should I use to know when something bad is happening?   Use this webcast to get answers:   TechNet Webcast: SQL Server Performance Counter Guidance http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?culture=en-US&EventID=1032357640&CountryCode=US   Jimmy May, is sharing an Excel file with some…

SQL Server & Disk Partition Alignment

Jimmy May is sharing a very good slide-deck about the importance of Disk Partition Alignment.   http://blogs.msdn.com/ace_team/archive/2008/11/04/disk-partition-alignment-sector-alignment-part-i-slide-deck.aspx   You can find some other useful information about this topic on the Microsoft web site:   ·         Predeployment I/O Best Practices – SQL Server Best Practices Articlehttp://www.microsoft.com/technet/prodtechnol/sql/bestpractice/pdpliobp.mspx   ·         Disk Subsystem Performance Analysis for Windows subsys_perf.doc http://www.microsoft.com/whdc/device/storage/subsys_perf.mspx  …

New Update of the SQL Server Management Pack (supports SQL Server 2000/2005 and now 2008)

A new version of the SQL Server Management Pack is available for download:   http://www.microsoft.com/downloads/details.aspx?familyid=8C0F970E-C653-4C15-9E51-6A6CADFCA363&displaylang=en (read carefully the System Requirements Section)   Release History:   3/23/2007 – Initial Release, version 6.0.5000.0 12/21/2007 – updated version 6.0.6247.5 3/31/2008 – Updated version 6.0.6278.8 10/29/2008 – Released version 6.0.6441.0, which introduced SQL Server 2008 support in addition to other…

Minimal Logging for SQL Server 2008

  Read carefully the SQL Server Storage Engine Team posts about the Minimal Logging feature, available with SQL Server 2008, using the Trace Flag 610:   http://blogs.msdn.com/sqlserverstorageengine/archive/2008/10/24/new-update-on-minimal-logging-for-sql-server-2008.aspx    These changes are available on SQL2008/RTM.   Cheers,

SQL Server 2005 SP3 CTP

So keeping the pace around SQL, a great announcement was made regarding Service Pack 3 for SQL Server 2005. With no further delays, just check SQL Server 2005 SP3 CTP Release from SQL Server Release Service or download directly from here. Cheers!