When I meet SQL Server professionals, I am always interested to find out if they have deployed the latest version of SQL Server into production yet, if they are using Enterprise Edition, and, if so, ...

I have been testing SQL Server 2008 and I must admit, I’ve been impressed with the new features. I’ve written about some of the new functionality in past blog entries. One feature that I had not ...

If you’ve been managing databases for any length of time, you’ve probably had to contend with the “noisy neighbors” scenario. In this scenario, you have several applications, each with their own ...

The Resource Governor lets you define limits on CPU and memory usage for certain workloads. This is good enough to prevent some traffic jams — like query processes consuming too many resources on an ...

SQL Server 2008, aka “Katmai,” gives SQL Server shops plenty of reasons to get excited. The best SQL Server release to date, it sports more nice new features than you can count, and the improvements ...