Slide background

Latest Builds of SQL Server 2014

Updated May 27, 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.

Jonathan Kehayias : Improved Support for Parallel Statistics Rebuilds

Jonathan Kehayias (@SQLPoolBoy) takes a closer look at a new trace flag that allows you to process multiple concurrent statistics updates on the same table.

Common Criteria Compliance: A True Story

Melissa Connors (@MelikaNoKaOi) explains the importance of the Common Criteria Compliance Enabled custom condition & avoiding unexpected performance issues.

Latest Builds of SQL Sentry Software

Updated May 26, 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.

Jason and the Case of “The Condition Mission”

Jason Hall (@SQLSaurus) demonstrates his creative writing prowess with a sort-of-fictional tale about Custom Conditions in SQL Sentry Performance Advisor.

Paul White : The Internals of WITH ENCRYPTION

Paul White (@SQL_Kiwi) discusses the internals of SQL Server's WITH ENCRYPTION clause, and explains why it is not as safe as you might think.

Slide decks and demos from #SQLDay Poland

Aaron Bertrand (@AaronBertrand) shares his PowerPoint files and SQL samples from his Bad Habits and tempdb sessions at SQLDay in Wrocław, Poland.

Visualizing Jobs (and more!) in Event Manager

Lori Edwards (@loriedwards) walks through some interesting details about the calendar view in SQL Sentry Event Manager, including creating Custom Event Views.

Latest Builds of SQL Server 2012

Updated March 22nd, 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: New Cumulative Updates for SP2 & SP3.

Setting Red Alert

Richard Douglas (@SQLRich) takes a tongue in cheek look at how you could extend Performance Advisor with the Internet of Things to create a real Red Alert scenario.

Is a RID Lookup faster than a Key Lookup?

For T-SQL Tuesday #78, Aaron Bertrand (@AaronBertrand) takes a look at whether RID Lookups are faster than Key Lookups, with a small battery of fairly simple duration tests.

Slide Decks & Demos from SQLBits

Aaron Bertrand (@AaronBertrand) shares his slides and demos from T-SQL and SQL Server 2016 sessions at SQLBits XV in Liverpool, UK.

VMware Workstation : "Internal Error"

Richard Douglas (@SQLRich) provides a quick tip on troubleshooting a less than helpful error message from VMware Workstation.

#BackToBasics : Definitions of SQL Server release acronyms

Aaron Bertrand (@AaronBertrand) explains some of the more common acronyms you may see flung around in blog posts, Connect items, and Knowledge Base articles.

Latest Builds of SQL Server 2016

May 3, 2016 : SQL Server 2016 is now at RC3 (13.0.1400), the last Release Candidate. Continue for updated downloads, release notes, and observed changes.