Slide background

New SQL Sentry Custom Conditions Pack

Melissa Connors (@MelikaNoKaOi) shows you what's new in the latest SQL Sentry Custom Conditions Pack for more intelligent alerting options.

Latest Builds of SQL Sentry Software

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

Glenn Berry : Database Hardware and Infrastructure Trends

Glenn Berry (@GlennAlanBerry) provides the SQL Server DBA some insight into the ever-changing world of hardware and infrastructure.

A "drop column" fix you'll want for SQL Server 2012 / 2014

Aaron Bertrand (@AaronBertrand) cautions about using DROP COLUMN without immediately rebuilding the table. Wasted space is a concern; data loss is worse.

STRING_SPLIT() in SQL Server 2016 : Follow-Up #2

Aaron Bertrand (@AaronBertrand) shows that, at least for a large number of integer parameters, it is actually OPENJSON() that beats both the new STRING_SPLIT() function and TVPs, and leaves traditional splitting methods in the dust.

SQLBits PreCon 2016

After the success of the PreCon session we held at PASS Summit last year, the team have decided to fly over and do one on this side of the pond at SQLBits!

STRING_SPLIT() in SQL Server 2016 : Follow-Up #1

Aaron Bertrand (@AaronBertrand) follows up on a recent post about the performance of STRING_SPLIT() with a few additional reader-motivated tests.

Latest Builds of SQL Server 2014

Updated April 18, 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.

Latest Builds of SQL Server 2016

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

Configuring a PolyBase Cluster

David Benoit (@SQLTentMaker) walks through the process of configuring a scale-out PolyBase cluster with SQL Server 2016 and Azure Blob Storage.

Performance Surprises and Assumptions : DATEADD()

Aaron Bertrand (@AaronBertrand) explores yet another scenario where a date/time function seems to cause the optimizer to behave unexpectedly.

Paul Randal : Knee-Jerk Performance Tuning : Temp Tables

Paul Randal (@PaulRandal) continues his knee-jerk performance tuning series, focusing on ways to optimize performance when using temporary tables.

#BackToBasics : Dating Responsibly

As part of his #BackToBasics series, Aaron Bertrand (@AaronBertrand) gives four quick tips on using date and time values effectively in SQL Server.

What might the SSMS changes mean to you?

After the first Visual Studio 2015-based SSMS build is released, Aaron Bertrand (@AaronBertrand) talks about the changes you'll notice, and the changes you won't (yet).