SQL Server 2016 Service Pack 1 generally available

https://blogs.technet.microsoft.com/dataplatforminsider/2016/11/16/sql-server-2016-service-pack-1-generally-available/

Release Information: https://support.microsoft.com/en-us/kb/3182545

SQL 2016 SP1 Editions: https://www.microsoft.com/en-us/sql-server/sql-server-editions

DOWNLOAD: Microsoft® SQL Server® 2016 Service Pack 1 (SP1)

https://www.microsoft.com/en-us/download/details.aspx?id=54276

 

SQL Server 2016 Service Pack 1 (SP1) released !!!

https://blogs.msdn.microsoft.com/sqlserverstorageengine/2016/11/17/create-or-alter-another-great-language-enhancement-in-sql-server-2016-sp1/

CREATE OR ALTER – another great language enhancement in SQL Server 2016 SP1:

https://blogs.msdn.microsoft.com/sqlserverstorageengine/2016/11/17/create-or-alter-another-great-language-enhancement-in-sql-server-2016-sp1/

What’s new in SQL Server 2016 SP1 for Reporting Services:

https://blogs.msdn.microsoft.com/sqlrsteamblog/2016/11/16/whats-new-in-sql-server-2016-sp1-for-reporting-services/

Announcing a Technical Preview of Power BI reports in SQL Server Reporting Services:

https://blogs.msdn.microsoft.com/sqlrsteamblog/2016/10/25/announcing-a-technical-preview-of-power-bi-reports-in-sql-server-reporting-services/

all SQL Server 2016 editions will take advantage of the following advanced features:

• Always Encrypted
• Change Data Capture )
• Columnstore indexes
• Data Compression
• Database Snapshots
• Dynamic Data Masking)
• Fine Grained Auditing
• In-Memory OLTP)
• Multiple FILESTREAM Containers
• Partitioning
• Polybase
• Row Level Security)

Developers choice: Columnstore index in Standard and Express Edition with SQL Server 2016 (SP1):

https://blogs.msdn.microsoft.com/sql_server_team/columnstore-index-standard-and-express-editions-with-sql-server-2016-sp1/