November 2008 - Posts
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,
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
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:
Read More...
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
Read More...
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!
Read More...
