Power BI: Refreshable Excel Files in PBI Service
Ever since Excel made its debut in the 1980’s, it has been used as a quick way for end users to input and manipulate data on their own without...
2024-06-03 (first published: 2024-05-14)
374 reads
DataOnWheels
Dynamically Unpivot columns in SQL
Picture this, your data ingestion team has created a table that has the sales for each month year split into different columns. At first glance, you may think “what’s...
2024-05-27 (first published: 2024-05-10)
657 reads
SQL Saturday Atlanta 2024
Hey there happy coders! Last weekend I had the pleasure of speaking at the SQL Saturday Atlanta event in Georgia! It was an awesome time of seeing data friends...
2024-04-30
31 reads
First Time Speaking with a Mask at an Event
Over the past couple of months, I have started losing my ability to talk without a mask. One of the effects of a disease, ALS, is that I am...
2024-04-19
28 reads
Derby City Data Days
It was awesome to see the Kentucky data community come out for the first Derby City Data Days in Louisville, KY! Bringing together communities from Ohio, Tennessee, and Kentucky,...
2024-04-16
23 reads
Working with ALS – Insights from the Ability Summit
The 14th annual Ability Summit is a global event that I attended a few weeks ago. It is hosted by Microsoft, and it presents the latest technology innovations and...
2024-03-29 (first published: 2024-03-27)
22 reads
SQLBits 2024 Recap
Had an absolutely amazing time at SQLBits this year! It was lovely to see all my data friends again and had the opportunity to introduce my husband to everyone...
2024-03-12
25 reads
DataTune Nashville 2024 Recap
DataTune 2024 was a huge success! Thank you so much to the organizers who spent countless months planning and making this an incredible conference! It was so great to...
2024-03-18 (first published: 2024-03-11)
117 reads
SQL Saturday ATL – BI Recap
First of all, wow! What an incredible event! Loved seeing everyone and meeting so many wonderful new people. Thank you to everyone who organized, spoke, and attended this event!...
2024-02-14
25 reads
How to Call REST API using VS Code
Sometimes you need a fast way to test your API call and responses, and for that VS code is the perfect tool to do that. For today’s demo, we...
2024-02-07 (first published: 2024-01-24)
964 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers