Daily Coping 2 Mar 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-03-02
32 reads
Blog Posts
Daily Coping 1 Mar 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-03-01
13 reads
Power BI and a Star Schema
I sometimes get asked from customers if they should use a star schema or should they use one large single table/flatfile for their dataset in Power BI. The answer...
2021-03-01
12 reads
Power BI Monthly Digest – February 2021
In this month’s Power BI Digest Matt and I will again guide you through some of the latest and greatest Power BI updates this month.
2021-03-01 (first published: 2021-02-23)
365 reads
Updated Pluralsight Course – Kubernetes Installation and Configuration Fundamentals
My updated course “Kubernetes Installation and Configuration Fundamentals” in now available on Pluralsight here! If you want to learn about the course, check out the trailer here or if you want to dive right...
2021-03-01
51 reads
Upgrading Durable Function Extension of my Azure Function App
(2021-Feb-22) With more applications and services being placed into a vendor cloud environment, it does require almost no effort to manage and maintain the infrastructure these applications and services are...
2021-03-01 (first published: 2021-02-23)
1,131 reads
Viewing the Statistics Objects Used to Create an Execution Plan
Use trace flag 8666 to view the statistics objects that the optimizer used to generate your execution plan.
2021-03-01
28 reads
A Biography Template for New Presenters
Presenting is difficult, and you already know that. It is also incredibly rewarding and beneficial to your career, but that’s not important for this post. As difficult as it...
2021-02-28
8 reads
ADF: Querying JSON documents
In my previous blog post I talked about how to read from an XML Webervice and use xpath to query the XML on the expressions side of things. You...
2021-02-26
20 reads
Creating presentations with Reveal and Github pages
I really don’t like Powerpoint. I’ll do pretty much anything to avoid writing a presentation in it. Thankfully for the last few years there’s been a service called GitPitch...
2021-02-26 (first published: 2021-02-21)
244 reads
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCP Summarecon Bekasi Lyn Cs 083835110341
Jl. Bulevar Ahmad Yani, Graha Bulevar Signature (GBS) Blok C No. 3, RT.001/RW.011, Harapan...
BCA KCP Juanda Lyn Cs 083835110341
Jl. Insinyur H. Juanda No.54, RT.003/RW.001, Margahayu, Kec. Bekasi Tim., Kota Bks, Jawa Barat...
BCA Multifinance Surabaya Timur Tlpn.Wa 083834802131
Ruko Soho Emas, Jl. Klampis Jaya No.39, Klampis Ngasem, Sukolilo, Surabaya, Jawa Timur 60117
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers