To prevent and diagnose availability, health, and performance issues it is essential to review and manage the configuration of SQL Server instances and databases. Whether you want to view and modify ...

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

Microsoft SQL is a relational database you can configure to run as multiple copies, or instances, on a single computer. When running a small business, keeping multiple instances of Microsoft SQL on a ...

While SQL Server 2008 was little more than a service-pack level upgrade, the 2012 version of Microsoft’s database has a boatload of new features and delivers solid performance improvements.