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.

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

636 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,421 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,132 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

794 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

461 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

930 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

578 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

451 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,266 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

796 reads

Blogs

Who are you? Building an identity map.

By Brian Kelley

I admit that until I read the article, Who are you as a Leader?,...

Call a Fabric REST API from Azure Data Factory

By Koen Verbeeck

Suppose you want to call a certain Microsoft Fabric REST API endpoint from Azure...

Distributed Availability Group Dashboard

By davidfowler-42596

The Distributed Availability Group Dashboard can be downloaded from our GitHub repo. https://github.com/SQLUndercover/UndercoverToolbox/blob/master/DAG%20Dashboard.pbix. This...

Read the latest Blogs

Forums

Create Raw Zone Tables using Generative AI: Data Engineering with Fabric

Comments posted to this topic are about the item Create Raw Zone Tables using...

Database DevOps Metrics

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Database DevOps Metrics

Replacing a NULL II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Replacing a NULL II

Visit the forum

Question of the Day

Replacing a NULL II

What is returned from this code in SQL Server 2022?

DECLARE
  @value INT = NULL
, @value2 VARCHAR(20) = NULL;
SELECT COALESCE (@value, @value2, 100.5) AS Result;
GO

See possible answers