When using a Geo Replicated Azure SQL Database Readable Secondary there are a few things to consider when it comes to performance tuning. Check out this episode of Data Exposed:...
2021-07-12 (first published: 2021-06-30)
274 reads
Tomorrow, July 13, 2021, I will be giving a webinar on data security and compliance. Here’s the sign-up link: SQL Server Data Security and Compliance sign-up (free, but registration...
2021-07-12
42 reads
When someone older than you dies, it’s sad, though I feel that I can cope. I hold memories dear, I appreciate the time I had with an individual, and...
2021-07-11
216 reads
I recently was a part of GestaltIT’s AI Field Day and have been thinking heavily about artificial intelligence (and by extension, machine learning and deep learning) lately. I put...
2021-07-09 (first published: 2021-06-28)
256 reads
I wrote recently about the use of the command line in SQL Compare 14 to find differences for specific items. Now I want to actually see the changes to...
2021-07-09 (first published: 2021-06-28)
174 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...
2021-07-09
11 reads
In the last post we built an image of SQL server 2019 Linux hosted in Azure Container Instance for fast access to SQL server. So, your next question is...
2021-07-08
66 reads
Azure Resource Manager (ARM) Template is a cloud automation API for deploying Azure resources such as VM, database, network and storage services repeatedly with little(more...)
2021-07-08
50 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...
2021-07-08
37 reads
Running DBCC CHECKDB or DBCC CHECKTABLE on a database may report error 8961. Such a situation could occur while changing the data type of a table column from “ntext...
2021-07-08
16 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...
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
Jl. Raden Saleh No. 13, 15, 17A, Daerah Khusus Ibukota Jakarta 10430
Jl. K.H. Wahid Hasyim No.183 A-B, Kb. Kacang, Kecamatan Tanah Abang, Kota Jakarta Pusat,...
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