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

Maintaining a SQL Server environment is a potentially complex endeavor. Here are 10 tips for ways you can minimize complexity and reduce stress. Based on my SQL Server consulting practice, here are ...

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

The successful migration from purely private to public and hybrid cloud arrangements has substantially increased the level of confidence IT administrators have in the cloud. And among the top cloud ...

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.