Security in cloud environments is both challenging and fascinating, particularly for Database-as-a-Service (DBaaS) offerings like Amazon RDS, GCP CloudSQL and Alibaba ApsaraDB RDS. The cloud vendor acts as the system administrator, managing the operating system, patching, and backups, while the user manages their data and databases.
Create your own test lab on Hyper-V to evaluate SQL Server 2025 and Windows Server 2025
When we design a database or system, we often do so with corner cases in mind. We don't have to do this.
Learn about the critical 823 and 824 errors in SQL Server and how to deal with them in this article.
How can we build a random number generator using Marsaglia Polar method in SQL Server without the use of external tools?
This year I have been speaking with an increasing number of people about FinOps and what it means. Fundamentally, it is all about getting a handle on the cost for our technology spend. When we step back and look at the bigger picture it also has ramifications on corporate Environmental, Social, and Governance (ESG) programs […]
Earlier this year at SQL Saturday Austin 2025, Conor Cunningham gave a keynote that discussed the engineering efforts in the Austin office around SQL Server. One of the things he mentioned was PRODUCT(), which was written there and added to SQL Server 2025 to help with the GDP calculation for the US government. Yep, that's […]
Before SQL Server 2025, if you want to store JSON data in Microsoft SQL Server or Azure SQL DB, and you want fast queries, the easiest way is to:
Getting something done is important, but so is the quality level. Steve has a few thoughts today.
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...
BCA KCU BLOK A CIPETE HUB.Tlpn.0821•3111•185 Jl. RS. Fatmawati Raya No.6 A, RT.1/RW.5, Cipete...
Jl. Soekarno-Hatta No.240, Kb. Lega, Kec. Bojongloa Kidul, Kota Bandung, Jawa Barat 40227
Jl. Dulatip No.26 & 26A, Kb. Jeruk, Kec. Andir, Kota Bandung, Jawa Barat 40181
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