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 ...

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 ...

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 ...

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, ...

SQL Server 2008 has been significantly enhanced since the previously released versions. Moreover, the product continues to support Microsoft’s data platform vision of mission-critical enterprise data ...

Database troubleshooting is not for the faint of heart, especially when it comes to troubleshooting locking and blocking problems. Sometimes the elephant in the room is actually a rhino, a problem ...

The next preview of SQL Server 2008 supports spatial data types and a new Resource Governor feature is slated to hit in a week or two. The next preview of SQL Server 2008 with new support for spatial ...

Microsoft has made some big promises for SQL Server 2008, a major update of its enterprise database product. No precise date has yet been announced for the launch, but the new features have caught the ...

SQL Server 2014 is a major upgrade that also has a host of invaluable smaller improvements, but you'll need to invest time in database design to get the most from it. Why you can trust TechRadar We ...