Microsoft SQL Server installation is simple when system requirements and edition choices are planned.Choosing the right authentication mode, such as ...

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.

This week we will discuss how to troubleshoot different assembly errors that we get while troubleshooting installs for SQL Server. I’ll focus this article more on SQL Server and Windows systems.

Get the lowdown on SP-1's added features, including fully supported database mirroring, bug fixes, and add-ons for SQL Express. What's more, SP1 not only contains bug fixes, but also delivers ...

Installing SQL Server on Windows Server 2008 R2 64-bit is not as simple as it appears Most of my test servers are still 32-bit machines. It’s not until recently that I have started to use 64-bit ...

Recently organizations, fellow SQL Server MVPs and DBAs have asked me for resources on how to install a SQL Server 2008 Failover Cluster from both a SQL Server and a Windows Server 2008 perspective.