By: Jeremy Kadlec | Comments | Related: > SQL Server 2016
Problem
Microsoft has officially announced the release of SQL Server 2016 as June 1, 2016. Learn how to get ready with more than 60 tips from the team at MSSQLTips.com. Know the new features, see how you can better support your organization and hit the ground running.
Solution
With the release of SQL Server 2016 less than a month away, now is a great time to build your educational plan to begin learning about SQL Server 2016, get the product installed and reap the benefits from the new features as well as the unparalleled performance gains. Let's jump in...
SQL Server 2016 Official Release
This week on the SQL Server Blog Microsoft announced the release date (i.e. June 1, 2016), product features and touted some pretty amazing performance gains (7x faster throughput, 34x faster queries and 3.6x faster reporting).
>>> Read the post.
SQL Server 2016 Release Candidate 3
Since the production release is a few weeks away, you can begin learning about SQL Server 2016 with the current release candidate which is a 180 day evaluation version.
>>> Download now.
Build Your SQL Server 2016 Plan
- First, educate yourself on the new features that are shipping with
SQL Server 2016 based on the edition.
- Take a few hours each week to educate yourself on the features and how they apply to your organization.
- Share a resource per week with your team to keep them in the loop.
- Formalize your training plan as you learn all that SQL Server 2016 has to offer.
- Second, think about the needs (performance, availability, security, flexibility, etc.) your organization has and how SQL Server 2016 can help.
- Third, setup a testing environment for your team to learn and build a proof of concept with the new features.
- Fourth, demonstrate the business and technology value of SQL Server 2016 to your organization.
- Fifth, get SQL Server 2016 on the roadmap to upgrade critical systems and/or for new application needs.
SQL Server 2016 Learning Resources
The MSSQLTips.com Team has been very excited about the SQL Server 2016 release and has been publishing tips since Release Candidate 0. Check out how the MSSQLTips.com Team can help you learn SQL Server 2016.
- Introduction to SQL Server 2016 Temporal Tables
- SQL Server 2016 T-SQL Syntax to Query Temporal Tables
- SQL Server 2016 Database Scoped Configuration Options
- SQL Server 2016 Database Scoped Configurations for MAXDOP, Procedure Cache and Cross Database Queries
- Advanced JSON Techniques in SQL Server 2016 - Part 2
- Advanced JSON Techniques in SQL Server 2016 - Part 3
- Introducing JSON for SQL Server 2016
- Phase out CONTEXT_INFO() in SQL Server 2016 with SESSION_CONTEXT()
- SQL Server 2016 Advanced JSON Techniques - Part 1
- T-SQL Enhancements in SQL Server 2016
- Reading Always Encrypted Data with SQL Server Integration Services 2016
- SQL Server Integration Services 2016 Lookups With Always Encrypted Data
- Understand the Limitations of SQL Server Dynamic Data Masking
- Writing Always Encrypted Data with Integration Services 2016
- Integration Services Logging Levels in SQL Server 2016
- SQL Server Integration Services 2016 Control Flow Templates Introduction
- SQL Server Integration Services 2016 Incremental Package Deployment
- Getting Per Session Wait Statistics in SQL Server 2016
- In Memory OLTP Changes in SQL Server 2016
- Live Query Statistics in SQL Server 2016
- Plan Forcing with the Query Store in SQL Server 2016
- SQL Server 2016 Compare Showplan Option
- SQL Server 2016 Query Store Example
- SQL Server 2016 Query Store Introduction
- SQL Server 2016 Query Store Queries
- SQL Server 2016 Query Store SSMS Panes
- Troubleshoot SQL Server Function Performance with the sys.dm_exec_function_stats DMV
- Create a Treemap Graph in SQL Server Reporting Services 2016
- Customize the SQL Server Reporting Services 2016 Parameter Pane
- Exporting SQL Server Reporting Services Reports to PowerPoint
- Getting started with R scripts and R visuals in Power BI Desktop
- How to create a heat map graph in SQL Server Reporting Services 2016
- How to create a Sunburst Graph in SQL Server Reporting Services 2016
- SQL Server 2016 R Services: Display R plots in Reporting Services
- SQL Server 2016 R Services: Executing R code in Revolution R Enterprise
- SQL Server 2016 R Services: Executing R code in SQL Server
- SQL Server 2016 R Services: Guide for Client Configuration
- SQL Server 2016 R Services: Guide for Server Configuration
- SQL Server 2016 Reporting Services Mobile Report
- SQL Server Reporting Services 2016 Subscription Enhancements
- What's New for BI in SQL Server 2016 Webcast Q&A
- Implement Row Level Security Natively with SQL Server 2016
- SQL Server 2016 Always Encrypted
- SQL Server 2016 Row Level Security Block and Filter Predicates Example
- SQL Server 2016 Row Level Security Example
- SQL Server 2016 Row Level Security Introduction
- SQL Server 2016 Row Level Security Limitations, Performance and Troubleshooting
- Test Performance Overhead of SQL Server Row Level Security
- Use Dynamic Data Masking in SQL Server 2016 CTP 2.1
- Automatic Updates for SQL Server Management Studio
- Install SQL Server Management Studio with Web Installer without Internet Access
- New Features in SQL Server Management Studio for SQL Server 2016
Next Steps
- Be ready for the SQL Server 2016 release on June 1, 2016 with the resources from this tip.
- Show your value to the organization as a SQL Server Professional by leveraging the new opportunities available with SQL Server 2016 to address critical business and technology issues.
About the author
Jeremy Kadlec is a Co-Founder, Editor and Author at MSSQLTips.com with more than 300 contributions. He is also the CTO @ Edgewood Solutions and a six-time SQL Server MVP. Jeremy brings 20+ years of SQL Server DBA and Developer experience to the community after earning a bachelor's degree from SSU and master's from UMBC.This author pledges the content of this article is based on professional experience and not AI generated.
View all my tips
