You are following the documented best practices for Windows Server and SQL Server. You are using a dedicated server that runs SQL Server 2008 R2. You are using a single instance of SQL Server that is ...

Add Features to an Instance of SQL Server (Setup) [!INCLUDE SQL Server - Windows Only] This article provides a step-by-step procedure for adding features to an instance of [!INCLUDE ssCurrent]. Some ...

Pairing your on-prem SQL Server with a cloud-based instance for high availability has its challenges, but they can be overcome. Here’s how. The geographic distribution of cloud data centers makes it ...

Using a series of demos drawn from his latest book, Bill guides you through the maze of issues you'll face as you connect to, manage, and monitor SQL Server instances—including the new SQL Express ...