by Gil Raviv | Dec 9, 2016 | Data Chant
Follow Me In today’s tutorial we will solve a very common challenge in Excel. You start with an Excel table and you wish to condense it by removing all the columns and/or rows which are entirely empty, and usually you don’t have prior knowledge which columns and rows...
by Jeanne Combrinck | Dec 8, 2016 | SQL Girl
Recently a colleague and I had a discussion about which method is the best to use for backing up MDS (Master Data Services) for disaster recovery. We came to the conclusion it all depended on the SQL environment version you were recovering to. Below are the 2...
by Melissa Coates | Dec 3, 2016 | SQL Chick
This week I ran into an issue when trying to provision Azure Analysis Services (AAS) in Azure. The AAS team was fantastically helpful with helping me understand what was going on. When provisioning Azure Analysis Services in the portal, the final selection is to...
by Melissa Coates | Nov 30, 2016 | SQL Chick
This is part 2 of a discussion about a new service in Microsoft Azure: Azure Analysis Services. Azure AS is a Platform-as-a-Service (PaaS) offering which is in public preview mode (as of November 2016). Part 1: Why a Semantic Layer Like Azure Analysis Services is...
by Gil Raviv | Nov 29, 2016 | Data Chant
Follow Me Power BI Desktop November Update (2016) is out with amazing new features. In today’s blog post, I would like to focus on a new functionality which simplifies the authoring experience of query functions. This post first appeared...