SQL Prompt has some nice color coding features, but sometimes I want a database to keep the same color, regardless of instance. I don’t know that I’d recommend this,...
2020-08-04 (first published: 2020-07-22)
363 reads
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...
2020-08-04
16 reads
This article was first published on: 2020-03-14.
This article will probe the performance benefits of columnstore indexes, on a transactional (OLTP) workload for real-time analytics.
We'll cover examples...
2020-08-04 (first published: 2020-07-23)
464 reads
I’m delighted to announce I’ll be speaking again at DataMinds Connect this year, one of the greatest and best Microsoft Data Platform conferences on the European mainland. Due to...
2020-08-04
14 reads
I have wrote a number of blogs on the topic of business continuity in SQL Database before (HA/DR for Azure SQL Database, Azure SQL Database high availability, Azure SQL...
2020-08-03 (first published: 2020-07-20)
433 reads
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...
2020-08-03
6 reads
Over the years I’ve had this blog, I’ve added lots of tags. In 15 years and 4,600+ posts, you can guess that I’ve made some typos and mistakes. I’ve...
2020-08-03
16 reads
Watch this week’s video on YouTube. A Giant Heap Recently I had to filter out 1.2 billion records from a 3.5 billion row heap. Don’t ask me why this...
2020-08-03 (first published: 2020-07-22)
288 reads
Looking forward to virtually presenting at SQLSaturday Auckland 2020 this weekend! I'll be presenting at 10:45AM Auckland time on Saturday, but that's 5:45pm Friday evening where I am in Central...
2020-08-03
14 reads
Press ADF Release Notes 07/31/2020 I believe this is the first Release Notes from ADF Team. Working with Git repositories in Azure Pipelines Multi-repository access and more. DevOps for...
2020-08-02
18 reads
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Hi to all We have situation at a client where someone is illegally changing...
Hi to all We have situation at a client where someone is illegally changing...
Ruko Soho Emas, Jl. Klampis Jaya No.39, Klampis Ngasem, Sukolilo, Surabaya, Jawa Timur 60117
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