Daily Coping 15 Oct 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-10-15
15 reads
Blog Posts
PASS Data Community Summit 2021: I’m Excited!
I sincerely hope this isn’t the first time you’re hearing about the Pass Data Community Summit that’s coming up in just a few weeks on November 8-12, 2021. But,...
2021-10-15 (first published: 2021-10-04)
242 reads
Power BI Meets Programmability – TOM, XMLA, and C#
For anyone who read the title of this and immediately thought, “Oh no, I can’t do C#! Since when do I need to be in app dev to do...
2021-10-15
15 reads
Quick Database Copies and Branching with Spawn
I delivered a talk last week at the Future Data Driven summit. It’s one I’ve done a few times, but I really enjoy it. It’s on the Future of...
2021-10-15 (first published: 2021-10-04)
277 reads
Daily Coping 14 Oct 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-10-14
11 reads
Connect Excel to a Power BI Dataset in a Premium Workspace with a B2B User
Power BI offers the ability for users who have access to a dataset in the Power BI service (PowerBI.com) to connect to the dataset using Excel. Normally, this feature...
2021-10-13 (first published: 2021-09-30)
200 reads
Daily Coping 13 Oct 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-10-13
13 reads
Power BI: Adding Columns to a Published Data Model using the XMLA Endpoint & TMSL
Goal of this demo: Update a Power BI model schema by adding a column to the data model without opening a PBIX file and ensure the scheduled refresh still...
2021-10-13 (first published: 2021-10-01)
1,476 reads
Redgate’s Pre-con at the 2021 PASS Data Community Summit
I was fortunate to present a pre-con at the PASS Summit alongside Kendra Little in 2019. That was the last in person event, and I really enjoyed the session....
2021-10-13
12 reads
SQL Server meta-development (with regular expressions and more)
Yesterday, I had about 30 existing queries (and some multi-query processes) that I needed to turn into individual stored procedures. […]
The post SQL Server meta-development (with regular expressions and...
2021-10-13
11 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...
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