Michael Otey, Senior Technical Director for SQL Server Pro, outlines in this webcast video how to take advantage of all the options for SQL Server vritualization while also gaining the most performance advantages.
Microsoft has updated the best practices for using SQL Server in Azure. There is now a checklist of 18 items that customers should review as part of the SQL Server deployment in a virtual machine (VM) that resides on Microsoft Azure....More
Michael Otey, Senior Technical Director for SQL Server Pro, outlines in this webcast video how to take advantage of all the options for SQL Server vritualization while also gaining the most performance advantages....More
Virtualizing SQL Server provides many benefits. However, due to SQL Server's resource-intensive nature, there are a few best practices you need to follow to make sure your virtualized SQL Server instances perform well....More
In managing a database or sometimes numerous databases, we often get caught up in the day-to-day maintenance and lose sight of the other principles we know are critical to ensuring optimal performance. Here’s a quick refresher....More
Alerts represent a great way to take a proactive stance on being notified or alerted when something ugly, potentially ugly, or important happens on a SQL Server. On most servers that I manage, I typically deploy a whole bevy of different alerts....More
When setting up HA or HA+DR solutions with SQL Server AlwaysOn Availability Groups, it's critical to remember that the basic unit of failover in these scenarios is the availability group (or the group of user-defined databases)....More