SQL Server 2016 makes TempDB more scalable out of the box. Here are the enhancements with TempDB, from setup options to less contention under load.
SQL Server – T-SQL Enhancement “Drop if Exists” clause
Tired of IF OBJECT_ID checks before every DROP? SQL Server 2016 adds a T-SQL enhancement I wanted for years, the DROP IF EXISTS clause. Here is how it works.
SQL SERVER – New features in SQL Server 2016 Setup Wizard
Microsoft listened to feedback, and the SQL Server 2016 Setup Wizard shows it. Here are the new options I noticed, such as Perform Volume Maintenance Task.
SQL Server – 2016 – New Feature: Dynamic Data Masking
Would you want your credit card number shown in clear text? Dynamic Data Masking, new in SQL Server 2016, hides sensitive data right in the database.
Row-Level Security for Reports
Use SQL Server row-level security for reports with predicate functions and SESSION_CONTEXT, and test every identity boundary.
NO_PERFORMANCE_SPOOL: Compare the Work Before Keeping the Hint
NO_PERFORMANCE_SPOOL changes one query optimization decision. A guarded private fixture compares baseline work, the optional hint and a supporting inner index. The article explains how to preserve results and assess actual child work without promising a plan shape.
Always Encrypted in Plain Words
Explain Always Encrypted in plain words, including client-held keys, deterministic and randomized encryption, query limits, and operations.