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?
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...
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...
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...
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...
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...
Date: 09/14/2018
Microsoft AI resources
Founded this great list of Microsoft AI resources in the Introduction to Artificial Intelligence...
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...
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...
Date: 01/15/2018
Microsoft BOT and AI URL Whitelists
When working with the Microsoft BOT Framework and different types of artificial intelligence...
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...
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...
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...
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...
Date: 11/07/2017
Fall 2017 Technical Webinars
You are invited to an 9-part webinar series gaining technical knowledge about Data & AI. Each...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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),...
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...
Date: 02/22/2017
Stretch DB – The Programmatic Approach
Stretch Database “stretchs” on premise data to the cloud. This simple pattern and approach allows...
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...
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...
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...
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...
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...
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...
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:...
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...
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...
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...
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...
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...
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...
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...
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?...
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...
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...
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...
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...
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...
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...
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...
Date: 10/07/2015