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

The Challenge of AI

In his book, The Coming Wave, the CEO of Microsoft AI laid out the risks of AI tech bluntly. “These tools will only temporarily augment human intelligence. They will make us smarter and more efficient for a time, and will unlock enormous amounts of economic growth, but they are fundamentally labor-replacing,” he wrote. Suleyman advocated for regulatory oversight and other government interventions, such as new taxes on autonomous systems and a universal basic income to prevent a socioeconomic collapse. This book was published before Suleyman joined Microsoft.

Satya Nadella is more optimistic than his new deputy. In an interview at Microsoft headquarters, while sitting next to his human chief of staff, Nadella said that his Copilot assistants wouldn't replace his human assistant. As his chief of staff sat typing notes of the conversation on her tablet, Nadella acknowledged that AI will cause “hard displacement and changes in labor pools,” including for Microsoft. Judson Althoff, Chief Commercial Officer, said that Nadella was pressuring his team to find ways to use AI to increase revenue without adding headcount.

In 2025, Microsoft has reduced quite a bit of its workforce. Over 9,000 earlier this year, though perhaps there will be some hiring in the future, according to Nadella. Nadella contends that AI could end up delivering more societal benefits than the Industrial Revolution did. “When you create abundance,” Nadella said, “then the question is what one does with that abundance to create more surplus.”

As I discuss AI with different people, I get wildly different opinions. The pace of GenAI model growth across the last two years has led quite a few people to believe that the technology will approach mimicking the average human's intelligence in just a few years. That's a scary thought, and it certainly could lead a lot of executives to place a bet on fewer human employees and more digital ones.

However, many more people believe that the GenAI models still need a lot of guidance, and they are best suited for partnerships with humans. That's good, in a sense. If a smart or talented human can use an AI partner and get a lot done, that means we still need some humans.

Some.

That use of AI by a few talented people might also lead us to a reduction in labor for a lot of organizations. Maybe fewer humans get more done with AI, and it's possible organizations want to make that trade. It's easy to think we'll find things for more humans to do, but computers are incredible levers, and this worries me.

A little.

What I also think is that there is so much work we'd like to get done, but we can't, at least in the technology space. We don't have enough people to do the work, so GenAI agents or partners working with humans might let us catch up on the backlogs we have.

Of course, I don't know that all that backlogged software we went is something we need, if it's good for the world, and if it will end up putting even more people in the real world out of work.

Lots of challenges ahead. Let me know what you think.

Steve Jones - SSC Editor

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

 
 Featured Contents
Technical Article

Stairway to Azure SQL Hyperscale Level 6: Backup and Restore Internals

Chandan Shukla from SQLServerCentral

Learn how backup and restore work in Azure SQL Hyperscale in this next level in the stairway series.

External Article

15 Practical Tips for Securing SQL Server

Additional Articles from SimpleTalk

Securing SQL Server isn’t complicated, but it does require consistent attention to the areas where real risks arise, such as privileges, configuration, encryption, patching, and monitoring. This article outlines 15 practical, high-impact steps you can take to harden your SQL Server environment.

Blog Post

From the SQL Server Central Blogs - What’s New at AWS re:Invent 2025 – Day2 Highlights

Anup Sivadas from SQLSailor.com

Day 2 kicked off with Matt Garman’s keynote, and he opened with a quote that instantly stood out as my favorite of the day “Is it possible? …..Why not!...

Blog Post

From the SQL Server Central Blogs - Quantum Computing and SQL Server Article Is Up

K. Brian Kelley from Databases – Infrastructure – Security

In parallel with the presentation I gave at the PASS Data Community Summit on quantum computing's impact on data, I wrote an article specifically on impact with respect to...

Murach's SQL Server 2022 for developers

Site Owners from SQLServerCentral

Murach's SQL Server 2022 for Developers is a comprehensive guide to database design and management. This computer book teaches essential SQL statements through clear examples and practical exercises. The book's unique paired-pages format makes learning database software concepts easier, while providing in-depth coverage of database management fundamentals. Ideal for both beginners and seasoned developers seeking to enhance their data management skills.

 

 Question of the Day

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

 

Deprecated Feature Tracking

From T-SQL, without requiring an XEvent session, can I tell which deprecated features are being used on my instance?

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)

A Big PK

In SQL Server 2025, how many columns can be included in a Primary  Key constraint?

Answer: 32

Explanation: You can have 32 columns in a PK constraint. This is the same number as SQL Server 2016, 2017, 2019, 2022 (tested). You can test this with this code:

-- GO statements are causing syntax errors when running in NOEXEC mode
-- Replacing GO batch separators with semicolons to execute as a single batch
DROP TABLE IF EXISTS dbo.PKTest;

CREATE table PKTest
(
    c01 int not null,
    c02 int not null,
    c03 int not null,
    c04 int not null,
    c05 int not null,
    c06 int not null,
    c07 int not null,
    c08 int not null,
    c09 int not null,
    c10 int not null,
    c11 int not null,
    c12 int not null,
    c13 int not null,
    c14 int not null,
    c15 int not null,
    c16 int not null,
    c17 int not null,
    c18 int not null,
    c19 CHAR(100) not NULL,
    c20 char(100) not null,
    c21 char(100) not null,
    c22 char(100) not null,
    c23 char(100) not null,
    c24 char(100) not null,
    c25 char(100) not null,
    c26 char(104) not null,
    c27 int not null,
    c28 int not null,
    c29 int not NULL,
    c30 int not NULL,
    c31 int not NULL,
    c32 int not NULL,
    c33 int not null
);
go
alter table dbo.PKTest
add constraint PKTestPK
    PRIMARY KEY (
     c01, c02, c03, c04,c05, c06, c07, c08, c09, c10,
     c11, c12, c13, c14, c15, c16, c17, c18, c19, c20,
     c21, c22, c23, c24, c25, c26, c27, c28, c29, c30,
     c31, c32
                );
    GO

The docs (as of Dec 1, 2025) still say 16 columns, but I have submitted a PR.   Ref: Primary Keys - https://learn.microsoft.com/en-us/sql/relational-databases/tables/primary-and-foreign-key-constraints?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 2017 - Development
Pivot but preserve all rows on Aggregate column - Hello Need help in pivoting this data set, the Pivot takes MIN/MAX on a column and creates only row, my goal is to preserve all rows. We need to pivot on DSTRCT_CODE which will have only two values {BBBB/CCCC}  on value of column PREF_PART_IND. so for below sample data : with q_data as ( select […]
SQL Server 2019 - Administration
MAX_DISPATCH_LATENCY in extended event , is not clearly explained in msdn. - hi,   i have checked reducing it increasing it but could not get any thing, pls explain what exactly it means. DROP EVENT SESSION [CaptureSlowQueries] ON SERVER go CREATE EVENT SESSION [CaptureSlowQueries] ON SERVER ADD EVENT sqlserver.sp_statement_completed( ACTION(sqlserver.database_id,sqlserver.sql_text) WHERE ([duration]>(15000000))), ADD EVENT sqlserver.sql_statement_completed(SET collect_statement=(1) ACTION(sqlserver.client_app_name,sqlserver.database_id,sqlserver.sql_text) WHERE ([duration]>(15000000) )) ADD TARGET package0.event_file(SET filename=N'SlowQueries',max_file_size=(5),max_rollover_files=(2)) WITH (MAX_MEMORY=4096 KB,EVENT_RETENTION_MODE=ALLOW_SINGLE_EVENT_LOSS,MAX_DISPATCH_LATENCY=30 […]
SQL Server 2019 - Development
is there a no code way to limit an ssis extract from excel to the 1st 21 rows? - is there a no code way to limit an ssis extract from excel to the 1st 21 rows of the sheet?   for now anything past that is just noise in what im doing.
any reason to avoid asking ssis to extract files from ftp - hi we have to replace talend which generally was used to move files. talend's replacement except for a handful of sql sourced etl's is an OO code based "pipeline" architecture.  the sql stuff has been converted to ssis. we have to begin extracting about 6 files daily from an ftp server and throwing them out […]
CAST datetimeoffset(7) as a datetime in UK format - I have a view where I am casting a datetimeoffset(7) field to smalldatetime or datetime as my reporting application won't accept the datetimeoffset(7) format.  Problem is I am trying to get this field to show up in UK format.   I am using CAST to get my results.  I can get the format I need by […]
what are the downsides of TDE not running vs running? - hi for the 2 years i've been here I believe we've had "encryption" turned off in what i only know as the way we tell ssms to communicate with our sql servers ...and i've always thought meant also the server itself relaxing how it communicates back to whatever client is asking for data. recently an […]
Reporting Services
Catalog max connection pool size: 100 - Seeing this message repeated every 10 seconds in the RSHostingService_yyyy_mm_dd_hh_mm_ss.log file. Can anyone advise: a) Why this is being reported so frequently? b) Does it indicate the limit is being hit? c) If b is true, how can I increase it? I've had a look through the configuration files and can't find anything specifying "100" […]
Editorials
Investing for AI - Comments posted to this topic are about the item Investing for AI, which is is not currently available on the site.
Article Discussions by Author
What is the PRODUCT - Comments posted to this topic are about the item What is the PRODUCT
Metadata Driven Pipelines (Incremental Load): The Fabric Modern Data Platform - Comments posted to this topic are about the item Metadata Driven Pipelines (Incremental Load): The Fabric Modern Data Platform
Metadata Driven Pipelines (Incremental Load): The Fabric Modern Data Platform - Comments posted to this topic are about the item Metadata Driven Pipelines (Incremental Load): The Fabric Modern Data Platform
Unlocking Data Transformation: My journey with dbt (Data Build Tool) on SQL Server - Comments posted to this topic are about the item Unlocking Data Transformation: My journey with dbt (Data Build Tool) on SQL Server
SQL Server 2022 - Administration
Help! MEMORY_ALLOCATION_EXT wait stalls - Hi I have an overnight process that moves allot of claims records Been working fine for many years. Now it hits this part of the code (across a linked server) and gets the (1596567ms)MEMORY_ALLOCATION_EXT wait type and will sit there forever and never move any records - no delta movements at all. Used to complete […]
SQL Server 2022 - Development
cant process ssas db on vm - error says source is encrypted and other things - hi i get the error you see below when trying to process my AR cube full.  it is sourced by a sql db on the same server that theoretically is being connected to by my admin acct.  my query on which sql engine db's might be  encrypted comes up false on each.   i made sure […]
This doesn't make sense to me - making me crazy - er - Hi So I have the below select query that won't return results if I have it this way:   --DOES NOT RETURN-- AND EXISTS (SELECT 1 FROM edi.dbo.PEC_RGT_EDI_834_Inbound_Exception xx WHERE (xx.SubscriberNumber = x.subscribernumber OR x.MBI = xx.mbi) AND xx.LastDateProcessed>'05/31/2022') But will return results with this very small change: --DOES RETURN-- REPLACE ABOVE WITH BELOW AND […]
 

 

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

 

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