Watch this week’s episode on YouTube. SQL Server’s cost-based query optimizer does a pretty good job of figuring out what order to filter your data to get fast query...
2019-06-04 (first published: 2019-05-21)
556 reads
When looking at the Certified Information Systems Auditor (CISA) exam, we focus on teaching 3 types of controls: Preventative – keeps an incident from occurring Detective – Identifies the...
2019-06-04
305 reads
Are you coming to town for SQL Saturday 883 in Louisville KY, if you are going to be around the area on August 2nd, I’ll be presenting an all...
2019-06-04
7 reads
Are you coming to town for SQL Saturday 883 in Louisville KY, if you are going to be around the area on August 2nd, I’ll be presenting an all...
2019-06-04
61 reads
Are you coming to town for SQL Saturday 883 in Louisville KY, if you are going to be around the area on August 2nd, I’ll be presenting an all...
2019-06-04
5 reads
Database Engineering: Database Modelling: Do I need to have an incrementing identity int/bigint as my clustered index in a SQL Server database? When you want to produce a professional...
2019-06-03
10 reads
Database Engineering: Database Modelling: Do I need to have an incrementing identity int/bigint as my clustered index in a SQL Server database? When you want to produce a professional...
2019-06-03
9 reads
Google first reported an “Issue” on Jun 2, 2019 at 12:25 PDT. As is now common in any type of disaster, reports of this outage first appeared on social...
2019-06-03
30 reads
Yep. It’s time for your monthly homework session. You’ve finished last months right? Please turn it in over there. This ... Continue reading
2019-06-03
27 reads
Hello Baton Rouge! David Pless and I will be teaching an all day workshop on Performance Tuning and Optimization for Modern Workloads (SQL Server 2017, Azure SQL Database, and...
2019-06-03
6 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