Microsoft Data Platform events in Canada: SQL Server, Power BI, Cortana and IoT Suites

Want to get familiar with the new SQL Server 2016, Power BI, Predictive Analytics, IoT or Microsoft Big Data solutions?

Join Microsoft Canada, our partners and the SQL PASS community for an across Canada in-person and online event series that will introduce you to these solutions. Please find the upcoming events list below. This page will be updated with all new activities.

• You can join MS SQL Server Professionals – Canada LinkedIn Group or follow us on Twitter to get notifications on this page updates.

________________________________________________________

Online

• On Demand: Microsoft Data Amp
• On Demand: Move beyond barriers: Drive business transformation by migrating from Oracle to SQL Server
• On Demand: Tackle the Top 5 Data Challenges with SQL Server
• On Demand: Emerging Tech Virtual Summit: How IoT and Artificial Intelligence Can Transform the World and Your Organization.
• March 7^th, 2017. Pythian: Migrate to SQL Server 2016
• March 28th, 2017.       IoT Virtual Bootcamp
• April 5^th, 2017. Softchoice: Microsoft Data Platform Modernization

Toronto/Mississauga

• May 24^th, 2017. Data Talk: Harnessing the Power of Intelligent Data & App Development
• January 19, 2017. DSI: Business Analytics Immersion in Mississauga
• January 26^th, 2017. Power BI Immersion Even in Toronto
• June 1^st, 2016. Advanced Analytics with Azure Machine Learning and Revolution R
• August 25^th, 2016. BizLab by MTC: Oracle Migration workshop
• September 7^th, 2016. BizLab by MTC: Azure Essentials workshop
• September 20^th, 2016. SQL PASS: Introduction to DAX in Power BI
• October 26^th, 2016. Oracle Migration workshop (Toronto)
• October 27-28, 2016. Data Platform sessions at Microsoft Tech Summit Toronto
• November 21^st, 2016. DSI: SQL Server 2016 workshop (Mississauga)
• November 23^rd, 2016. DSI: Oracle Migration workshop (Mississauga)
• November 24^th, 2016. Hitachi Solutions: Power BI Immersion (Toronto)
• March 16^th, 2017. DSI: Business Analytics Immersion
• March 21^st, 2017. DSI: Power BI Workshop
• March 23^rd, 2017. SQL Server IT Camp (Toronto)
• March 23^rd, 2017. Performance Analytics: Corporate Performance Management (Toronto)
• March 24^th, 2017. SQL Server IT Camp (Mississauga)
• March 30^th, 2017. Hitachi: Machine Learning Immersion
• April 18^th, 2017. DSI: SQL Server 2016 Workshop
• April 24-26, 2017. Scalable Data Science with Microsoft R Server and Spark with HDInsight 
• April 20^th, 2017. DSI: Business Analytics Immersion
• April 27^th, 2017. Hitachi: Power BI Immersion

Montreal

• May 25^th, 2017. Data Talk: Harnessing the Power of Intelligent Data & Analytics
• June 5^th, 2017. SQL IT Camp
• March 18^th, 2017. SQL Saturday in Montreal
• March 24^th, 2017. SQL Server IT Camp
• March 21^st 2017 Profisee Master Data Management Workshop (Montreal)
• March 27-28, 2017. Learn about Microsoft Analytics solutions at Salon BI
• October 24^th, 2016. Sommet sur l’innovation en matière de données Microsoft
• October 25^th, 2016. Atelier sur SQL Server 2016

Ottawa

• March 23^rd, 2017. SQL Server IT Camp
• October 26^th, 2016. Microsoft Data Innovation Summit
• October 27^th, 2016. SQL Server 2016 Hands-on Workshop

Fredericton

• March 29^th, 2017. Microsoft Big Data & Advanced Analytics - Unlocking Insights on Your Data – Fredericton
• March 29^th, 2017. Power BI Immersion

Halifax

• May 19, 2017. SQL Server 2016 IT Camp
• March 30^th, 2017. Microsoft Big Data & Advanced Analytics - Unlocking Insights on Your Data
• March 30^th, 2017. Power BI Immersion

St. Jones

• March 31^st, 2017. Microsoft Big Data & Advanced Analytics - Unlocking Insights on Your Data 
• March 31^st, 2017. Power BI Immersion

Calgary

• April 20^th, 2017. Hitachi: Power BI Immersion
• April 29^th, 2017. SQL Saturday
• June 21^st, 2016. Power BI User Group meeting – Win a Windows 10 Tablet
• August 17^th, 2016. Migrating to Azure SQL Database: Tips, tricks, and lessons learned
• October 18^th, 2016. Microsoft Data Innovation Summit
• October 19^th, 2016. SQL Server 2016 Hands-on Workshop
• November 22nd, 2016. Power BI User Group meeting
• November 23rd, 2016. SQL PASS: When Database Corruption Strikes?
• November 30th, 2016. LVS: Oracle Migration Workshop
• February 23^rd, 2017. Power BI Immersion
• February 23^rd, 2017. The Future of Oil and Gas: Data Driven Operational Excellence
• February 28^th, 2017. Amtra: SQL Migration & Server Modernization
• March 21^st, 2017. Performance Analytics: Corporate Performance Management
• March 23^rd, 2017. Hitachi: Machine Learning Immersion
• March 29^th, 2017. SQL Server IT Camp

Winnipeg

• March 30, 2017. SQL Server IT Camp

Vancouver

• March 27, 2017. SQL Server IT Camp
• October 24^th, 2016. Microsoft Data Innovation Summit
• October 25^th, 2016. SQL Server 2016 Hands-on Workshop
• November 16^th, 2016. Hitachi: Power BI Immersion
• November 4^th, 2016. DevTeach: SQL 2016 Camp

Edmonton

• February 16^th, 2017. Amtra: SQL Migration & Server Modernization
• March 28^th, 2017. SQL Server IT Camp
• May 22^nd, 2017. SQL Saturday
• June 25^th, 2016. SQL Server 2016 Launch Discovery Day

________________________________________________________

International events

• June 12-13, 2017, Microsoft Data Insight Summit, Seattle, WA
• October 27- November 31, 2017. PASS SUMMIT 2017, Seattle, WA

________________________________________________________

Online and on-demand events

• SQL Server and BI event session recordings on Channel9
• Data Driven (SQL Server 2016 Launch) event sessions recordings on Channel 9

SQL Server 2016 new capabilities overview

• R Services in SQL Server 2016
• In-Memory OLTP in SQL Server 2016
• PolyBase: Gaining insights from HDFS and relational data in SQL Server 2016
• SQL Server 2016 Query Store Simplifying Query Performance Troubleshooting
• How Microsoft uses SAP on SQL Server 2016
• Stretch Database Securely and transparently leverage infinite storage and compute capacity in Azure…
• Keeping Sensitive Data Secure with Always Encrypted
• Dynamic Data Masking SQL Server 2016
• Upgrade and Migration to SQL Server 2016
• Tooling Improvements in SQL Server 2016
• Effortlessly Analyze Data History Using Temporal
• Monitor critical business metrics and trends at a glance with KPIs
• SSAS Tabular semantic model updates for SQL Server 2016
• Real-Time Operational analytics with SQL Server 2016
• Analysis Services DirectQuery for Tabular models
• Design mobile reports (SQL Server Mobile Report Publisher)
• Create shared data sources and datasets for your reports
• JSON as a bridge between NoSQL and relational worlds
• Access reports in modern browsers and mobile devices

• Scaling your advanced analytics in SQL Server 2016 with R Server
• Building intelligent applications using SQL Server R services : an End to End Walkthrough
• Predictive Maintenance with R in SQL Server 2016
• SSIS Catalog Custom Logging Levels SQL Server 2016
• Fraud Analysis using a hybrid implementation of Azure SQL Data Warehouse and SQL Server 2016…
• Design modern paginated reports
• Hybrid BI: Accessing on-premises data with Power BI
• R Tools for Visual Studio
• Azure VM is the best platform for SQL Server 2016
• Master Data Services 2016
• Full Lifecycle of Financial Data- Using SQL Server 2016
• Speeding up analytics with In-Memory Columnstore Index
• Always On Availability Groups enhancements in SQL Server 2016
• Row-Level Security (RLS) SQL Server 2016

Free online training courses (Microsoft Virtual Academy)

SQL Server Database:

• Database Fundamentals
• Updating your Database Management Skills to SQL Server 2014
• Upgrading to Microsoft SQL Server 2014
• Designing Database Solutions for SQL Server
• Developing Microsoft SQL Server Databases
• Implementing Data Models & Reports with Microsoft SQL Server
• Mission Critical Performance with SQL Server 2014 Jump Start
• Implementing Tabular Model Solutions
• SQL Server 2014 Essentials for Oracle DBAs
• Boost Your T-SQL with the APPLY Operator
• SQL Server 2014: Security, Optimizer, and Columnstore Index Enhancements
• 11 Free SQL Server 2012 Online Training Courses

SQL Server Hybrid Cloud:

• The Microsoft Hybrid Cloud: Best Practices Guidance
• Architecture in Practice
• Platform for Hybrid Cloud with SQL Server 2014 Jump Start
• SQL Server in Windows Azure Virtual Machines Jump Start
• SQL Server in Azure Virtual Machines – Developer Jump Start
• Virtualizing & Managing SQL Server Microsoft Cloud OS
• SQL Server in Azure Virtual Machines – Developer Jump Start

BI, BIG Data and Predictive Analytics:

• Big Data Analytics with HDInsight: Hadoop on Azure
• Big Data with the Microsoft Analytics Platform System
• Getting Started with Microsoft Azure Machine Learning
• Power BI: Free on-demand webinars, videos, hands-on labs and other training resources

• Faster Insights to Data with Power BI Jump Start
• From Data to Insight and Impact: The BI Revolution
• Microsoft Corporate BI and SAP BI Integration Jump Start
• Implementing Big Data Analysis
• Big Data Analytics

Azure SQL

• Microsoft Azure SQL Database
• Azure SQL Database for Business-Critical Cloud Applications

________________________________________________________

Virtual labs

• 18 Free SQL Server 2014, Azure and BI virtual labs
• SQL Server 2012 virtual labs on the Learning Center
• Browse the full library of SQL Server virtual labs

Trials

• SQL Server 2016 Evaluation version
• Power BI  
• Azure Machine Learning (Predictive analytics)
• Azure IoT suite
• Cortana Intelligence Suite

Free eBooks

• Introducing Microsoft SQL Server 2016
• Introducing Microsoft Azure HDInsight
• Data Science in the Cloud with Microsoft Azure Machine Learning and R
• Migrating SQL Server Databases to Azure
• Microsoft Azure Essentials Fundamentals of Azure

Deployment resources and Tools

• SQL Server Deployment resources
• Migration tools (SQL Server Migration Assistant – SSMA)
  • Oracle: https://www.microsoft.com/en-us/download/details.aspx?id=43689
  • Sybase ASE: https://www.microsoft.com/en-us/download/details.aspx?id=43691
  • MySQL: https://www.microsoft.com/en-us/download/details.aspx?id=43688
  • IBM DB2: https://www.microsoft.com/en-us/download/details.aspx?id=45296
• Migration tools white papers
  • SSMA 6.0 Overview White Paper
  • SSMA 6.0 for Oracle Detailed Technical White Paper
  • SSMA 6.0 for Sybase ASE Detailed Technical White Paper
  • SSMA 6.0 for MySQL Detailed Technical White Paper
  • SSMA 6.0 for IBM DB2 Detailed Technical White Paper

________________________________________________________

For Microsoft Partners

• April – May, 2017. C&E University: Data Platform Online
• Microsoft Canada Data Platform & Analytics Community call:
  • April Session: https://go.microsoft.com/fwlink/?linkid=844875
  • June Sessions: https://go.microsoft.com/fwlink/?linkid=844884
  • August: https://go.microsoft.com/fwlink/?linkid=844882
  • October: https://go.microsoft.com/fwlink/?linkid=844874
  • December: https://go.microsoft.com/fwlink/?linkid=844869
• October – November. Toronto-Vancouver-Montreal. Azure for SQL Server Consultants
• November 28-December 1, 2016. Oracle Migration workshop for Partners
• December. Toronto & Vancouver. SQL Server 2016 Training for Microsoft Partners
• Aug 22-31, 2016. Azure IoT webcasts
• Aug 24 & Sept 14, 2016. Get Ready for SQL Server 2016. Webcast for Canadian Partners
• Sept 6-14, 2016. C&E University: Data Platform Online
• Data Platform University for Partners
• Machine Learning (Predictive Analytics) University for partners
• Data Platform Immersion
• Power BI Red Carpet program for partners
• Why Microsoft? Differentiated Value Proposition for partners
• Positioning Microsoft SQL Server 2014 and the Microsoft Data Platform Recording Link
• ModernBiz Technical Series for SMB online trainings
• Microsoft Online Demonstration site
• Free Power BI subscription for Microsoft partners with Gold (100 users) and Silver (25 users) competencies (Microsoft Account with appropriate access is required) Фзкшд