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

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

485 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,448 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

796 reads

BimlScript – Get to Know Your Control Nuggets

by Meagan Longoria

Data Savvy

This is post #2 of my BimlScript – Get to Know Your Code Nuggets series. To learn about text nuggets, see my...

2016-07-01

465 reads

BimlScript – Get to Know Your Code Nuggets

by Meagan Longoria

Data Savvy

In BimlScript, we embed nuggets of C# or VB code into our Biml (XML) in order to replace variables and...

2016-06-30

942 reads

Colorblind Awareness and Power BI KPIs

by Meagan Longoria

Data Savvy

Update: The ability to change the color of a KPI was delivered in August 2016!
Color blindness, or color vision deficiency (CVD)...

2016-04-23

587 reads

Trekking through the DAX Jungle In Search of Lost Customers

by Meagan Longoria

Data Savvy

I like to think I’m proficient at writing DAX and building SSAS tabular models. I enjoy a good challenge and...

2016-03-01

457 reads

Creating a Matrix in Power BI With Multiple Values on Rows

by Meagan Longoria

Data Savvy

This week I was asked to create a matrix in a Power BI report that looks like this:
Matrix with Values on...

2016-01-09

1,300 reads

Blogs

Claude Code Helps Analyze Test Data Manager Log Files

I had a customer ask about analyzing their Test Data Manager (TDM) usage to...

PowerPoint to HTML with Claude AI

I had an idea for an animated view of a sales tool, and started...

Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!

By Klaus Aschenbrenner

Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...

Read the latest Blogs

Forums

SQL Server 2025 Query Performance Tuning: Troubleshoot and Optimize Query Performance

Comments posted to this topic are about the item SQL Server 2025 Query Performance...

Is it uncommon for Dev's to have a data model of the source data

By Coffee_&_SQL

This is a generic question. To the moderators, I wasn't sure where to place...

ROLLUP to calculate Month total for all Categories

Good Afternoon, I have built a table with four columns: Period(Month), Category, Numerator, Denominator....

Visit the forum

Question of the Day

Creating JSON I

On SQL Server 2025, what happens when I run this code:

SELECT JSON_OBJECTAGG( 'City':'Denver')
GO

See possible answers