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

Half of All Engineers

The AI LLM boom seems to show no sign of slowing down. Each time I think we've reached some level of crazy use or predictions, things take another turn. I still find myself pinging back and forth between this will be amazingly good and horrifyingly bad.

Sometimes on the same day.

Today, I'm a little more down on AI. I was listening to Steve Yegge on the Pragmatic Engineer podcast, and they were discussing the curve of AI usage at companies. He points out that he's mad that Amazon let 16,000 engineers go and might let more go. He worries that companies might let 50% of their engineers go. Not necessarily because the top 50% will be more productive with AI than 100% of engineers without it. Rather the concern is that companies will get rid of half their salaries to pay for the AI tokens for the other half.

Steve Yegge is an accomplished software engineer that has worked at Amazon and Google. Steve wrote Gastown and has been someone who not only is successful at producing code but also thinks a lot about how we produce more software.

How coordinated and powerful are the new models? Can they really do a lot of software work that we do today? Steve thinks so, but to be fair, he's got a lot of experience and can architect and design software well, which means he can also guide AI LLMs and agents to write more code. He also thinks the latest models, like Opus 4.6, are way more capable that most people believe.

I also caught this post on X about a paper predicting that AI might cause economic collapse as less knowledge workers are used in various tasks. This might happen faster than we can absorb those workers who are laid off in the name of AI back into the economy in other positions. It's a scary thought.

The positive side of this, at least from me, is that so many organizations move slower, and so many people aren't extremely competent software engineers, so we'll get a lot of bad software written by non-technical people that doesn't scale. We'll have more database (and application) performance issues, and that will slow the use of YOLO, vibe coding.

Plus plenty of companies just aren't implementing or looking to pay for lots of tokens. They'll just move slower and the world will change, but not anywhere near the pace that Steve or others think it will. We'll see, but let me know what you think.

For a more positive spin, I've been reading Reshuffle, which is a little less depressing about the future.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

T-SQL Trigonometric Functions in SQL Server

Imran2629 from SQLServerCentral

Introduction SQL Server includes several built-in mathematical functions that allow developers to perform complex calculations directly within queries. Among these are trigonometric functions such as SIN(), COS(), and TAN(), which are useful in scenarios involving engineering calculations, geographic data processing, simulations, and analytics. Although these functions are straightforward to use, developers occasionally encounter unexpected results […]

External Article

How Multi-Column Statistics Work

Additional Articles from Brent Ozar Blog

The short answer: in the real world, only the first column works. When SQL Server needs data about the second column, it builds its own stats on that column instead (assuming they don’t already exist), and uses those two statistics together – but they’re not really correlated.

Blog Post

From the SQL Server Central Blogs - OpenClaw- Agentic Engineering

Vinay Thankur from Vinay Thakur

This week has training on AI – Cyber security experts – Omar Santos and Aamir Lakhani- with great knowledge . during the session learned about OpenClaw and more. I...

Blog Post

From the SQL Server Central Blogs - Visualising Vectors in High Dimensional Space

dbafromthecold@gmail.com from The DBA Who Came In From The Cold

Following on from my previous post on building The Burrito Bot, I want to delve into visualisation of vector embeddings that were generated from the restaurant data pulled from...

SQL Server 2025 Query Performance Tuning: Troubleshoot and Optimize Query Performance

Site Owners from SQLServerCentral

A new era of SQL Server is here, and this latest edition of Grant Fritchey’s best-selling dive into SQL Server query performance can ensure your queries keep up.

 

 Question of the Day

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

 

How Long is a Long I/O?

In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?

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)

Multiple Sequence Values

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

Answer: Use sp_sequence_get_range

Explanation: The proc sp_sequence_get_range is used to get a range of sequence values from a SEQUENCE object. Ref: sp_sequence_get_range - https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-sequence-get-range-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
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

 

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