November, 2008

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...

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...

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...

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...

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...

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...

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...

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...