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

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

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

SQL Server Management Studio (SSMS) is the principal interface for working with Microsoft SQL Server. However, many subtleties of this powerful tool evade even the most seasoned professionals. Here ...

One way that organizations are storing data in the cloud is by moving their databases to the cloud. What once meant building an entire physical server, patching it, installing software like Microsoft ...

As you will see in this chapter, companies use SQL Server for many types of applications and on most tiers now. Gone are the days when you would second guess yourself choosing to use SQL Server over a ...