Meagan Longoria

Meagan Longoria is a consultant with Denny Cherry & Associates in Denver, CO where she shares her expertise in Microsoft BI and data warehousing through solution envisioning, architecture design, solution development, training, and blogging. She is a speaker at user groups and conferences across the country.

Website: http://DataSavvy.me

Copying data from On Prem SQL to ADLS with ADF and Biml – Part 2

by Meagan Longoria

Data Savvy

I showed in my previous post how we generated the datasets for our Azure Data Factory pipelines. In this post, I’ll...

2017-03-21 (first published: 2017-03-10)

1,735 reads

Copying data from On Prem SQL to ADLS with ADF and Biml – Part 1

by Meagan Longoria

Data Savvy

Apologies for the overly acronym-laden title as I was trying to keep it concise but descriptive. And we all know...

2017-03-03

621 reads

Please Lend Me Your Vote for Documentation of TMSCHEMA DMVs

by Meagan Longoria

Data Savvy

I spent a good bit of time looking for the definitions/descriptions of the TMSCHEMA DMVs that allow us to view...

2016-11-07

764 reads

Process Compatibility Level 1200 SSAS Tabular Model from SSIS 2014

by Meagan Longoria

Data Savvy

A client wanted to upgrade their SSAS model to SSAS 2016 to take advantage of some of the features of...

2016-10-21 (first published: 2016-10-14)

4,883 reads

Documenting your Tabular or Power BI Model

by Meagan Longoria

Data Savvy

If you were used to documenting your SSAS model using the MDSchema rowsets, you might have noticed that some of them...

2016-10-05

1,381 reads

BYO Time Zone Conversion With SSAS DMVs

by Meagan Longoria

Data Savvy

This is just a quick note (since I apparently forgot and was puzzled for a moment) that the MDSCHEMA_CUBES DMV...

2016-09-21

486 reads

DAX Date Dimension and Fun with Date Math

by Meagan Longoria

Data Savvy

I was working on a SSAS Tabular 2016 solution for a project for which I had no data (an empty...

2016-09-03

646 reads

Create a Date Dimension in Azure SQL Data Warehouse

by Meagan Longoria

Data Savvy

Most data warehouses and data marts require a date dimension or calendar table. Those of us that have been building...

2016-08-11 (first published: 2016-08-06)

2,449 reads

PolyBase Is A Picky Eater – Remove Carriage Returns Before Ingesting Text

by Meagan Longoria

Data Savvy

Update: As Gerhard points out in the comments, switching to ORC files solves this issue nicely. It’s not human readable,...

2016-08-09 (first published: 2016-08-01)

2,140 reads

Using Context To Traverse Hierarchies In DAX

by Meagan Longoria

Data Savvy

My friend and coworker Melissa Coates (aka @sqlchick) messaged me the other day to see if I could help with a...

2016-07-28

797 reads

Blogs

Why Database AI Agents need Layers?

Third part in my Ai series with databases. When building AI solutions within the...

Un-Migrating From the Cloud: T-SQL Tuesday #199

This month we have a very interesting invitation from Koen Verbeeck. He has hosted...

T-SQL Tuesday #199: Back to the on-prem

By Koen Verbeeck

It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s...

Read the latest Blogs

Forums

How Do the Experts Become Experts?

By Kathi Kellenberger

Comments posted to this topic are about the item How Do the Experts Become...

Stairway to Reliable Database Deployments Level 4 – Preparing for Production Deployment

By Massimo Preitano

Comments posted to this topic are about the item Stairway to Reliable Database Deployments...

Secure Communications

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Secure Communications

Visit the forum

Question of the Day

Secure Communications

As of June 2026, what is the best version of TLS to use with SQL Server?

See possible answers