See how to work around some of the blockers for replacing legacy UDFs with STRING_SPLIT.

In this tip, I show how to measure the positive effects of delayed durability, in cases where a small amount of data loss is acceptable.

I explain a few details about the memory limits in SQL Server 2016 Service Pack 1 that make this upgrade even more compelling.

Microsoft has made a bold change with SQL Server 2016 Service Pack 1 : Many Enterprise features are now available in lower editions. Read on for details.

I show a few different ways to download SQL Server 2016 Developer Edition, which is a bit harder to obtain than it should be.

With additional tests comparing splitting techniques to TVPs, I round out my series on STRING_SPLIT() in SQL Server 2016.

I follow up on a recent post about the performance of STRING_SPLIT() with a few additional reader-motivated tests.

I talk about some of the upcoming changes to telemetry and other privacy settings in SQL Server 2016.

SQL Server 2016 RC0 introduces a new native string splitting function, STRING_SPLIT; I compare its performance to existing methods.

SQL Server 2016 allows you to enable instant file initialization during installation; I look at how this can impact tempdb data file creation.

I reveal details about the changes to Availability Groups that will ship in SQL Server 2016.

I list out the changes to In-Memory OLTP ("Hekaton") that will make the feature even more appealing in SQL Server 2016.

I show some interesting maintenance opportunities for Service Broker queues available in SQL Server 2016.

I explain how SQL Server 2016 improves tempdb configuration and performance.

I investigate the observable overhead involved with using a new SQL Server 2016 security feature, Always Encrypted.

A new feature introduces function statistics very similar to what we've had for procedures for ages.

I walk through some of the new JSON-related Transact-SQL functionality that will be available in SQL Server 2016.