Last week, Ntirety’s Rodney Landrum gave a presentation on Microsoft SQL Server 2016 Service Pack 1 to highlights some of the best new features.  The demonstration includes his favorite features:

  • Query Store
  • Database Cloning
  • Dynamic Data Masking
  • Reporting Services

He also reviews Enterprise features that are now available in Standard Edition:

  • Always Encrypted
  • Polybase
  • Fine Grain Auditing
  • Database Snapshot
  • Row Level Security
  • Advanced Analytics with R Services

As a special bonus, Rodney reviews new information in Dynamic Management Views and SQL Error Log that should make any DBA happy.

In case you missed it, a replay is available:


About Rodney Landrum

Rodney Landrum went to school to be a poet and a writer. And then he graduated so that dream was crushed. He followed another path, which was to become a professional in the fun filled world of Information Technology. He has worked as a systems engineer, UNIX and network admin, data analyst, client services director and finally as a database administrator. The old hankering to put words on paper, while paper still existed, got the best of him and in 2000 he began writing technical articles, some creative and humorous, some quite the opposite. In 2010 he wrote SQL Server Tacklebox, a title his editor disdained, but a book closest to the true creative potential he sought; he still yearns to do a full book without a single screen shot. He currently works from his castle office in Pensacola, FL as a senior DBA consultant for Ntirety, a division of Hosting.

Follow Rodney’s blog: