Slide background

Pin the Blame on the Query

Last week's Visual Studio outage has been largely blamed on the cardinality estimator, but Aaron Bertrand (@AaronBertrand) says the query itself has a share of the blame.

Latest Builds of SQL Server 2014

Updated February 9, 2016 : SQL Server 2014 has new, stabilizing cumulative updates for both the RTM and Service Pack 1 branches, and more recently, TLS 1.2 support.

DBA Pre-con – SQLSaturday Edinburgh

John Martin talks about the up-coming pre-con SQL Server 2016 Masterclass: 360 Degree View for the DBA he and Richard Douglas are presenting in Edinburgh.

Latest Builds of SQL Server 2016

February 5, 2015 : SQL Server 2016 is now at CTP 3.3 (13.0.1000.281). Continue reading for updated downloads, release notes, and observed changes.

#BackToBasics : The "Runaway" Query

Aaron Bertrand (@AaronBertrand) describes a few different causes for a symptom you might describe as a "runaway" query in SQL Server.

SQL Server support for TLS 1.2 – Read This First!

Microsoft has announced support for TLS 1.2 in SQL Server 2008, 2008 R2, 2012, and 2014. However, there are a few issues right now.

Latest Builds of SQL Server 2012

Updated January 30, 2016 : SQL Server 2012 is now at Service Pack 3, but regardless of what build you're on now, read this post to see what you should know before deploying. Most recent update: TLS 1.2 support.

Latest Builds of SQL Sentry Software

Updated January 28, 2016 : This post is intended to give you a single location to determine the latest general release version of our software components, as well as links to downloads, change lists, documentation, and product-related blog posts.

Come to SQLintersection – We Have Disney!

We will be part of the SQLintersection event at the Walt Disney World Swan in Florida in April. Read on to see why you should be there too!

Subjectivity : Naming Standards

Aaron Bertrand (@AaronBertrand) discusses a few counterpoints to a very thorough and useful post on database naming standards.

Delayed Durability while Purging Data

Melissa Connors (@MelikaNoKaOi) investigates using SQL Server's delayed durability feature to improve performance while purging data.

#BackToBasics : Common Table Expressions (CTEs)

Aaron Bertrand (@AaronBertrand) presents his first "BackToBasics" post of 2016, giving an introduction to common table expressions (CTEs).

Tim Radney : Tuning : A Good Place to Start

Tim Radney of SQLskills gives an overview of his approach to SQL Server performance tuning, from system configuration, to I/O latency, to high cost queries.