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

Updating a SharePoint List Item With Flow When You Don’t Have The ID

by Meagan Longoria

Data Savvy

I recently worked on a project that used Flow to update a SharePoint list each time an item was updated...

2017-07-17

558 reads

Azure Data Factory and the Case of the Missing JRE That Wasn’t

by Meagan Longoria

Data Savvy

On a recent project I used Azure Data Factory (ADF) to retrieve data from an on premises SQL Server 2014...

2017-05-11 (first published: 2017-05-01)

1,311 reads

I Like to Move It, Move It – But Azure Data Factory Doesn’t

by Meagan Longoria

Data Savvy

I’ve spent the last couple of months working on a project that includes Azure Data Factory and Azure Data Warehouse. ADF...

2017-04-11

614 reads

Insufficient Disk Space (T-SQL Tuesday #88)

by Meagan Longoria

Data Savvy

This month’s T-SQL Tuesday – hosted by Kennie T Pontoppidan(@KennieNP) – is called “The daily (database-related) WTF“. He asked us to be...

2017-03-27 (first published: 2017-03-14)

2,794 reads

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,745 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

628 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

775 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,911 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,415 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

503 reads

Blogs

The New Unified Copilot in Fabric and Project Osmos: From AI Assistance to Agentic Data Engineering

(This post starts a three-part series on how AI is changing the way we...

SQL Server Problems You Can Reproduce, Measure and Fix: A Free Demo Library

By MarlonRibunal

I built a free library of runnable SQL Server demos. Each reproduces a real...

Experimenting with CHOOSE: #SQLNewBlogger

I was looking over the CHOOSE() function while editing an article at SQL Server...

Read the latest Blogs

Forums

Managed Instance vs Azure Database - is this a good option?

We're currently in Azure, however as we had a very tight migration timeline when...

MERGE in a nested TRY/CATCH won't roll back

I have a section of code similar to the following abstract: DECLARE @loop [int]...

Perfermance result aftet purge operatio

By abdalah.mehdoini

Hello everyone, I am planning to implement a data purging solution that is expected...

Visit the forum

Question of the Day

SQL Server 2025 Server-level Roles

In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?

See possible answers