A Story of BI, BIG Data and SQL Server in Canada
We focus on BI, Big Data and SQL Server, providing the latest news from Microsoft and the industry, sharing upcoming events, customer stories and SQL Server product information. Find out why SQL and not Oracle or SAP.
Are you ready for SQL Server 2008 and 2008R2 End of support?
Author: Eduard Davidzhan Date: 04/01/2019
Operationalize Databricks Workloads with Azure Data Factory
About the authors: Faraz Rasheed has been in the Advanced Analytics & AI space for over a dozen...
Author: Alp Kaya Date: 03/22/2019
BYOL SQL & Windows Server license to the Cloud: Azure Hybrid Benefit (AHB) vs License Mobility. What is the difference?
When an organization deploys a solution built on the Microsoft platform to the Cloud, there are...
Author: Eduard Davidzhan Date: 03/18/2019
Use MS PowerPoint to record a video of your presentation
Did you know that you can use PowerPoint to record a video of your presentations?Presenter view (you...
Author: Eduard Davidzhan Date: 10/03/2018
Are you ready for SQL Server 2008/R2 End of Support?
SQL Server 2008 and SQL Server 2008R2 end of support is coming in just 9 months. Are you ready? Join...
Author: Eduard Davidzhan Date: 10/01/2018
From Data to AI webinar series
Get Your Data Ready For AI AI is useless without well-organized data, that is what Data Governance...
Author: Eduard Davidzhan Date: 09/14/2018
Microsoft AI resources
Founded this great list of Microsoft AI resources in the Introduction to Artificial Intelligence...
Author: Eduard Davidzhan Date: 06/25/2018
Replace your SAP BW by leveraging Simplement and the Microsoft Azure Data Stack
Hi everyone! Let me introduce myself. My name is Alp Kaya. I work for Microsoft as a Data & AI...
Author: Eduard Davidzhan Date: 05/02/2018
Missed Microsoft’s free workshops - “From RDBMS to NoSQL: A look at MySQL, PostgreSQL and Cosmos DB on Azure”?
The week of Jan 22nd, we hosted a workshop tour in five cities across Canada focused on database...
Author: Eduard Davidzhan Date: 01/15/2018
Microsoft BOT and AI URL Whitelists
When working with the Microsoft BOT Framework and different types of artificial intelligence...
Author: Winson Woo Date: 01/03/2018
Call out to Distributed Always On Availability Groups
We have all been introduced and hopefully implemented Always On Availability Groups, a feature that...
Author: Winson Woo Date: 01/03/2018
Azure Data Tech Week Workshops
Join Microsoft Canada as we host over 35 Azure and SQL Training sessions across Canada.These 300-400...
Author: Eduard Davidzhan Date: 11/18/2017
How to buy SQL Server?
I often receive questions about how organizations in Canada can buy SQL Server licenses. In this...
Author: Eduard Davidzhan Date: 11/08/2017
For Microsoft Partners: Six ways to help your customers to get value from Data
Are you working with customers interested in Data, Analytics or IoT project? Do you feel that you...
Author: Eduard Davidzhan Date: 11/07/2017
Fall 2017 Technical Webinars
You are invited to an 9-part webinar series gaining technical knowledge about Data & AI. Each...
Author: Charles_Verdon Date: 10/06/2017
Six ways to get value from your data
Are you thinking of deploying Modern BI, Predictive Analytics or Big Data solution? Is it time to...
Author: Eduard Davidzhan Date: 09/13/2017
Building a dashboard on top of a web API with Power BI and Azure – Part 3
In Part 1 of this series we connected to the driveBC API in Power BI Desktop and built a simple...
Author: Florian Eiden, DPSA Date: 08/29/2017
Building a dashboard on top of a web API with Power BI and Azure – Part 2
In Part 1 of this series we connected to the driveBC API in Power BI Desktop and built a simple...
Author: Florian Eiden, DPSA Date: 08/29/2017
Formation Microsoft en mode laboratoire sur la plateforme de données
(English version here) Étant donné le succès de notre première série d’ateliers pratiques à Montréal...
Author: Robert Luong Date: 08/28/2017
Microsoft Data Platform Hands-on Labs
(Version en français ici) After the success of our first series of hands-on labs in Montreal in the...
Author: Charles_Verdon Date: 08/03/2017
Real-time streaming dashboard with Power BI
[This article was first published on stephanefrechette.com, and kindly contributed to CanSQL] I was...
Author: Stéphane Fréchette Date: 07/18/2017
Building a dashboard on top of a web API with Power BI and Azure – Part 1
In Part 1 of this series we will see what an API is and how to use one with Power BI Desktop to...
Author: Florian Eiden, DPSA Date: 05/29/2017
Creating an OAuth 2.0 authentication token for Azure Data Lake Store
Hi All! A Data Lake can be defined as a storage repository that holds a vast amount of raw data in...
Author: Benjamin Leroux Date: 03/06/2017
Data Science VM and Azure Data Lake Store - The hidden feature
Hi All! I wanted to highlight a hidden feature in the data science VM which allows you to consume...
Author: Benjamin Leroux Date: 02/28/2017
Live Query Statistics in SQL Server 2016
Hi everyone! For this blog post, I thought I would bring attention to “Live Query Statistics” (LQS),...
Author: Martin Turcotte at Microsoft Date: 02/28/2017
Profisee Workshop for Master Data Management in Montreal
Are you struggling to get the single view of truth from your data? Can you see and use a clean 360...
Author: Charles_Verdon Date: 02/22/2017
Stretch DB – The Programmatic Approach
Stretch Database “stretchs” on premise data to the cloud. This simple pattern and approach allows...
Author: Winson Woo Date: 02/08/2017
Private Clouds, Datacenters and Azure, can’t we just all get along ?
After the meeting with the client we were walking down to grab a coffee together. The client turned...
Author: Winson Woo Date: 01/30/2017
Azure Day January 17 - Montreal Event
Hi everyone! Did you know that January 17th is Azure day in Canada? This post details the hands-on...
Author: Charles_Verdon Date: 12/20/2016
Relationships in Power BI: Fixing “One of the columns must have unique values” error message
One of the main benefit of using Power BI as a Self-Service BI tool is the capability of Power BI...
Author: Florian Eiden, DPSA Date: 12/19/2016
SQL Server 2016 Row-Level Security
Hi everyone! I wanted to highlight one important new key future in SQL Server 2016 called Row-Level...
Author: Stéphane Fréchette Date: 11/16/2016
[for Microsoft partners] Join Microsoft Data & Analytics Partner Community
Are you a Microsoft Partner? We would like to invite you to join the Microsoft Cloud + Enterprise...
Author: Eduard Davidzhan Date: 11/11/2016
SQL Server 2016 training for Microsoft Partners
You’re invited to attend a Microsoft Partner Practice Enablement Bootcamp focused on SQL Server 2016...
Author: Eduard Davidzhan Date: 09/16/2016
Training for Microsoft Partners: Azure for SQL Server Consultants
You are invited to the Microsoft Azure for SQL Server Consultants training in the following cities:...
Author: Eduard Davidzhan Date: 09/16/2016
SQL Server 2016 – Dynamic Data Masking
Hi everyone! Let me introduce myself. My name is Stéphane Fréchette, I work for Microsoft as a Data...
Author: Stéphane Fréchette Date: 09/06/2016
SQL Server 2016 hands-on workshop (Data Insight Immersion) sessions
Please find below the list of topics available in standard SQL Server 2016 Hands-On (Data Insight...
Author: Eduard Davidzhan Date: 09/06/2016
Data Platform University Online for Microsoft Partners
REGISTRATION NOW LIVE! C+E University Online is an interactive, scenario-based training that...
Author: Eduard Davidzhan Date: 08/11/2016
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...
Author: Eduard Davidzhan Date: 05/28/2016
Get Ready for SQL Server 2016. Webcast for Canadian Partners
On June 1, 2016 Microsoft released a new version of SQL Server database. With SQL Server being the...
Author: Eduard Davidzhan Date: 05/10/2016
Join Microsoft at Big Data Summit Toronto – Feb 17th & 18th
If you want to learn more about real world examples of big data implementations driving massive...
Author: Eduard Davidzhan Date: 02/10/2016
Architecture for Data Exploration using Microsoft Azure
I have decided to write this blog post as quite a few of my clients are asking me how best to enable...
Author: Charles_Verdon Date: 02/08/2016
Microsoft Data Platform events in Canada: SQL Server, Power BI, Cortana Analytics and IoT
Want to get familiar with the new Power BI, SQL Server 2014, Cortana Analytics or IoT solutions?...
Author: Eduard Davidzhan Date: 01/31/2016
Power Query Use Case: Contact Management
Happy new year everyone! Of all the components of Power BI, Power Query was by far the one I was...
Author: Charles_Verdon Date: 01/05/2016
SQL Server 2005 Upgrade – Learn from SQL Server experts
Do you still have SQL Server 2005 databases in your IT environment? Learn from SQL Server experts...
Author: Eduard Davidzhan Date: 12/14/2015
Data Platform University for Partners
If you missed Data Platform University webcast series for partners we ran in October and November...
Author: Eduard Davidzhan Date: 11/20/2015
SQL Server News from PASS 2015
SQL Server News from PASS 2015 Hi! Last week was PASS Summit in Seattle. Here’s a short...
Author: Charles_Verdon Date: 11/03/2015
IT CAMP: Time to upgrade to SQL Server 2014
You are invited! On April 12‚ 2016 Extended Support for SQL Server 2005 is coming to an end. After...
Author: Eduard Davidzhan Date: 10/07/2015
Data Analytics Camps: from Excel to Power BI
You are invited! As an advanced user, we want you to benefit from all of the capabilities available...
Author: Eduard Davidzhan Date: 10/07/2015
Microsoft Data Platform at Microsoft Cloud Roadshow in Toronto
Bringing the best of IGNITE and BUILD conferences to Toronto.We want to invite you to attend the...
Author: Eduard Davidzhan Date: 10/07/2015