SQL Server Standard Now Does All the Cool Tricks

With the introduction of SQL Server 2016 SP1 Microsoft has made all of the database design and programming techniques that had been Enterprise Edition features available in Standard Edition. This talk will introduce the newly available features and show how they can be of great benefit to Standard Edition users. Some of the highlighted features are: • Row Compression and COLUMNSTORE • In-Memory database tables and natively compiled code • Table partitioning • Always Encrypted • Row-Level Security and Dynamic Data Masking These features will be explained with examples of how them can benefit even a small or medium size database under standard edition.