SentryOne Team Blog (blogs.sentryone.com)

Tag: SQL Server 2016

Plan Explorer Support for SQL Server 2016

Aaron Bertrand (@AaronBertrand) explains how to get Plan Explorer to work with plans from the latest builds of Azure SQL DB and CTPs of SQL Server 2016.

Blogging from the PASS Keynote, Day 1

Aaron Bertrand (@AaronBertrand) recaps all of the announcements from today's keynote at the PASS Summit in Seattle.

Service Broker Enhancements in SQL Server 2016

Aaron Bertrand (@AaronBertrand) shows some interesting maintenance opportunities for Service Broker queues available in the next version of SQL Server.

New SERVERPROPERTY Options to Help Phase Out @@VERSION

Aaron Bertrand (@AaronBertrand) talks about new arguments to SERVERPROPERTY() that make @@VERSION even more obsolete (and changes that make @@VERSION problematic).

SQL Relay Slides and Demo Code

Another post, another set of slides and demo scripts. I have been out on the road for the last two weeks with SQL Relay 2015 here in the UK, travelling through Nottingham, Reading, London, Bristol, Cardiff, and Birmingham. Along the way I met a bunch of great speakers and had a lot of interesting conversations.

Stronger Security Via Always Encrypted in SQL Server 2016

Prior to SQL Server 2016, your main method for encrypting a SQL Server application was to use a feature called Transparent Data Encryption. TDE provides strong encryption, but with some shortcomings. First, you have to encrypt an entire database. No granularity is offered at a lower level, such as encrypting specific tables or certain data

SQL Server 2016 : Getting tempdb a little more right

Aaron Bertrand (@AaronBertrand) explains how SQL Server 2016 improves tempdb configuration and performance, and how there is still room for improvement.

Glenn Berry : Practical Processor Selection for OLTP Workloads

Glenn Berry (@GlennAlanBerry) provides some blueprints for how to decide whether newer processors are worth the investment to improve your OLTP workloads.

Tim Radney : SQL Server 2016 – Introduction to Stretch Database

Tim Radney (@tradney) walks through the configuration of a new SQL Server 2016 feature, Stretch Database, and discusses some of its limitations.

Aaron Bertrand : SQL Server 2016 : sys.dm_exec_function_stats

Aaron Bertrand (@AaronBertrand) shows the ins and outs of a new function that appeared in SQL Server 2016 CTP 2.1 this week: sys.dm_exec_function_stats.

SQL Server 2016 : CTP 2.1 is here!

Aaron Bertrand (@AaronBertrand) talks about the recent release of SQL Server 2016 CTP 2.1 and what changes you should expect.

Aaron Bertrand : T-SQL Tuesday #67 : New Backup and Restore Extended Events

Aaron Bertrand (@AaronBertrand) describes a new way to track backup and restore operations using Extended Events in SQL Server 2016.

SQL Server 2016 : JSON Support

Aaron Bertrand (@AaronBertrand) walks through some of the new JSON-related Transact-SQL functionality that will be available in SQL Server 2016.

Aaron Bertrand : SQL Server 2016 : In-Memory OLTP Enhancements

Aaron Bertrand (@AaronBertrand) lists out the changes to In-Memory OLTP ("Hekaton") that will make the feature even more appealing in SQL Server 2016.

Aaron Bertrand : SQL Server 2016 : Availability Group Enhancements

Aaron Bertrand (@AaronBertrand) reveals details about the changes to Availability Groups that will ship in the next major version: SQL Server 2016.