Microsoft Data Platform events in Canada: SQL Server, Power BI, Advanced Analytics and IoT

Article
09/27/2015

Want to get familiar with the new Power BI, SQL Server 2014, Cortana Analytics or IoT 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.

With SQL Server 2005 support coming to an end on April 12, 2016 we created a special page containing all resources that can help you with database upgrade.

________________________________________________________

Online

· SQL Server 2005 Upgrade: The Path to Better Database Performance and Security webinar

· Cortana Analytics Perceptual APIs

· Watch On Demand: Webcast Series: Top 5 Microsoft Data Platform Solutions

· Diffusion sur demande : Séries de web-émissions : Top 5 solutions de données Microsoft

· Watch on Demand: Microsoft Canada Webcast Series: Power BI, Predictive Analytics and SQL Server as a Service

· Diffusion sur demande : Webémissions de Microsoft Canada: Power BI, Analyse prédictive et SQL Server as a Service

Toronto / Mississauga

· Feb 19. HPE SQL IT Camp: Time to upgrade to SQL Server 2014 in Mississauga

· Jan 12. Toronto PASS: Avoiding Parameter Sniffing Issues & Writing Consistently Fast SQL by Michael Swart

· ~~Sep 28-30.~~ Mastering DAX workshop in Toronto

· ~~Oct 1-2.~~ Optimizing DAX workshop in Toronto

· ~~Oct 20.~~ Navantis: Turning Data into actionable Insights

· ~~Oct 22.~~ Data Analytics Camp in Toronto

· ~~Nov 9-10.~~ Microsoft Data Platform @ Microsoft Cloud Roadshow in Toronto

· ~~Nov 18-20.~~ Learn about Microsoft solutions at Data Marketing conference in Toronto

· ~~Nov 25~~. SQL IT Camp: Time to upgrade to SQL Server 2014 in Mississauga

· ~~Nov 26~~. Data Analytics Camp: from Excel to Power BI in Mississauga

· ~~Nov 30~~. Data Analytics Camp: from Excel to Power BI in Toronto

· ~~Dec 9~~. Advanced Analytics with Azure Machine Learning and Revolution R

Ottawa

· April 16. SQL Saturday

· ~~Nov 17.~~ SQL IT Camp: Time to upgrade to SQL Server 2014

· ~~Nov 26~~. Microsoft Data Platform Day

Calgary

· Feb 26. HPE SQL IT Camp: Time to upgrade to SQL Server 2014

· Jan 12-13. LVS: Power BI workshop for Oil & Gas Industry

· ~~Oct 29~~.Microsoft Data Platform Day: Ignite Business transformation with Analytics and IoT

· ~~Nov 2~~. Data Analytics Camp

· ~~Nov 25.~~ IT Camp: Time to upgrade to SQL Server 2014

Edmonton

· April 9. SQL Saturday

Vancouver

· Feb 12. HPE SQL IT Camp: Time to upgrade to SQL Server 2014

· ~~Oct 20.~~ Microsoft Data Platform Day: Ignite Business transformation with Analytics and IoT

· ~~Oct 27.~~ DevTech Community event: SQL Camp

· ~~Oct 28.~~ Data Analytics Day

· ~~Nov 26~~. IT Camp: Time to upgrade to SQL Server 2014

Montreal

· ~~Oct 27.~~Microsoft Data Platform Day: Ignite Business transformation with Analytics and IoT

· ~~Nov 5.~~ Lunch and Learn for SAP Customers: ERP Data made Simple

· ~~Nov 17.~~ SQL IT Camp: Time to upgrade to SQL Server 2014

· ~~Nov 18.~~ Data Analytics Camp

· ~~Nov 21~~. SQL PASS: SQL Saturday

Winnipeg

· ~~Nov 26~~. SQL Server User Group: SQL Upgrade/Migration

________________________________________________________

International events

· ~~Sept 29 – Oct 1.~~ Strata + Hadoop in New York, NY

· ~~Oct 27-30.~~ PASS Summit 2015 in Seattle, WA: World’s largest gathering of SQL Server and BI professionals

· March 14-16, 2016. Gartner Business Intelligence & Analytics Summit in Grapevine, TX

· May 3-4, 2016. PASS Business Analytics Conference in San Jose, CA

________________________________________________________

Online and on-demand events

· PASS Business Analytics Conference 2014 keynote recording

· PASS SQL Server 2014 and Power BI webcast series

· Pragmatic Works: 9 free SQL Server online trainings from Microsoft Partner

· Server and Platform videos on YouTube

· SQL Server and BI event session recordings on Channel9

Free online training courses (Microsoft Virtual Academy & edX)

SQL Server Database:

· Upgrading to Microsoft SQL Server 2014

· Querying with Transact-SQL

· Implementing Tabular Model Solutions

· SQL Server 2014: Security, Optimizer, and Columnstore Index Enhancements

· SQL Server in Azure Virtual Machines - Developer Jump Start

· Database Fundamentals

· Updating your Database Management Skills to 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:

· Building Recommendation Systems in Azure

· edX: Implementing Real-Time Analytics with Hadoop in Azure HDInsight

· Analyzing and Visualizing Data with Excel

· edX: Data Science and Machine Learning Essentials

· MVA: Data Science and Machine Learning Essentials

· 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 2014 Evaluation version

· Power BI

· Azure Machine Learning (Predictive analytics)

Free eBooks

· Introducing Microsoft SQL Server 2014

· Introducing Microsoft Azure HDInsight

· Data Science in the Cloud with Microsoft Azure Machine Learning and R

Deployment resources and Tools

· SQL Server Deployment resources

· Migration tools (SQL Server Migration Assistant - SSMA)

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

o Sybase ASE: https://www.microsoft.com/en-us/download/details.aspx?id=43691

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

o IBM DB2: https://www.microsoft.com/en-us/download/details.aspx?id=45296

· Migration tools white papers

o SSMA 6.0 Overview White Paper

o SSMA 6.0 for Oracle Detailed Technical White Paper

o SSMA 6.0 for Sybase ASE Detailed Technical White Paper

o SSMA 6.0 for MySQL Detailed Technical White Paper

o SSMA 6.0 for IBM DB2 Detailed Technical White Paper