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

A Challenge of Our Knowledge

AI is here to stay. It will evolve, it will get better at some things, and we might decide that it's not good for certain tasks. It's a weird, new, different technology that somehow seems magic, extremely intelligent, and at times as dumb as a box of rocks. It can do things that I could never do, or would never do, for myself. Heck, I'm not sure I could or would pay someone to do this by hand. Yet this was less than a minute for a computer system to take this image and transform it into something fun.

Christian Buckley wrote an interesting post about AI challenging our identity, which sums up nicely one of the struggles many of us have with AI. Many of us identify with our work. We spend most of our lives for decades toiling away at a craft that we (hopefully) enjoy and in which we have success. We build skills, and we're proud of our accomplishments.

Some of us are more proud of our scars.

Either is OK, but AI challenges that. AI can do work in seconds that we used to take minutes, often tens of minutes. Sometimes hours. It can remember things that we spend time googling or looking up in SQL Server Central forums. Our ability to search and navigate docs for an obscure setting, like that strange exit code you found in your CI/CD pipeline. We're proud of where we've been and what we've done.

I wrote recently about experts wanting to still solve problems themselves, without AI assistance. Some people don't embrace AI because they think it devalues their knowledge. Others are afraid of the technology and potentially making mistakes with code an AI wrote that they don't understand. They see this as a risk (and they should).

However, choosing not to use the technology at all, or not trying to learn how and when to use it, is a mistake. We need to embrace the tools in our world, learning to take advantage of them.

And more importantly, show our current and future employers we can do so.

AI does challenge us. It challenges the way we used to work and some of the skills we used to rely on. We have to learn to flow with this challenge and make it a part of our future career.

Steve Jones - SSC Editor

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

 
 
 Featured Contents
SQLServerCentral Article

The memory toll of VARCHAR(MAX) in SQL Server

sabyda from SQLServerCentral

Introduction When designing the tables or writing the stored procedures in SQL Server, we get easily tempted to choose the path of least resistance. When deciding how much space to allocate for a text column in a database table which may contain the description of a product, a product name, or an additional comment/remarks, it […]

Technical Article

How a SQL Server backup can execute attacker code during restore

Additional Articles from SQLServerCentral

CVE-2026-47295 is a SQL Server vulnerability that lets a maliciously crafted database backup execute attacker-controlled code with sysadmin privileges during a routine RESTORE DATABASE operation.

Blog Post

From the SQL Server Central Blogs - Take Time to Gain Perspective

K. Brian Kelley from Databases – Infrastructure – Security

Probably the best piece of advice I ever received is to take time to gain perspective.

Blog Post

From the SQL Server Central Blogs - Demo for Parameter Sniffing and Memory Grant Feedback

MarlonRibunal from Marlon Ribunal - SQL, Code, Coffee, etc.

Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo subscription cost. This was meant for a private demo so I can learn more about...

Fundamentals of Data Engineering: Plan and Build Robust Data Systems

Site Owners from SQLServerCentral

Data engineering has grown rapidly in the past decade, leaving many software engineers, data scientists, and analysts looking for a comprehensive view of this practice. With this practical book, you'll learn how to plan and build systems to serve the needs of your organization and customers by evaluating the best technologies available through the framework of the data engineering lifecycle.

 

 Question of the Day

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

 

Transaction Log Truncation

In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?

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)

BIT_COUNT() V

What does this return on SQL Server 2025?

select bit_count(null)

Answer: An error

Explanation: An error is returned here. BIT_COUNT() requires an integer or binary expression passed in, but does not perform any conversions. It returns NULL for NULL values of a supported type, but does not convert. You must do something like this:

SELECT BIT_COUNT(CAST (NULL AS INT)); -- Returns NULL

Ref: BIT_COUNT() - https://learn.microsoft.com/en-us/sql/t-sql/functions/bit-count-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 2016 - Administration
Two queries work until compared with EXCEPT statement - I've got multiple databases on 2 SQL 2019 CU32 servers , all using the same schema and code base. The only difference in patch levels is Test has the July Security Update and Prod has the March one. There's a Table Valued function that fails on one database only and only on prod. Of the […]
SQL Server 2016 - Development and T-SQL
Execute as failure - Security has long been a problem for me. Every time I think I understand something, along comes another issue to show me that I don't. I want to have an application on start-up query some information from a sort of status table, to see what it is allowed to do. I have a schema called […]
SQL Server 2019 - Administration
In-place OS upgrade or migration to new OS? - Putting this here as we're currently on SQL Server 2019 installed on Windows Server 2019, all hosted as VMs in Azure.  We've recently been handed down a directive to upgrade to Windows Server 2025 by the end of Sept (which, needless to say, is NOT going to happen by that time.) My preference would be […]
Editorials
An Eventual Consistency Scam - Comments posted to this topic are about the item An Eventual Consistency Scam
Never is Not the Policy - Comments posted to this topic are about the item Never is Not the Policy
Learn From History - Comments posted to this topic are about the item Learn From History
Article Discussions by Author
BIT_COUNT() V - Comments posted to this topic are about the item BIT_COUNT() V
How We Reduced SQL Server Infrastructure Costs by 33% on AWS: Lessons From a Database Operations Manager - Comments posted to this topic are about the item How We Reduced SQL Server Infrastructure Costs by 33% on AWS: Lessons From a Database Operations Manager
Automating SSAS Multidimensional Security Audits with PowerShell - Comments posted to this topic are about the item Automating SSAS Multidimensional Security Audits with PowerShell
Rebuilding All Indexes - Comments posted to this topic are about the item Rebuilding All Indexes
Automating OSM Data Refresh in Power BI’s Azure Maps Reference Layer - Comments posted to this topic are about the item Automating OSM Data Refresh in Power BI’s Azure Maps Reference Layer
Database Mail Configuration - Comments posted to this topic are about the item Database Mail Configuration
The SQL Server MCP Server - Comments posted to this topic are about the item The SQL Server MCP Server
SQL Server 2022 - Administration
Fulltext filter daemon host (FDHost) process has stopped abnormally - We have performed a side-by-side upgrade, from SQL Server 2016 to 2022 Developer Edition, for our instance hosting our Azure DevOps catalogs. Having backed up and restored all of our Azure DevOps (formerly TFS) catalogs/databases to the new database server, we have been experiencing the following severity 17 alert several times per day: "The fulltext […]
SQL Server 2022 - Development
STRING_AGG DISTINCT - Has anyone written a wrapper function (or similar) around STRING_AGG() to allow the retrieval of distinct values only? If yes, I'd be interested to see it, thanks.
 

 

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

 

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