Most Popular

Best Practices for Virtualizing SQL Server

It wasn’t that long ago that many companies thought that you couldn’t virtualize SQL Server because it was too resource intensive. However, with the advances that both Microsoft and VMware have made to Hyper-V and vSphere respectively today’s virtualization platforms are more than capable of running almost every enterprise workload – including SQL Server. This […]

Read More

Top Virtualization and IT Blogs

Discover, Alert, Remediate and Troubleshoot: Who does that anyways? In the past few weeks, I’ve introduced DART as the skills that virtualization admins need to develop and grow in order to become masters of their virtual universe. DART is an acronym for the skills of discovery, alerting, remediation, and troubleshooting. And they are basic skills […]

Read More

Designing a Monitoring Solution: Where Are Your Eyes?

Contemporary monitoring solutions are no different from any other distributed application in your environment. Even a small-scale deployment can include multiple components: often, these include a Web server, an application server, and a database server. And as with any distributed application, you need to consider placement for each component. More specifically, when you are charged with designing a monitoring […]

Read More

How to Identify and Fix SQL Server Index Fragmentation

Although SQL Server automatically maintains indexes after any INSERT, UPDATE, DELETE, or MERGE operation, some index maintenance activities on your databases may still be required, mostly due to index fragmentation. Fragmentation happens when the logical order of pages in an index does not match the physical order in the data file. Because fragmentation can affect […]

Read More

SQL Server Express as a Production Database

There are a lot of misperceptions and misinformation about Microsoft’s SQL Server® Express edition. Some of these misperceptions are holdovers from the limitations of previous releases, and others stem from misunderstandings about the product’s features and licensing. In this article, I’ll tackle some of the myths about using SQL Server Express as a production database, […]

Read More

SQL Server Latch Waits

Some SQL Server latches can come into contention with one another. This is intended and necessary as part of the need to serialize access. However, as with locking, this does raise the prospect of blocking, and consequently latch waiting.

Read More