T-SQL Tuesday #185: Video
This month’s invite is from Erik Darling, who invites you to make a video on any topic of your choice. I liked his reasoning for this and appreciate his...
2025-04-23 (first published: 2025-04-08)
220 reads
Blog Posts
Azure Data Factory Pipeline Debugging Fails with BadRequest
I recently had a new pipeline fail. It was actually a copy of an old pipeline where I had made some adjustments into as part of a database migration....
2025-04-21 (first published: 2025-04-04)
345 reads
Comparing My Current Schema with a Backup with SQL Compare
A customer asked if they needed to restore a database from backup to compare the schema in a database. They don’t and this post shows that. This is part...
2025-04-21 (first published: 2025-03-31)
274 reads
A New Word: Immerensis
immerensis – n. the maddening inability to understand the reasons why someone loves you – almost as if you’re selling them a used car that you know has a...
2025-04-18
39 reads
Deploy a Dockerized Python TODO App to Azure Container Apps Using Pulumi and Azure Key Vault
In this post, I will guide you on how to deploy a dockerized simple flask-based TODO application to Azure Container Apps using Pulumi. You will Dockerize the Python application,...
2025-04-18
65 reads
Improving Our Conversations
If we aren't having the same conversation, we aren't going to be heard. That's what Charles Duhigg, author of The Power of Habit, covered in the following TED talk:
2025-04-18 (first published: 2025-03-31)
359 reads
The Book of Redgate–Being Reasonable
As a part of the Book of Redgate, we have a series of (red, of course) pages with the title “What we believe”. These are our values, as set...
2025-04-18 (first published: 2025-04-04)
410 reads
Understanding Lakehouse Permissions in Microsoft Fabric
Understanding how permissions work in Microsoft Fabric can be essential for anyone managing access to Lakehouses, SQL Endpoints, or Semantic Models.
2025-04-16 (first published: 2025-04-03)
601 reads
Unlocking Real-Time Financial Insights: The Power of Microsoft Fabric
Microsoft Fabric is transforming real-time analytics for financial institutions. It provides a unified data platform. This platform integrates various data sources into a single, cohesive system. This integration breaks...
2025-04-16 (first published: 2025-04-03)
334 reads
Distributed Availability Group Dashboard
The Distributed Availability Group Dashboard can be downloaded from our GitHub repo. https://github.com/SQLUndercover/UndercoverToolbox/blob/master/DAG%20Dashboard.pbix. This comes off of the back of my last post looking at using a distributed availability...
2025-04-14 (first published: 2025-04-01)
370 reads
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
setting an ssis param dynamicaly when the sql agent job runs
hi i was hoping for a more elegant way of setting a pkg level...
Query compile/runtime issue
I have a plan which in sys.query_store_plan shows: Last_compile_start_time of 2026-04-23 00:13:00.7670000 +00:00 Last_execution_time...
Hiring: Financial SQL Systems Administrator
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams n;See possible answers