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

“We need seven nines of availability. By the way, our budget is $14.” Customer with lofty High Availability (HA) goals and no real budget to support it, unfortunately, is a common scenario for IT ...

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

SQL Server 2022 is a core element of the Microsoft Intelligent Data Platform and now it comes with new features. The platform seamlessly integrates operational databases, analytics, and data ...

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

The next SQL Server: Interview with Asad Khan of Microsoft Your email has been sent Learn about the latest features and future of SQL Server 2022 in this interview ...

Microsoft announced this week that it plans to release a "General Purpose" version of its Azure Arc-enabled SQL Managed Instance (MI) at the "general availability" (GA) commercial-release stage, ...

1. Change registry key SqlCluster in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.x\Setup\ from 1 to 0 2. Disable TCP/IP in Server Network Protocols and enabled Named Pipes from ...

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