EightKB Summer 2021 Edition
The schedule for EightKB Summer 2021 Edition has been announced! Here’s the schedule: – N.B. – I particularly like that if you click on the session on the website,...
2021-07-02 (first published: 2021-06-15)
201 reads
Blog Posts
Is the [sysname] SQL Server System Data Type Alias Name Case-Insensitive?
(last updated: 2021-07-02 @ 19:55 EST / 2021-07-02 @ 23:55 UTC ) The sysname data type (in SQL Server) is a system-provided, though not built-in, alias for NVARCHAR(128). This...
2021-07-02
122 reads
Quickly Determining Azure SQL Database Size
Recently I needed to determine how much storage space each database on a logical server was consuming. I was doing some DR testing and I need to give the...
2021-07-02
85 reads
Daily Coping 1 Jul 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-07-01
16 reads
I Still Can’t Believe It!
I received my MVP award letter from Microsoft today. This will make the fourth time I’ve been awarded and I still can’t believe it. I just wanted to help...
2021-07-01
29 reads
MVP for Another Year 2021-2022
A few minutes ago, I received an email from Microsoft presenting me with the 2021-2022 Microsoft Most Valuable Professional (MVP) award. This is my 8th award and I am...
2021-07-01
31 reads
SQL Homework – July 2021 – Log shipping
Log shipping is probably the least complicated and easiest to configure of the various methods of creating a secondary copy ... Continue reading
2021-07-01
33 reads
Daily Coping 30 Jun 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-06-30
41 reads
Data Mesh: Centralized vs decentralized data architecture
One of the biggest differences between the Data Mesh and other data platform architectures is a data mesh is a highly decentralized distributed data architecture as opposed to a...
2021-06-30
24 reads
Long names vs short names (or aliases)
I remember when I was first learning to code there was always the argument of how long a name should ... Continue reading
2021-06-30 (first published: 2021-06-15)
1,045 reads
Blogs
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
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...
Forums
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
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