Category: SQL Server

Find out the build number of each SQL Server 2017 build as it is released, discover where to download, and how to get details on new fixes and features.
See updated downloads, security fixes, release notes, and observed changes for builds of SQL Server 2016.
Find information about the builds of SQL Server Management Studio (SSMS) in the new release cycle approach or locate previous versions.
September 24, 2019 | Community Team | Management Studio, SSMS, SQL Server 11
In this blog post, we answer your top questions on the top concepts that every SQL Server generalist or accidental DBA has to learn.
September 13, 2019 | Kevin Kline | SQL Server, Career 1
See the builds, release dates, and database versions of SQL Server 2019.
Glenn Berry talks about AMD's current streak of processor innovation and how the single socket EPYC may better serve your SQL Server workloads.
August 27, 2019 | SQLPerformance.com | SQL Server 0
Paul White takes a deep dive into SQL Server batch mode bitmaps revealing undocumented details that can greatly impact performance.
August 23, 2019 | SQLPerformance.com | Performance, SQL Server 0
MSPs are smart to choose database solutions, including monitoring tools, that offer the same performance regardless of whether their clients' databases are located on-premises or in the cloud.
Paul White explains minimal logging for inserts into b-tree indexes using Fast Load Context, and why it might not always work as expected.
May 29, 2019 | SQLPerformance.com | SQL Server, Indexes 0
Erin Stellato discusses the performance impact of a predominately adhoc workload in SQL Server.
Paul White explains in detail the factors SQL Server considers when enabling minimal logging for inserts into an empty clustered table.
Itzik Ben-Gan resumes his blog series on T-SQL bugs, pitfalls, and best practices, treating an issue with correlated column references in subqueries.
Paul Randal provides a detailed introduction to troubleshooting SQL Server workload performance using wait statistics.
Paul White explains in detail the factors SQL Server considers when enabling minimal logging for inserts into a table without a clustered index.
With Azure SQL Data Warehouse and SentryOne, migrate to Azure with confidence and receive breakthrough cloud analytics performance at the best price.

Top Categories

See all

Get the best SQL query analysis and optimization tool – free!

Plan-Explorer-logo-RGB-800px
  • Index Analysis Sandbox
  • Statistics Analysis with Histogram
  • Management Studio Add-in
  • Plan Diagram
  • Deadlocks
  • History and Comments
Free Download Learn More