Data Savvy

Back in January 2016, I wrote a blog post explaining a DAX workaround that allows you to put measures on...

2017-08-29 (first published: 2017-08-11)

1,857 reads

Installing the Microsoft.ACE.OLEDB.12.0 Provider for Both 64-bit and 32-bit Processing

by Meagan Longoria

Data Savvy

I recently got a new laptop and had to go through the ritual of reinstalling all my programs and drivers....

2017-07-20

8,582 reads

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

by Meagan Longoria

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,869 reads

Data Savvy

You Can Now Put Values On Rows In Power BI

Installing the Microsoft.ACE.OLEDB.12.0 Provider for Both 64-bit and 32-bit Processing

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

Blogs

Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption

Why your data still can’t answer a simple question

T-SQL Tuesday #197 Invitation – An impactful session or two from a conference

Forums

The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI

Creating a Simple and Flexible Random Password Generator in SQL Server

SQL Art, Part 3: Happy Easter Fun in SSMS

Question of the Day

Identities and Sequences IV