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 upgrade from SQL Server 2005/2008, move to the Cloud or consolidate your data infrastructure to improve the performance, optimize the cost and achieve higher flexibility? Interested in migrating from Oracle, Sybase or DB2 to save money and improve…

0

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 dashboard. In Part 2 we designed the architecture capable of storing the data over time. In Part 3 we are implementing implement the architecture. In the previous article, we defined our architecture as follow: We…


Formation Microsoft en mode laboratoire sur la plateforme de données

Étant donné le succès de notre première série d’ateliers pratiques à Montréal au cours de la première moitié de l’année, nous redoublons nos efforts pour augmenter la capacité de la salle ainsi que la sélection et la profondeur des sujets. Nous croyons fermement que la meilleure façon de mettre en valeur notre technologie est de la…

0

Microsoft Data Platform Hands-on Labs

After the success of our first series of hands-on labs in Montreal in the first half of the year, we are expanding our efforts to increase room capacity, topic selection and depth. We firmly believe that placing our technology in your hands is the best way to make it shine. After all, teaching you how to use…

0

Real-time streaming dashboard with Power BI

[This article was first published on stephanefrechette.com, and kindly contributed to CanSQL] I was recently asked to provide a simple demo/proof-of-concept on how to quickly create a real-time streaming dashboard with Power BI. Did you know that you can stream data and update dashboards in real-time? Any visual or dashboard that can be created in…


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 its native format until it is needed. My question is, what would be the point of storing all this data if you can’t access it easily? Azure Data Lake store, which is Microsoft’s…

0

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 data stored in Azure Data Lake Store from Microsoft R Server.   As part of the continued improvements made to the data science VM, towards the end of December 2016, the necessary libraries that allow…


Live Query Statistics in SQL Server 2016

Hi everyone! For this blog post, I thought I would bring attention to “Live Query Statistics” (LQS), one of the many new features and improvements of SQL Server 2016 available from SQL Server Management Studio (SSMS). LQS is an important new feature because it directly addresses a requirement often heard from SQL Server DBAs: “we…