SQL Server 2016 Service Pack 1 introduced CREATE OR ALTER. I use it for repeatable deployments of supported object types.
SQL SERVER – SSMS Enhancement – Databases Node Filter Capability
A client with 86 databases struggled to find one in Object Explorer. A newer SSMS Enhancement lets you filter the Databases node. Here is how it works.
How to Get Started with SQL Server 2016? – Interview Question of the Week #086
A candidate asked me in an interview: how do I get started with SQL Server 2016? Here is my answer for anyone who has not tried it yet.
SQL SERVER 2016 – Encrypt Your PII Data – Notes from the Field #132
Mike Lawell found a client storing personal information in clear text. He explains how SQL Server 2016 encryption options can protect your PII data.
SQL SERVER 2016 – Developer Edition Does Not Expire Like Evaluation Edition
Developer Edition is not the 180-day Evaluation Edition. I check the edition before treating a calculated date as an expiration.
SQL SERVER 2016 – InMemory OLTP LOB Datatype Enhancement
SQL Server 2016 brings InMemory OLTP LOB datatype support to memory-optimized tables and natively compiled procedures. Here is what I found exploring it.
SQL SERVER – Maintain Carriage Return (Enter Key) in SQL Server 2016 Management Studio While Copy and Paste
Copy grid results with line breaks and paste them: SQL Server 2016 Management Studio drops the carriage returns. Here is the setting that keeps them.