Read SQL Server 101 and learn more about SQL Server’s architecture and management basics. This useful guide also covers working with the SQL Server optimizer and execution plans. Learn more.

Thanks to Roger Jennings for a great article about the performance implications of various SQL Server access methods ["Optimize SQL Server Data Access," November 2003]. However, I'd like to point ...

Learning SQL opens up career opportunities because it’s used by the most common relational database management systems, including Oracle, Sybase, Microsoft SQL Server, Access, and Ingres.

This wait type may also indicate the SPID is waiting for remote procedure calls, linked server queries, BULK INSERT commands, or full-search queries. PAGEIOLATCH_* —Buffer latches, including the ...

It's not, as Mary Ann Richardson shows us. SQL Server lets you use one command to quickly create a new table containing a subset of records from a larger table. For example, suppose in Access you ...

Warnings Information in this article applies to Microsoft SQL Server 2012. The instructions for earlier versions of SQL Server, including versions 2008 and 2005, are similar.

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.