T-SQL Tuesday #141 Work/Life Balance
This month’s T-SQL Tuesday is hosted by TJay Belt (@tjaybelt). I find this month’s topic, balancing work and life, intriguing, and after a hiatus of non-blogging, I’m happy that...
2021-08-10
25 reads
Blog Posts
Creating SQL Databases in AKS with PVC – Part 2
Last week I created the below with a dummy database and is something that I will do against SQL server but this time that has a persistent volume claim....
2021-08-09
52 reads
Daily Coping 9 Aug 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-08-09
13 reads
Data Mesh: Centralized ownership vs decentralized ownership
I have done a ton of research lately on Data Mesh (see the excellent Building a successful Data Mesh – More than just a technology initiative for more details),...
2021-08-09 (first published: 2021-07-23)
368 reads
How do I unlock a SQL Server Login using T-SQL (without changing the password)?
We recently had an application login (SQL Server authenticated) in one of our training environments start locking out on a ... Continue reading
2021-08-09 (first published: 2021-07-22)
810 reads
Podcast and presentation decks on data architectures
Tomorrow (Tuesday (8/10/21) I will be on a podcast for SaxonGlobal called “The Alphabet Soup of Data Architectures” where I will talk about the modern data warehouse, data fabric,...
2021-08-09
91 reads
Podcast and presentation decks on data architectures
Tomorrow (Tuesday (8/10/21) I will be on a podcast for SaxonGlobal called “The Alphabet Soup of Data Architectures” where I will talk about the modern data warehouse, data fabric,...
2021-08-09
5 reads
Container Limits and SQL Server
Limits in Containers Docker gives you the ability to control a container’s access to CPU, Memory, and network and disk IO using resource constraints, sometimes called Limits. You define...
2021-08-06 (first published: 2021-07-25)
1,027 reads
Daily Coping 6 Aug 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-08-06
17 reads
Using Aggregates in Calculations with Other Columns Functions–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. In the last post on Window functions, I...
2021-08-06 (first published: 2021-07-21)
929 reads
Blogs
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
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