Consolidating Cloud Backups
I am a big fan of the cloud. While I appreciate local storage and privacy/control/security, etc., that stuff can also go away locally. Plus, I like the convenience, and...
2024-01-24
42 reads
Blog Posts
Switching between different active physical relationships in a Power BI model
A couple of weeks ago, I encountered a DAX question that I had not previously considered. They had a situation where there were two paths between two tables: on...
2024-01-24 (first published: 2024-01-09)
497 reads
Using Spark Connect from .NET to run Spark jobs on Databricks
All Spark Connect Posts
Goal of this post This post aims to show how we can create a .NET application, deploy it to Databricks, and then run a Databricks job...
2024-01-24 (first published: 2024-01-23)
111 reads
Your gradient fill bar charts in Power BI have poor color contrast, but you can fix them
Since conditional formatting was released for Power BI, I have seen countless examples of bar charts that have a gradient color fill. If you aren’t careful about the gradient...
2024-01-23
23 reads
Common Data Mesh exceptions
When it comes to data meshes that have been constructed or are currently under development, I have not observed any instances where the four core data mesh principles have...
2024-01-22 (first published: 2024-01-04)
225 reads
Using AI to create test data
Have you ever been tasked with creating test data for an application and then ran into performance problems once the application moves to production? Many of us manage databases...
2024-01-22 (first published: 2024-01-08)
639 reads
A New Word: Altschemerz
altschmerz – n. a sense of weariness with the same old problems that you’ve always had, the same boring issues and anxieties you’ve been gnawing on for decades, which...
2024-01-19
12 reads
Building a Docker image from a Github repository
To build a custom Docker image we create a docker file with instructions in it. For example, a really simple custom SQL Server 2019 Docker image can be built...
2024-01-19 (first published: 2024-01-05)
282 reads
I’m Speaking!
After a long hiatus of not blogging, I’m trying to get back into writing. So, to kick it off first thing in 2024, I’m speaking! I’m honored to have been...
2024-01-19
17 reads
Prompt EAP AI Experiments: Creating a History Table
SQL Prompt has an EAP using an AI model to help write code. I’ve been lightly experimenting with it, since I think AI is an interesting tech and it’s...
2024-01-19 (first published: 2024-01-05)
262 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