by Melissa Coates | Nov 26, 2017 | SQL Chick
I’ve been asked numerous times where to start when it comes to Azure. Getting a handle on Azure concepts, terminology, and features can be more than a little intimidating. Not only is Azure an extremely large platform, the pace of change is *very* fast. This...
by Melissa Coates | Nov 22, 2017 | SQL Chick
This post describes an issue I ran into this week on a project. If the Default Summarization settings in your data model are not correct, it results in wrong data being displayed, or even missing data, on your report. This post is based on Power BI Desktop as of mid...
by Melissa Coates | Nov 3, 2017 | SQL Chick
This post first appeared at http://feedproxy.google.com/~r/SqlChick-MelissaCoates/~3/DXSoX22HU5g/deciding-whether-to-use-azure-sql-data-warehouse. The author is Melissa CoatesRead...
by Melissa Coates | Oct 30, 2017 | SQL Chick
Did you know there are two ways to do federated queries with Azure Data Lake Analytics (ADLA)? By federated queries, I mean a query that combines (federates) data from multiple sources — in this case, from within Azure Data Lake and another data store. Federated...
by Melissa Coates | Oct 9, 2017 | SQL Chick
This post is a continuation of the blog where I discussed using U-SQL to standardize JSON input files which vary in format from file to file, into a consistent standardized CSV format that’s easier to work with downstream. Now let’s talk about how to make...
by Melissa Coates | Oct 1, 2017 | SQL Chick
This post first appeared at http://feedproxy.google.com/~r/SqlChick-MelissaCoates/~3/TsAHlcQj_Lk/time-for-a-change-groundhog-day-edition. The author is Melissa CoatesRead...