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

Deep Learning and Craftsmanship Matter

There's concern about the future of AI and how it may affect jobs and employment for the masses. I see plenty of people on both sides of the issue. Some are sure AI technologies won't replace people; some are concerned their jobs will be eliminated, and some are hoping that we will eliminate some jobs and create many more.

Sometimes that's the same person.

A GenAI can replicate a human, or maybe more accurately, mimic one. That might work well enough for some people to trust the technology more than humans. Or maybe it works well enough, enough of the time, and lots of us are OK with well-enough. After all, I think a lot of us already work with "well-enough" or "good-enough" code on a daily basis.

However, the GenAI is based on what other humans have already done. It's "trained" on lots of existing ideas, decisions, codebases, etc. It can recall and use those quicker, and often as well as many humans. It might be a light craftsman, but it can't be a great one.

Humans will be able to deeply understand problems and create better craftsmanship for many systems. Across time, an AI can learn from these craftsman and repeat their work in other systems, but an AI will often struggle to understand the entire context of whether we would apply that solution or a slightly different one this time.

That's the human advantage. Deep learning and craftsmanship will differentiate us from the AIs because we can contextualize things better than an AI. Or really, we can internalize the context better than another human can express it to the AI. That will be the difficult part of working with AI LLMs, agents, and whatever comes next: explaining what is really needed in a new situation.

Communication is hard. Because many humans aren't good at communicating, they won't be able to use an AI to replace other humans. They'll struggle with the results, and they will need to hire a craftsman to help. However, that also implies that more of us need to become craftsmen, not only for the advantage it gives us over AI, but because those skills will help us better judge AI output, as well as express what we want to see the AI do.

There will be lots of work in the future, even with AI, but I also believe that the jobs that are desired, that will pay better, will go to those who learn to use AI tech and who can judge when the quality of the work is appropriate for the situation.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

Building a Real-Time Analytics Pipeline with Azure Stream Analytics and SQL Server

AR from SQLServerCentral

Learn how a real time analytics solution for ETL and reporting can be built with SQL Server, Power BI, and Stream Analytics.

External Article

How to Create a SQL Server Linked Server to Oracle 26ai Free

Additional Articles from SimpleTalk

Easily move data from SQL Server to Oracle 26ai Free with this step-by-step guide.

Blog Post

From the SQL Server Central Blogs - Learn Better: Pause to Review More

K. Brian Kelley from Databases – Infrastructure – Security

If you want to learn better, pause more in your learning to intentionally review.

Blog Post

From the SQL Server Central Blogs - Azure SQL Managed Instance Next-Gen: Bring on the IOPS

John Morehouse from John Morehouse | Sqlrus.com

If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to boost memory or I/O, you had to scale the whole instance, paying for extra CPU...

The Phoenix Project

The Phoenix Project: A Graphic Novel about IT, DevOps, and Helping Your Business Win

Site Owners from SQLServerCentral

Adapted from the acclaimed bestselling book, The Phoenix Project Graphic Novel Volume 1 introduces readers to a stalwart cast of characters as they are challenged by the four types of work that impact complex workflows.

 

 Question of the Day

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

 

Encoding Strings

I have this code in SQL Server 2025. What is the result?
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!';
DECLARE @encoded VARCHAR(MAX);

SET @encoded = BASE64_ENCODE(@message);
SELECT @encoded AS EncodedResult;

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)

What is Page Density

In SQL Server, there is a concept of page density. This is determined by how much data is stored on each page. What is a page density of 90%?

Answer: This is when there is 10% free space and 90% used space on a page

Explanation: Page density refers to the amount of data on a page, compressed or not. The number refers to how much data is used on a page, in this case, 90% of the page is data and 10% free. 100% means a full page. Ref: Concepts: index fragmentation and page density - https://learn.microsoft.com/en-us/sql/relational-databases/indexes/reorganize-and-rebuild-indexes?view=sql-server-ver17#concepts-index-fragmentation-and-page-density

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.


Analysis Services
Connecting Power BI to SSAS and effective user not working - Hi everyone, Below is a consolidated summary of what we validated Architecture & data path The on-premises data resides in SQL Server, accessed by Power BI Service via on-premises Analysis Services (SSAS Tabular). Effective flow: Power BI Service ? Power BI Gateway ? SSAS Tabular ? SQL Server The issue is not SQL connectivity, but authentication and […]
Relational Theory
Two foreign keys to the same table. Can't cascade deletes. - Not sure if this is really a relational theory question but it seems about the best sub forum for it.  Apologies if it's the wrong one. I have a Person table.  I also have a Relationships table.  The Relationship acts as a linking entity between two Persons.  E.g. John is the father of Ted. I've […]
Anything that is NOT about SQL!
Fantasy Football 2026 - The thread for the league in 2026. Players from last year have priority.
Editorials
JSON Has a Cost - Comments posted to this topic are about the item JSON Has a Cost, which is is not currently available on the site.
An SSIS Upgrade - Comments posted to this topic are about the item An SSIS Upgrade
Where Your Value Separates You from Others - Comments posted to this topic are about the item Where Your Value Separates You from Others
The Future of Community
Azure SQL DBA certification - Hello team Can anyone share popular azure SQL DBA certification exam code? and your recommendation in this regard?
Article Discussions by Author
Which Result II - Comments posted to this topic are about the item Which Result II
Faster Data Engineering with Python Notebooks: The Fabric Modern Data Platform - Comments posted to this topic are about the item Faster Data Engineering with Python Notebooks: The Fabric Modern Data Platform
Semantic Search in SQL Server 2025 - Comments posted to this topic are about the item Semantic Search in SQL Server 2025
Encoding URLs - Comments posted to this topic are about the item Encoding URLs
Fixing the Error - Comments posted to this topic are about the item Fixing the Error
T-SQL in SQL Server 2025: Encoding Functions - Comments posted to this topic are about the item T-SQL in SQL Server 2025: Encoding Functions
SQL Server 2022 - Administration
High Availability setup - has anyone seen this method? - Hi all, I recently moved to a new employer who have their HA setup in a way I've never seen and I'd just like to get opinions on it; I'm not saying it's right or wrong, just different (but it does appear to have caused issues). The way that I'm used to is that two […]
Certificates expired - Can't restore after creating new certificate - The previous DBA created a certificate which expired 12/31/2025. I came in hoping to have an easy day for New Year's Eve and found all of the backups were failing.  After doing the research, I found the certificate had expired. 1.  I created a new certificate since I couldn't update the expiry date. 2.  I […]
 

 

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

 

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