How do I use VSTS variables in YAML CI Build definitions?

Hey, VSTS YAML builds are my new favorite thing, by like a million miles.
If you have a yaml build definition...

SQL Server 2017 : Data Transformation and Interpolation using Python

As a continuation to my previous article, How to use Python in SQL Server 2017 to obtain advanced data analytics,...

Power BI Custom Visuals Class (Module 78 – Data Image by CloudScope)

In this module you will learn how to use the Data Image Power BI Custom Visual by CloudScope. The Data...

Microsoft Professional Program in Data Science – The Finish Line

In October 2017, I completed the capstone project of the Microsoft Professional Program for Data Science. I’ve blogged about this...

Does The Join Order of My Tables Matter?

Photo by pan xiaozhen on UnsplashI had a great question submitted to me (thank you Brandman!) that I thought would make for a...

Does The Join Order of My Tables Matter?

I had a great question submitted to me (thank you Brandman!) that I thought would make for a good blog post:

...I've been wondering if it really matters from a...

SQL Server on Linux Installation On RHEL Server – PART1

In the previous posts, we learned how toinstall SQL Server on Ubuntu Server&install SQL Server on CentOS. Today, we’ll walk...

SQL Saturday Returns to Rochester!

I am very happy to announce that SQL Saturday returns to Rochester, NY on March 24, 2018. This is the Flour/Flower City’s seventh SQL Saturday and SQL Saturday #723...

SSIS script task successfully executed. Or not?

Issue
Recently we came across an interesting issue. I guess this will not happen often, but I think it’s worth mentioning...

Sessions, Temporary Objects, and the Afterlife

For thousands of years theologians have offered various thoughts on the question of what happens when we die. Does some...