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

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,458 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,152 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

806 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

474 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

946 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

597 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

461 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,313 reads

Using a Variable to Populate the Query in a Lookup in SSIS

by Meagan Longoria

Data Savvy

I encountered a situation on my last SSIS project in which I needed to be able to populate the query in lookup...

2015-12-29

846 reads

Type 6 or Hybrid Type 2 Slowly Changing Dimension with Biml

by Meagan Longoria

Data Savvy

In my previous post, I provided the design pattern and Biml for a pure Type 2 Slowly Changing Dimension (SCD). When...

2015-12-27

613 reads

Blogs

A New Word: Dorgone

dorgone– adj. wondering if you could slip away from an event or group conversation...

Tell It Once: Setting Up Claude With Skills and MCP Servers

Many of us use AI the same way every single day. Open a tab....

SQL Server Transaction Log Forensics: Preserving Evidence During an Incident

SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...

Read the latest Blogs

Forums

How Can Database Performance Improve the Overall Website Experience?

By Brooks-Hayward

I’ve been looking into ways to improve the connection between a website and its...

When And How to Automate?

Comments posted to this topic are about the item When And How to Automate?

Hyperscale Replicas II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Hyperscale Replicas II

Visit the forum

Question of the Day

Hyperscale Replicas II

How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?

See possible answers