Tutorials for SQL Server 2016


Updated: July 26, 2016

Need help? Need help?MSDN Forum, Stackoverflow, Connect

SQL Server 2016 introduces many new technologies and features. Three new or significantly updated tutorials are available to help you get started quickly with SQL Server 2016.

There are plans to plans to provide additional tutorials in the future. Meanwhile, you can continue to learn from the tutorials published for previous versions. In some cases, you might find minor differences between the user interface in SQL Server 2016 and previous versions, or there might be subtle differences in tutorial prerequisites. If a tutorial uses one of the Adventure Works databases, you should download and use the SQL Server 2016 version.

If you are using a SQL Server 2016 server, the SQL Server 2016 data providers are installed. In order for the tutorials to work, you will either need the SQL Server 2016 sample databases that work with those providers, or you need the data providers that work with the previous version of the sample databases.

Previously published tutorials:

Analysis Services Tutorials (SSAS)Learn how to develop and deploy Analysis Services tabular or multidimensional models. Also learn how to use tools such as PowerPivot to analyze the data in the models.
Reporting Services Tutorials (SSRS)Learn how to create basic reports and subscriptions.
Integration Services TutorialsLearn how to create and deploy SSIS packages.
Database Engine TutorialsLearn how to connect to an instance of the database engine and then build and run Transact-SQL statements.
Replication TutorialsLearn how to set up and run replication topologies using SQL Server Management Studio.
Enterprise Information Management TutorialsLearn how to manage information in an enterprise using Microsoft EIM technologies.
SQL Server R Services TutorialsLearn how to work with SQL Server data using the R language, and run R scripts from Transact-SQL.

Community Additions