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

540 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,292 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

608 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,778 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,727 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

618 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

755 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,860 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,351 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

485 reads

Data Savvy

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

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

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

Insufficient Disk Space (T-SQL Tuesday #88)

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

Blogs

Ramblings about data communities and your contributions, no excuses

SQL Server Journey till 2025 (brief)

Building Power BI Reports: Desktop vs Fabric

Forums

Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE

Having a Little Fun at SQL Server Central

Designing SQL Server Pipelines That Are Ready for AI Before You Actually Need AI

Question of the Day

String Similarity I