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

One of the most useful features in Microsoft's System Center Operations Manager (SCOM) product is its reporting engine. Even though there is nothing overly difficult about its installation process, ...

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

Use custom-built .NET Framework 4.0 classes to connect an ASP.NET Web application to a SQL Server 2012 database. In my recent article, I showed how to connect .NET 4.0 C# and Visual Basic applications ...

A step-by-step guide to deploying, configuring, and testing a multi-AZ, multi-region SQL Server FCI in the Azure cloud, complete with a PowerShell script that handles the networking configuration.

DBAs have many options for how to ensure high availability (HA) for SQL Server. Some of these options are available in the different versions and editions of SQL Server itself. Some are available in ...