SQL Server DBA
4 followers 0 articles/week
Do You Use “Forced Parameterization”?

In SQL Server 2005 and later, there is a database option called “forced parameterization”. When it is turned on, it overrides the default “simple parameterization” normally used by SQL Server. It does this by forcing most SELECT, INSERT, UPDATE, and DELETE statements to be parameterized, potentially boosting performance of databases by reducing the...

Sun Jun 30, 2013 01:14
SQL Server MVP Deep Dives: Volume II

Two years ago when SQL Server MVP Deep Dives: Volume 1 was released, I had the opportunity to contribute two chapters. In SQL Server MVP Deep Dives Volume 2, I not only had the opportunity to contribute a chapter, but the privilege of being the section editor of the “Performance Tuning and Optimization” section of […]

Sun Jun 30, 2013 01:14
Database Properties Health Check

For some time now, I have been working on a new book called How to Perform a SQL Server Health Check. I have written over 300 pages of it, and I am only about half way done. In the meantime, I have published a short except from the book on Simple-Talk.com. The article focuses specifically […]

Sun Jun 30, 2013 01:14
At the End of One Chapter and the Beginning of a New Chapter

I have been told by hundreds of DBAs that I have the best DBA job in the world as Director of DBA Education for Red Gate Software. And this has been very true. In the five plus years I have been with Red Gate I have traveled over 500,000 miles (breaking the million mile record on my frequent flyer program), slept in hotel rooms for just over 450 days,...

Wed Aug 15, 2012 20:26
Do You Document Your SQL Server Instances?

When I was a novice DBA, I spent little time documenting my SQL Servers. But as I became more experienced, I realized the importance of having complete, up-to-date documentation for all of the SQL Servers I manage. Some of the benefits of documentation include: 1) It is easier and quicker to find information when needed, especially if it is located...

Tue Jun 5, 2012 20:41
Favorite DBA Books

In the April 2012 Question of the Month, I asked readers to tell me their favorite DBA books. I have compiled the results, and below are the most popular books my blog’s readers picked. If you are looking for a good SQL Server book to learn from, then you might want to consider reading one or more of them. Click on the image to find out more about the...

Wed May 2, 2012 01:38

Build your own newsfeed

Ready to give it a go?
Start a 14-day trial, no credit card required.

Create account