Do you need to find out where the location of your SQL Server's database is? Here's a quick tip. Written by Arthur Fuller, Contributor March 4, 2004 at 12:45 a.m. PT Read now ...

If enabled, the default instance of Microsoft SQL Server listens on TCP port 1433. Named instances are configured for dynamic ports, so an available port is chosen when SQL Server starts.

SOS_SCHEDULER_YIELD —SQL Server instances with high CPU usage often show the SOS_SCHEDULER_YIELD wait type. This doesn’t mean the server is underpowered; it means further research is needed to find ...

If this option is blank, double-check to make sure you have installed the Reporting Service on your SCOM server, not on your SQL Server. Figure 8: Choose your Reporting Service instance.

A database mirroring system consists of two or three SQL Server 2005 instances: principal server, mirror server, and an optional witness server. As mentioned earlier, Express and Workgroup editions ...

Azure SQL Managed Instance General Purpose is "a tier of Microsoft's relational database service, based on SQL Server, that operates like an on-premises SQL Server instance," Snodgrass explained ...

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.