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

622 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

768 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,892 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,386 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

488 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

650 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,452 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,145 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

Data Savvy

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

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

Please Lend Me Your Vote for Documentation of TMSCHEMA DMVs

Process Compatibility Level 1200 SSAS Tabular Model from SSIS 2014

Documenting your Tabular or Power BI Model

BYO Time Zone Conversion With SSAS DMVs

DAX Date Dimension and Fun with Date Math

Create a Date Dimension in Azure SQL Data Warehouse

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

Using Context To Traverse Hierarchies In DAX

Blogs

Restore SQL Server Database to an OrbStack Container

Day of Data Baton Rouge Slides and Code

Using Claude Code as a Database SRE Agent with the Everpure Fusion MCP Server

Forums

ALAMAT BCA KCU SCBD Telp:08218154392

Alamat Kontak BCA KCU BEKASI WA CS:08218154392

ALAMAT BANK BCA KCU GUNSA 45 TLP/WA 08218154374

Question of the Day

SQL Server Certificates