A comparison of SQL Server's throughput performance on Microsoft Azure and Amazon Web Services (AWS) gives the edge to Microsoft's cloud.

Here is a list of common wait types and techniques that every DBA (or wannabe DBA) should know. While there are many more wait types than listed here, understanding these will give you a leg up when ...

Joey on SQL Server Deep Dive into SQL Server 2022's Query Performance Features, Part 2: PSP Optimization Reduce workload times with this handy feature that can benefit every database pro.

SQL Server is a robust and mature product and the number of features available to database administrators and developers continues to mount. Do not let fear of upgrading – to a new version or to a new ...

Tim Chapman discusses your iteration choices in SQL Server 2008 and explains why determining which option performs better depends on the situation.

Microsoft publishes SQL Server 2025 Release candidate with TLS 1.3, Ubuntu 24.04 support and many AI improvements. Reading processes are up to 50 times faster, but an important restriction remains ...

When you use index views in the right situations, they can dramatically improve the performance of SQL Server queries. Tim Chapman explains why performance testing is the best way to tell if ...

Intel's Hyperthreading Technology (HT) is being blamed for server performance problems. With both SQL Server and Citrix Terminal Server installations, HT-enabled motherboards show markedly ...

SafePeak is a plug-and-play Dynamic Database Caching Solution, designed to improve data access performance for Applications built on SQL Server. It offloads the read queries and stored procedures ...