Best Practices Analyzer

Microsoft has been working hard to release their own tools which help DBAs and IT professionals to get a hang of their database systems.

The Bets Practices Analyzer is not a new concept – it is available for SQL 2000, SQL 2005 and SQL 2008 (and for R2!).

What it does is exactly what the title suggests:

Continue reading […] Best Practices Analyzer […]

 

Book review: SQL Performance Tuning techniques using wait statistics, Types and Queues

The real professional inspiration comes not from quantity but from quality. This becomes even more obvious by the thin book written by Rick A. Morelan and Pinal Dave on ‘SQL Performance Tuning techniques using wait statistics, Types and Queues’.

 

The topic is indeed one of the most often misunderstood and underestimated ones in performance tuning; and

Continue reading […] Book review: SQL Performance Tuning techniques using wait statistics, Types and Queues […]

 

Upgrading the edition of SQL Server

Today I realized that I had a clustered instance of a SQL Server 2008 R2, which was installed as a Standard edition.

The databases which were about to be moved to that instance were residing on a Enterprise edition test environment, and I know for a fact that they were utilizing some of the Enterprise features.

By

Continue reading […] Upgrading the edition of SQL Server […]