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

Data Integration Design Patterns With Microservices

Data Integration Design Patterns With Microservices Introduction My name is Mike Davison.  I work at...

Author: mikeydavison Date: 12/05/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

Next>