Microsoft IT Camps: SQL Server 2016 Hands-On Workshop

Join this complimentary instructor-led, hands-on training event to learn how SQL Server 2016 can help you to upgrade your database performance with these new features:

  • new in-memory technologies;
  • instant insights with built-in operational analytics;
  • new comprehensive security features to protect your data at rest and in motion
  • leverage the cloud for SQL Server back-up and disaster recovery

Attendees will explore new and enhanced features of SQL Server 2016 through hands-on workshops. All lab equipment will be provided.

Locations in CanadaThis Microsoft event is coming soon to a city near you. Find your location below and register today!

Workshop Content:

High Availability and Disaster Recovery

Understand how to quickly and easily set up Always-On Availability groups to ensure your databases and customer-facing applications are always available. Technologies: AlwaysOn, Temporal Tables

Performance upgrades for OLTP and Data Warehousing

Utilize in-memory online transaction processing (OLTP), Query Store, Columnstore Indexes, and Operational Analytics to derive more value from your existing infrastructure. Technologies: In-memory OLTP, Query store, Columnstore Index, Non-clustered Columnstore Indexing, AMR tool, Compression Improvements,


Experience enterprise grade security with features that go well beyond just access control lists. Make your data secure with industry leading encryption and data masking techniques. Technologies: Row-level security, Dynamic Data Masking, Always Encrypted

SQL Server BI & Reporting for the Enterprise

The all new Reporting Services with enhanced visual controls and Mobile reporting capabilities. SSRS in SQL 2016 brings richer experiences to reports and dashboards wherever you consume them. Technologies: Server Management Studio, Reporting Services, Mobile Report Publisher

Advanced Analytics with SQL Server

Bring Advanced Analytics models into SQL Server to execute R models inside of SQL. Make them work with data from structured tables and unstructured Hadoop sources using Polybase. Technologies: Advanced Analytics, Polybase, Azure Blob Storage, Big Data

Data Platform Hybrid scenarios

Reduce your storage cost and improve availability by building hybrid solutions with Azure. Technologies: Stretch database, DR and Back up to Azure, Azure Data Warehouse

Remember, all attendees will receive the free SQL Server 2016 book: Introducing Microsoft SQL Server 2016. Mission Critical Applications, Deeper Insights, Hyperscale Cloud (Approximate Retail value of $20).

Choose your date & location and register here:

ClassLocationStart Date 
SQL Server 2016 IT CampVancouverJune 12, 2017REGISTER
SQL Server 2016 IT CampCalgaryJune 13, 2017REGISTER
SQL Server 2016 IT CampEdmontonJune 14, 2017Full!
SQL Server 2016 IT CampTorontoJune 15, 2017REGISTER
SQL Server 2016 IT CampOttawa (Holland Cross)June 16, 2017REGISTER


Privacy notice
Please note that by enrolling into this course, you agree to have your contact/registration details shared with Microsoft Canada and/or an associated Microsoft partner.

*Offer good only in Canada to legal residents of Canada who register and attend the SQL Server 2016 IT Camp in June 2017.  Offer runs from 12:01AM EST, June 12, 2017 until 11:59PM Eastern Standard Time, June 16, 2017 or when all gifts have been awarded.  Limit one (1) gift per person. Taxes, if any, are the sole responsibility of the recipient. We reserve the right to substitute a gift of equal or greater value.


Bonus – All attendees will receive this free official Microsoft eBook: Introducing SQL Server 2016: Mission Critical Applications, Deeper Insights, Hyperscale Cloud