Finding Object Dependencies in SQL Doc
I had a customer recently ask if they could find out which objects are dependent on others using SQL Doc. This post shows how to do that. Using SQL...
2023-11-01
318 reads
Blog Posts
SQL Server Backups are Not a High-Availability Solution
Please continue doing your backups! Backups are Disaster Recovery, yes…but not HA. Some will argue with this (in the comments most likely), but I broadly define “High Availability” as...
2023-11-01 (first published: 2023-10-17)
334 reads
Using the Pure Storage PowerShellSDK2 - Part 3 - Getting Performance Data from FlashArray
Welcome back to the second installment of our blog series on using the Pure Storage PowerShell SDK2. In this post, we’ll learn how to retrieve performance data from FlashArray...
2023-11-01 (first published: 2023-10-18)
160 reads
Common Mistakes in SQL Server – Final
In this final and summary post on the blog series of Common Mistakes in SQL Server I have pen down about auto growth, use of null values, implicit conversion...
2023-10-30
10 reads
Fabulous Stuff in Fabric – Part 1: Cloning Tables
A while ago I had a little blog post series about cool stuff in Snowflake. I’m starting up a similar series, but this time for Microsoft Fabric. I’m not...
2023-10-30 (first published: 2023-10-17)
342 reads
T-SQL Tuesday 167 – Encryption and Data Protection Roundup
Huge thanks to everyone who responded to my invitation to blog on Encryption and Data Protection for this month’s T-SQL Tuesday. I got what I hoped for, which was...
2023-10-30 (first published: 2023-10-17)
318 reads
A New Word: Funkenzwangsborstellung
funkenzwangsborstellung – n. the primal trance of watching a campfire in the dark. I am not a big camper, but 3-4 times a year we usually go out with...
2023-10-27
20 reads
Common Mistakes in SQL Server – Part 5
Last week, in the post Common Mistakes in SQL Server - Part 4 I explained about the Auto Growth configuration in SQL Server and how it can adversely impact....
2023-10-27 (first published: 2023-10-16)
1,226 reads
Creating a SQL Clone Image from a SQL Clone Database
A customer asked if a new image could be created from a database that was itself a SQL Clone. It can, and I’ll show that in this post. This...
2023-10-27 (first published: 2023-10-16)
215 reads
Suppressing the FOMO
I saw a post recently on Twitter/X/whatever we call it. It was for a DevOps in a Day from Redgate taking place in Jacksonville. I’ve been a part of...
2023-10-27
17 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