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

Data Visualization Panel at PASS Summit

by Meagan Longoria

Data Savvy

Next week is PASS Summit 2017, and I’m excited to be a part of it. One of the sessions in...

2017-10-28

366 reads

Let Her Finish: Voices from the Data Platform

by Meagan Longoria

Data Savvy

This year I had the pleasure of contributing a chapter to a book along with some very special and talented...

2017-10-19

611 reads

The Tabular Model Documenter is now a Power BI Template

by Meagan Longoria

Data Savvy

A while back I created the Tabular Model Documenter Power BI model that can connect to your SSAS Tabular or...

2017-09-26 (first published: 2017-09-19)

2,369 reads

My Thoughts After Completing a Power BI Report Server POC

by Meagan Longoria

Data Savvy

Last month I worked on a proof of concept testing Power BI Report Server for self-service BI. The client determined...

2017-09-25 (first published: 2017-09-18)

3,545 reads

You Can Now Put Values On Rows In Power BI

by Meagan Longoria

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

6,577 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

535 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,285 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

601 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,770 reads

Blogs

Simplify Kubernetes Security With Kyverno and OPA Gatekeeper

By Ige Adetokunbo Temitayo

Here’s how these tools can make Kubernetes security easier and help you avoid common...

A New Word: Lackout

lackout – n. the sudden awareness that you’re finally over someone, noticing that the...

Delta Lake over Spark Connect

All Spark Connect Posts I have just finished an update for the spark connect dotnet...

Read the latest Blogs

Forums

Shades and Reflecting on SQLBits and the Bright Future of Data

Comments posted to this topic are about the item Shades and Reflecting on SQLBits...

Merge techniques

By purushotham.k9

In Azure SQL DB, i want to merge records from the staging table to...

SSRS error: The Value for the image 'Image1' has a constant value...

Full error message: SSRS error: The Value for the image 'Image1' has a constant...

Visit the forum

Question of the Day

Adding Defaults

I have a table, called dbo.logger, in SQL Server 2022. I decide to add two new columns to this table with this code.

ALTER TABLE dbo.logger ADD CreateDate DATETIME CONSTRAINT dfGetDate DEFAULT GETDATE()
GO
ALTER TABLE dbo.logger ADD ModifyDate DATETIME DEFAULT dfGetDate
GO

What happens when I run these two batches?

See possible answers