Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
The Voice of the DBA
 

Spring Connections and Learning at PASS On Tour

It's just a few weeks until the spring PASS On Tour Chicago 2026. This is a smaller version of the PASS Summit that will be coming to Seattle in November and has been running for 26 years each fall. Myself and many other data professionals have found immeasurable value from the time we've spent with others at these events.

Connect. Share. Learn.

That's the motto that PASS adopted many years ago, and I love it. We get to network with each other, talk about our experiences, challenges, and struggles, and hopefully find a way past them. We are stronger as a team, and the synergies that come from people working together allow us to accomplish more than we ever would alone.

The PASS Summit has been an event at which this has happened, and I've been very lucky to attend most of them. I've learned lots of tips and tricks in sessions, but much more by talking with others before or after the presentations. I've been inspired by others and warned about walking down paths where people have struggled. All of the knowledge shared with me has helped grow my career across the last 26 years.

In 2025 there were 3 tour events, and I was able to attend all of them. They were small, but I still had ample opportunities to connect with others, learn from them, share with them, and get out to a few dinners with friends who didn't plan on coming to Seattle, but they made one of the regional events.

This year there is just one tour stop in the US. May 7-8 in Chicago, and I get to go again. There's a fantastic lineup of speakers, some great pre-cons, all at a relatively cheap price compared to many other data events. Chicago is easy to get to and it's not too expensive to spend a few days in one of America's classic cities.

I hope you'll join me in Chicago. It's short notice, but there are still chances to join, and I've got a discount code if you ping me

Steve Jones - SSC Editor

Join the debate, and respond to today's editorial on the forums

 
 Featured Contents
SQLServerCentral Article

T-SQL in SQL Server 2025: JSON_ARRAYAGG

Steve Jones - SSC Editor from SQLServerCentral

Learn how the JSON_ARRAYAGG() function works in SQL Server 2025.

External Article

Microsoft On-Premises Data Gateway Administration

Additional Articles from MSSQLTips.com

As a Microsoft Fabric Administrator, you have the responsibility to manage all the Microsoft Enterprise gateways installed and deployed across your entire data estate.

Blog Post

From the SQL Server Central Blogs - Fabric Mirroring doesn’t start copying Rows

Koen Verbeeck from Koen Verbeeck

A short blog post about an issue with Fabric Mirroring (with Azure SQL DB as the source) that I’ve managed to run into, twice. I’ve set up mirroring by...

Blog Post

From the SQL Server Central Blogs - JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger

Steve Jones - SSC Editor from The Voice of the DBA

I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an example of why it can behave weirdly. This post looks at something you might not...

SQL Server 2025 Unveiled: The AI-Ready Enterprise Database with Microsoft Fabric Integration

SQL Server 2025 Unveiled: The AI-Ready Enterprise Database with Microsoft Fabric Integration

Site Owners from SQLServerCentral

With built-in AI for application development and advanced analytics powered by Microsoft Fabric, SQL Server 2025 empowers you to innovate—securely and confidently. This book shows you how.

 

 Question of the Day

Today's question (by Steve Jones - SSC Editor):

 

Multiple Sequence Values

How do I easily get the next 12 sequence values from a sequence object?

Think you know the answer? Click here, and find out if you are right.

 

 

 Yesterday's Question of the Day (by Steve Jones - SSC Editor)

Detecting Deadlocks

By default, how often is the SQL Server Database Engine checking for deadlocks?

Answer: 5 seconds

Explanation: By default, the engine is checking every 5 seconds. Ref: Deadlock Detection - https://learn.microsoft.com/en-us/sql/relational-databases/sql-server-deadlocks-guide?view=sql-server-ver17#deadlock-detection

Discuss this question and answer on the forums

 

 

 

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.


SQL Server 2019 - Administration
Troubleshooting WQL in custom PBM conditions? - Hi, I'm currently trying to implement policy based mgmt with a condition to query event viewer using 'ExecuteWql'. However, WMI uses a different time format, so in addition to my WQL query, I'm nesting concatenating DATEPART() segments to build WMI-time for my WHERE clause. I'm aware of the differences with the GETDATE() syntax ('Day' vs […]
SQL Server 2019 - Development
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 param from the sql agent job that runs that pkg. is this as good as it gets?
Editorials
Local Agents - Comments posted to this topic are about the item Local Agents
Every Database Has Problems - Comments posted to this topic are about the item Every Database Has Problems
Job Postings
Hiring: Financial SQL Systems Administrator - Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial systems environment across a multi-office international law firm. Locations: Atlanta, Irvine, or Los Angeles (Full-time, Hybrid) This role is ideal for someone who enjoys working with SQL, troubleshooting financial systems, and improving platforms used daily by accounting and billing teams. You’ll work […]
Job Opening for ERP Systems Administrator - Hybrid - Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific Time Zone or Mountain ERP Systems Administrator in Long Beach, California | Careers at Long Beach What we are looking for We are looking for an ERP Systems Administrator who will be the primary technical expert responsible for the configuration, maintenance, and […]
Article Discussions by Author
Detecting Deadlocks - Comments posted to this topic are about the item Detecting Deadlocks
Introducing the Relational Embedding Retrieval Pattern: Storing and Querying Vector Embeddings in SQL Server - Comments posted to this topic are about the item Introducing the Relational Embedding Retrieval Pattern: Storing and Querying Vector Embeddings in SQL Server
Creating a JSON Document II - Comments posted to this topic are about the item Creating a JSON Document II
Backing Up Azure Key Vault EKM Key: Stairway to TDE Level 6 - Comments posted to this topic are about the item Backing Up Azure Key Vault EKM Key: Stairway to TDE Level 6
The Vector Data Type - Comments posted to this topic are about the item The Vector Data Type
What Power BI DirectQuery does to your SQL Server (and how to fix it) - Comments posted to this topic are about the item What Power BI DirectQuery does to your SQL Server (and how to fix it)
SQL Server 2022 - Administration
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 of         2026-04-23 00:30:18.7770000 +00:00 Last_compile_duration of 17105 Sys.query_store_runtime_stats for the plan, between 2026-04-23 00:00:00 and 2026-04-23 01:00:00, show an avg_duration of 74429 and execution_count of 1 sys.query_store_wait_stats shows a CPU and Buffer IO waits totalling 33ms So if […]
Analysis of Locking Issues on Secondary Replicas in AlwaysOn Availability Groups - We have an AlwaysOn architecture with four replicas: two running in synchronous commit mode (cluster) and two in asynchronous commit mode. On the primary replica, we run SSIS workloads. The secondary replicas are used for reporting, with read-only operations routed through ApplicationIntent = ReadOnly. We also enabled AG load balancing to distribute the reporting workload […]
SQL Server 2022 - Development
data compare between 2 tables with same structure for any changes after etl run - i have huge table with lot of data and is also wide. i took a backup of it before procedure is run in test environment. now i am trying to see only using SQL what changed and finally what i am expecting is how many inserts, updates or deletes are there. i have some idea […]
 

 

RSS FeedTwitter

This email has been sent to {email}. To be removed from this list, please click here. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -