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

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

With the official release of Microsoft's latest database offering, let's see what was improved and what still needs some work ...

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

Is it possible to have a SQL Server 2005/2008 instance respond under multiple "aliases" for the same server.<BR><BR>Eg. You've got SQL Server installed, and an ...

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

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

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

As SQL Server 2008 and 2008 R2 reach the end of support in 2019, you’ll have an opportunity to upgrade to a cloud database service. Follow this step-by-step guide to manage change effectively as you ...

Brien M. Posey is a freelance technical writer who has contributed to dozens of books and is a six-time Microsoft MVP award winner. SQL Server 2005 reaches its end-of-life milestone on April 12, the ...