SQL Server 2008 R2 Best Practices Analyzer

A big part of my DBA career has centered around identifying and sharing SQL Server DBA best practices. There are literally hundreds of different best practices, and as you might expect, not every best practice applies to every SQL Server environment. That means, that as a DBA, you must evaluate the many commonly accepted best practices and determine which ones best meet your particular needs.

Continue reading

Advertisements

PAL 2.0 Beta Released

Back in 2008, I wrote a blog post about version 1 of the Performance Analysis of Logs (PAL) tool. This free tool, available from pal.codeplex.com, has been enhanced, and Version 2.0, Beta 1.1, is currently available for download. I have just downloaded and installed it myself, although I haven’t had much chance to use it yet. When I have time, I will write a review of the new version. In the meantime, I recommend you download it and give it a try. It’s a great tool for analyzing Performance Monitor Logs, and it is also a great source for determining which Performance Monitor counters, and thresholds, should be used when analyzing SQL Server’s performance.

New Free eBook: Defensive Database Programming with SQL Server

image

Simple-Talk Publishing has released a new, free 291 page eBook called Defensive Database Programming with SQL Server, by Alex Kuznetsov. Here is what the book covers, as described from the book’s introduction.

“Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, and of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment.

Continue reading

Learn How Vendors Price Their Software

image

As DBAs, we are often put in the position of purchasing software from third-party vendors. If you are like me, you are probably amazed at the wide variation in software prices, and how the price of a product seems to bear little relationship with its actual cost. For example, why is the SQL Server Enterprise Edition so much more expensive than the SQL Server Standard Edition?

Continue reading

Have You Checked Out the Upcoming SQLSaturday Events for 2010?

image

2010 is beginning to look like a great year for SQLSaturday events this year. Already, there are nine planned, and many more in the works. These free, one-day events are a great way to hone your DBA knowledge, and to develop new contacts. If you are interested in speaking at an event, its also a great way to get speaking experience.

Continue reading