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

There's Too Much to Learn

I remember getting started on SQL Server and trying to upskill myself in the mid-1990s. At that time, my employer was running a SQL Server 4.2 instance for a third-party application, but we wanted to rewrite our internal bespoke sales app to run on SQL Server. We were upgrading from Foxpro to Visual Foxpro and looking to move from shared dbf files to a SQL Server. There was a new release of SQL Server 6.5 during our development, and I wanted to learn more about it. I purchased Inside SQL Server 6.5 and read the entire thing, getting prepared to finish development and then manage a new platform in production.

I had updated copies of that book as SQL Server released new versions until SQL Server 2005. When that came out, there weren't one, but rather 4 books to cover the Inside SQL Server details (Programming, Query Tuning, T-SQL, and The Storage Engine). A similar thing happened with the SQL Server Bible, which grew in size to over 1400 pages for the 2012 version. It was a backache in a book if you put it in with your laptop.

Since then, the growth of the Microsoft Data Platform, which includes SQL Server, has been incredible with lots of changes not only to the box/on-premises product many of us install, but to the related systems in Azure. The SQL variants, Fabric, Power BI, Azure Data Factor, and more. It feels like there is way too much to learn  I know I can't keep up, and I expect most people feel the same way.

Coping with the load and the accompanying imposter syndrome is hard. It's hard on your psyche and it's hard when others in your organization, especially your boss, expect you to understand how to work with T-SQL, even when they might refer to SQL Server in one request and SQL Database in Fabric in another. They might even expect that you know "everything database-related", including how to troubleshoot their Azure PostgreSQL Flex server performance issue.

AI can help, as can some strong Google skills and an eye that spots the information you need. Whether to do actual work or help guide an AI LLM along a path. I would argue that improving your ability to differentiate what's better from what's worse is becoming even more important in the age of vibe coding. Even if you aren't a YOLO, let-Claude-Code-do-it's-thing, others are and they'll call you when they don't get the results they want.

Or when their system performs poorly against your database system. Who knows how many implicit conversion issues or RBAR pieces of code an LLM will write. There's a lot of that sample code out on the Internet, and much of that code goes into training these models.

I don't have a magic solution for keeping up, other than build the habit of learning. Practice new techniques, play with code, conduct experiments in the things that plague your environment, or that you see others working with. I don't mess with Hyperscale much as I don't see it with customers, but I do see other technologies, like System-versioned tables. So I spend time there, learning what works well and what doesn't. Those are the skills that help me keep up with the knowledge I need to work with LLMs and humans.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

How to Calculate Distance Between Coordinates in SQL Server

Imran2629 from SQLServerCentral

Learn a quick way to calculate distances without resorting to spatial calculations.

External Article

Can SQL Server 2025’s REGEXP_SPLIT_TO_TABLE fix STRING_SPLIT in T-SQL?

Additional Articles from SimpleTalk

Learn how to split strings efficiently in T-SQL using STRING_SPLIT and the REGEXP_SPLIT_TO_TABLE function in SQL Server 2025.

Blog Post

From the SQL Server Central Blogs - Overcoming Imposter Syndrome: A Plan

K. Brian Kelley from Databases – Infrastructure – Security

My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework (DTEF) foundation exam. I’m blogging about it because I know a lot of people struggle...

Blog Post

From the SQL Server Central Blogs - Get a Range of Sequence Values: #SQLNewBlogger

Steve Jones - SSC Editor from The Voice of the DBA

I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks at how the proc works. Another post for me that is simple and hopefully serves...

Storytelling with Data: Let's Practice!

Site Owners from SQLServerCentral

Influence action through data! This is not a book. It is a one-of-a-kind immersive learning experience through which you can become—or teach others to be—a powerful data storyteller.

 

 Question of the Day

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

 

SSoL Support on the OS

On which Linux versions is SQL Server 2025 on Linux supported?

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)

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      1960

If I run this code, how many rows are returned?

SELECT TOP 2 
  json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;

Answer: 1

Explanation: 1 row is returned. This is an aggregate function that consolidates all the data from the table into a JSON document before the TOP is applied. If there were another column and a GROUP BY, the TOP would apply. Ref: JSON_OBJECTAGG() - https://learn.microsoft.com/en-us/sql/t-sql/functions/json-objectagg-transact-sql?view=sql-server-ver17

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
Having Issue deploying a report to an on prem server from PowerBI desktop - Using PowerBI Version1.25.9508.3237(January 2026). Installed Microsoft Power BI Desktop (Optimized for Power BI Report Server - January 2026). I get an error when I try to deploy a simple report to the on prem server. 2026-04-29 14:31:28.5398|ERROR|8|library|Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: , Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/PowerBI/Test2.pbix' cannot be found.;| RequestID = s_472c98e1-fc0d-4ad1-adce-43f79272dbe9 All other aspects of the server […]
SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade - Hi all Can I get some perspective from the community please on performing in-place OS upgrades on Windows servers, where there is a SQL instance layered on top. I have 2 Servers, Windows 2016 ones, that need upgrading to Windows 2022\Windows 2025 by end of year. There are 20 DB's on this instance, SQL 2019, […]
SQL Server 2019 - Development
Warning: Could not open global shared memory to communicate with performance DLL - Hi everyone I am getting below warning when I run SSIS: Warning: 0x80049304 at Update Table, SSIS.Pipeline: Warning: Could not open global shared memory to communicate with performance DLL; data flow performance counters are not available. To resolve, run this package as an administrator, or on the system's console. It gives the solution.  It works.  […]
General
A question about how to store the address in the database - I have an app that has an address field on the customer and the users. The address information on the users is informational and it is not used anyplace. The address used by the customer has only one purpose. It is one of the ways for the application administrator to determine that when they get […]
Integration Services
SSIS package failing intermittently on last Excel Component - Good Afternoon, I have a Job which "fires" off an SSIS package (that is sitting on SSMS Integration Services Catalog). The package simply contains a series of components which pick up data from various SQL tables and places it into corresponding sheets in the same Excel File. Now the package fails intermittently on the last […]
Editorials
A Tool is Better than a Script - Comments posted to this topic are about the item A Tool is Better than a Script
Half of All Engineers - Comments posted to this topic are about the item Half of All Engineers
Spring Connections and Learning at PASS On Tour - Comments posted to this topic are about the item Spring Connections and Learning at PASS On Tour
Let's Talk Community Events! - Comments posted to this topic are about the item Let's Talk Community Events!
Article Discussions by Author
Increase Deadlock Detection - Comments posted to this topic are about the item Increase Deadlock Detection
Understanding Deadlock Victim Selection in SQL Server - Comments posted to this topic are about the item Understanding Deadlock Victim Selection in SQL Server
How Long is a Long I/O? - Comments posted to this topic are about the item How Long is a Long I/O?
T-SQL Trigonometric Functions in SQL Server - Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL Server
T-SQL in SQL Server 2025: JSON_ARRAYAGG - Comments posted to this topic are about the item T-SQL in SQL Server 2025: JSON_ARRAYAGG
Multiple Sequence Values - Comments posted to this topic are about the item Multiple Sequence Values
 

 

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

 

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