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

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

Blogs

Rolling Back a Broken Release

We had an interesting discussion about deployments in databases and how you go forward...

A bespoke reporting solution doesn’t have to cost the earth

By ChrisJenkins

You could be tolerating limited reporting because there isn’t an off the shelf solution...

Presenting with Visual Studio Code

By Andrew Pruski

A while back I wrote a quick post on setting up key mappings in...

Read the latest Blogs

Forums

Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform

Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...

Creating JSON III

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Creating JSON III

Testing is Becoming More Important

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Testing is Becoming More Important

Visit the forum

Question of the Day

Creating JSON III

In a SQL Server 2025 table, called Beer, I have this data:

BeerIDBeerName
1Becks
2Fat Tire
3Mac n Jacks
4Alaskan Amber
8Kirin

I run this code:

SELECT JSON_OBJECTAGG(
    BeerID: BeerName )
FROM beer;

What are the results?

See possible answers