Daily Coping 28 Dec 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-12-28
20 reads
Blog Posts
Queries that Fail and How to find Them
Queries will fail. That is as inevitable as death and taxes. This article demonstrates how to find some truly horrible queries.
The post Queries that Fail and How to find...
2021-12-28
802 reads
Statistics Auditing to make you Omniscient
This article demonstrates a more comprehensive method to audit changes to statistics. This method involves the use of Extended Events.
The post Statistics Auditing to make you Omniscient first appeared...
2021-12-28
18 reads
“Could not find the modules: 'Az.Accounts' with Version: ''” error message and a story to remember
(2021-Dec-20) Part of the continuous integration and delivery for Azure Data Factory involves pre-deployment and post-deployment steps. Their main role is to stop triggers before deployment and restart them afterward,...
2021-12-27 (first published: 2021-12-20)
3,460 reads
Daily Coping 27 Dec 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-12-27
16 reads
Tech Lunch News
8. prosince jsme se opet sešli u obeda nad novinkami ze sveta dat. Je super, že se stále více úcastní i lidé mimo JC – jsme rádi, že se...
2021-12-27 (first published: 2021-12-19)
130 reads
Daily Coping 24 Dec 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-12-24
19 reads
Getting Started with the Advent of Code as a #SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. If you want to get started blogging, or...
2021-12-24 (first published: 2021-12-08)
171 reads
Power BI DAX Getting the Value of Previous Non-NULL Row
If you are an avid report designer or user, you may have wanted to see the percent difference between one row and the previous one. Sounds easy right? Well...
2021-12-24 (first published: 2021-12-15)
1,575 reads
Daily Coping 23 Dec 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-12-23
15 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...
Free Webinar about Columnstore Indexes
I’m doing a small series on indexing basics for SQL Server, and on May...
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
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