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

Investing for AI

The GenAI boom is growing like crazy. From hype to disasters to successes to investment to the embedding of GenAI tech into lots of products, it seems no one gets away from AI. My wife, kids, friends, they all talk about AI and alternately give me stories of huge successes or epic failures. Even those who just scroll through reels aren't immune as we see amazing things, but we can't trust them because of AI. Who knows what image/video/audio was actually recorded and what was generated.

Like many of you, I think AI can be amazing. Like more of you, I think it can be a really poor partner and it produces output I can't trust. I think one of the major challenges is learning to treat an AI like a colleague whose work quality is erratic. It's not that I can't work with them and use their work, but I need to test, validate, and verify the code they give me does what I need, at some acceptable quality level.

Microsoft is a company investing a lot in AI, and it's changing the company. Some of us might not like the direction as it seems that AI is being pushed for the sake of AI and to generate profits for Microsoft. Or at least revenue as I'm not sure how much profit there will be with all the compute costs of AI. However, it's certainly affecting every product development team.

I listened to a very interesting interview with Satya Nadella talking AI, globalization, and more, including a data center tour of their new AI site in the ATL. The data center tour with Satya and Scott Guthrie is at the beginning and it's amazing to see. The network connections in this data center are equivalent to all of Azure a few years ago. That's impressive, especially seeing they plan to link these new generation data center with petabit networks. For someone that grew up with 300baud modems and then 2.5Mbps Arcnet, I can't even conceive of these speeds.

As I listened to the interview, I was skeptical of Microsoft's efforts. The hosts were as well, as they pressed Microsoft to really give them a reason why all this AI investment makes sense. The interview is long (1:27:47), but includes some interesting statements.

Satya says that AI might be the biggest think since the industrial revolution. I could see that, and I'm not sure I disagree. AI tech, with the ability to reduce the requirements to interact with a computer for everyone, is incredible. It can dramatically reduce the UX issues we constantly see with developers building things that don't always make sense to users. For me, I love that it can handle my misspellings, something many traditionally coded systems cannot handle.

There's also a great quote that Satya uses from a CMU professor: AI is a guardian angel or a cognitive amplifier. I think it's both, as AI is a tool and it's something you can use well or not. If all you have is a hammer, everything looks like a nail; that's a famous quote. A hammer is a great tool.

Sometimes.

Sometimes it's not the tool, and something else is needed. AI can be a great cognitive amplifier, but if you treat all problems as nails, you will let AI create a lot of problems. However, if you use it for the appropriate task, it can really help you. The AI can also see or spot things that we can miss as humans. As the world gets more complex, we deal with more things at once, or the rate of information coming to us increases, we may (will) miss things. An AI can do a better job of catching things, just like another person might catch things you miss.

The last interesting thing is on models vs scaffolding where we look at what models mean and what scaffolding or infrastructure. The example is with Excel (which Satya wish had a database), but it's an interesting look at how we might get value from AI in getting tasks done, and saving labor with AI technology. It's worth the listen (or read the transcript).

I found myself seeing how this might not only benefit Microsoft, but perhaps will benefit the world as other companies embrace multiple models and facilitate the ability of more people to use AI tech. I still don't know if the ROI and costs make sense, but we will as the AI bubble bursts and this becomes a normal part of our lives in some way.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

Metadata Driven Pipelines (Incremental Load): The Fabric Modern Data Platform

John Miner from SQLServerCentral

This article will use the incremental data load pattern to load data in our raw zone tables.

External Article

Running SQL Server in Local Containers with VSCode MSSQL Extension

Additional Articles from MSSQLTips.com

You are a developer using SQL Server for your applications, and you need to quickly setup a local development environment. How can you make sure the environment is OS agnostic, so it can run on any operating system? Let’s see how we can quickly create a local container to run SQL Server using the VSCode MSSQL Extension.

Blog Post

From the SQL Server Central Blogs - Microsoft Ignite Announcements Nov 2025

James Serra from James Serra's Blog

Announced at Microsoft Ignite two weeks ago were many new product features related to the data platform. Check out the Major announcements and Book of News. I went through the many announcements and picked...

Blog Post

From the SQL Server Central Blogs - Dry-run xp_delete_file Before Actually Deleting Files?

SQLPals from Mission: SQL Homeostasis

Dry-run xp_delete_file Before Actually Deleting Files?

xp_delete_file doesn’t really have a built-in dry-run option to preview which files it would remove. But there’s a simple workaround,...

SQL Server Advanced Troubleshooting and Performance Tuning: Best Practices and Techniques

Site Owners from SQLServerCentral

This practical book provides a comprehensive overview of troubleshooting and performance tuning best practices for Microsoft SQL Server. Database engineers, including database developers and administrators, will learn how to identify performance issues, troubleshoot the system in a holistic fashion, and properly prioritize tuning efforts to attain the best system performance possible.

 

 Question of the Day

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

 

What is the PRODUCT

In SQL Server 2025, what does this return?
CREATE TABLE Numbers
( n INT)
GO
INSERT dbo.Numbers
(
n
)
VALUES
(1), (2), (3)
GO
SELECT PRODUCT(n)
FROM dbo.Numbers

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)

Putting the Player with the Number

In SQL Server 2025, what does this return?

DECLARE @player varchar(20) = 'Bo Nix',
@num VARCHAR = '10'

SELECT @player || @num

Answer: Bo Nix1

Explanation: The string concatenation operator works fine, but the declaration of the @num variable has no scale. The default is a length of 1. Ref:

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 - Administration
Deny Connect problem - I have a login I need to deny connect to on a server, but it is "hidden" inside a Windows Security Group instead of directly added to SQL Server security. I cannot deny connect to the whole group. I need to specifically not allow this specific login to connect to this server. But when I […]
SQL Server 2019 - Administration
Veeam Backup DAG issue. Access to availability group is not permitted. - Hi all,   Has anyone encountered an issue whereby using a distributed availability group to migrate data from cluster 1 to cluster 2 leaves stale GUIDs in the Veeam postgres database causing the backups to fail with the above error?   Anyone have a fix?   Thanks  
SQL Server 2019 - Development
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
Your Security Checkup - Comments posted to this topic are about the item Your Security Checkup, which is is not currently available on the site.
How Important Are Real Time Decisions? - Comments posted to this topic are about the item How Important Are Real Time Decisions?
SQLServerCentral.com Website Issues
Website Stability 2025/12/05 - All week we've had issues with the site being up and down. There's been a tremendous amount of traffic to various pages, many of them old. Lots of redirects, and lots of volumes (hundreds or thousands of requests/sec). It seems like someone scanning archive.org and then hitting us from their various points. We have put […]
403 Forbidden - I created a post (or tried) in the 2022 Admin forum. https://www.sqlservercentral.com/?post_type=topic&p=4694880 But it's now inaccessible. Not sure what I did wrong.
Article Discussions by Author
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
Putting the Player with the Number - Comments posted to this topic are about the item Putting the Player with the Number
Fabric Mirroring - Comments posted to this topic are about the item Fabric Mirroring
T-SQL in SQL Server 2025: The UNISTR Function - Comments posted to this topic are about the item T-SQL in SQL Server 2025: The UNISTR Function
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
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

 

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