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

Your AI Successes

Recently, I was discussing AI with a friend, and they asked me to name a great success of using AI to build software. I've tried a few things, and I've worked with customers who are using AI tech. However, most of the things I've seen built with AI are small tasks; they're utilities or quick wins that change a minor part of the software. The items tend to be tactical and focused in a narrow band of fixes, and they might save a programmer time, but I'm not seeing large-scale team improvements in productivity.

Yet.

I think there is a chance for AI to dramatically change our industry, and perhaps help us tackle a lot of small things we haven't wanted to, or been able to, find the time to build/fix/change/etc. Certainly, in the area of migrating from one version of a platform or framework to another, GenAI can be very useful. This can be a very tedious task, and one where humans can make lots of small mistakes. An AI agent likely can do this quicker, cheaper, and more accurately than humans. The question might be whether this is a huge success, as any single organization might do this rarely.

The biggest success in many organizations might be the ability of developers, or even business people, who can quickly build out an MVP of an idea to see if there is a project worth pursuing. These often won't have the robust coding or security practices embedded, but they can perhaps shortcut putting more research into an idea until some value is proven. At least internally, if it doesn't have good scalability or security, it shouldn't be exposed publicly until it adds those capabilities.

When or where has an AI worked best for you? What impressed you about the AI technology interaction that changed how you might work in the future? Or perhaps if you've had a big failure and want to share, where did AI not work well?

I think most of my experience is that AI is still a bit of a toy and useful in small ways, but it hasn't proven to me that it's worth the hype we see in so much of the media. Maybe it will at some point, but so far this seems more of a dream than a reality for software professionals.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

Using Python notebooks to save money in Fabric: The Fabric Modern Data Platform

John Miner from SQLServerCentral

In this next article, we look at how notebooks using Python can be cheaper than Spark notebooks.

External Article

Let’s Build a Better KILL. What Do We Need to Consider?

Additional Articles from Brent Ozar Blog

When there’s a performance emergency, a lot of us perform the same manual tasks over and over. We run sp_BlitzWho or sp_WhoIsActive, look for blocking, long-running or out-of-control queries, and kill them.

Blog Post

From the SQL Server Central Blogs - Start with the FabricTools PowerShell module

KamilN78 from Azure Player Blog

Managing Microsoft Fabric at scale quickly becomes painful if you rely only on the UI. Workspaces, capacities, and tenant-level settings all need repeatable, scriptable management. FabricTools is a community-driven PowerShell module...

Blog Post

From the SQL Server Central Blogs - Stop Being Surprised by Your Azure Bill: Use Budgets

John Morehouse from John Morehouse | Sqlrus.com

When organizations migrate workloads to Azure, the focus is usually on architecture, performance, and security. Cost management should be part of that conversation—but in practice, it’s often treated as...

Learn Microsoft Fabric: A practical guide to performing data analytics in the era of artificial intelligence

Site Owners from SQLServerCentral

A step-by-step guide to harness the power of Microsoft Fabric in developing data analytics solutions for various use cases

 

 Question of the Day

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

 

Which Table I

I have this code in SQL Server 2022:
CREATE SCHEMA etl;
GO
CREATE TABLE etl.product
(
    ProductID INT,
    ProductName VARCHAR(100)
);
GO
INSERT etl.product
VALUES
(2, 'Bee AI Wearable');
GO
CREATE TABLE dbo.product
(
    ProductID INT,
    ProductName VARCHAR(100)
);
GO
INSERT dbo.product
VALUES
(1, 'Spiral College-ruled Notebook');
GO
CREATE OR ALTER PROCEDURE etl.GettheProduct
AS
BEGIN
    SELECT  ProductName
    FROM product;
END;
GO
When I execute this code as a user whose default schema is dbo and has rights to the tables and proc, what is returned?

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)

Encoding NULL

What is returned from this code in SQL Server 2025?

SELECT BASE64_ENCODE(NULL)

Answer: NULL

Explanation: This returns NULL, by design. Ref:  BASE64_ENCODE - https://learn.microsoft.com/en-us/sql/t-sql/functions/base64-encode-transact-sql?view=fabric-sqldb&viewFallbackFrom=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
Database file shrink issue. - Hi experts, I have a 3+ TB database on a 2019 sql server which has more than 50% free space. I know database or data file shrink is not a good practice so please not go there, I tried with 100 mb in a loop which is taking much longer time so it's not feasible. […]
SQL Server 2019 - Agent job PowerShell step issue - I have a couple of SQL Agent job steps which run PowerShell commands of the form: Invoke-Command -ComputerName REMOTE -ScriptBlock {& "E:\Scripts\PowerShellScript.ps1" -ServerName "REMOTE\INSTANCE"} In each case, these steps have started failing with errors of the form: The job script encountered the following errors. These errors did not stop the script: Unhandled Exception: System.FormatException: Index […]
Analysis Services
Database backup job steps - I have a SQL Agent job for backing up a set of Analysis Services databases with each database covered by a different "SQL Server Analysis Services Command" job step of the form: { "backup": { "database": "CUBE NAME", "file": "CUBE NAME.abf", "allowOverwrite": false, "applyCompression": true } } However, if a database is added, deleted or […]
Editorials
The North Star for the Year - Comments posted to this topic are about the item The North Star for the Year
Finding Motivation - Comments posted to this topic are about the item Finding Motivation
The Side Job - Comments posted to this topic are about the item The Side Job
Happy Holidays, Let's Do Nerdy Stuff - Comments posted to this topic are about the item Happy Holidays, Let's Do Nerdy Stuff
Article Discussions by Author
Multiple Escape Characters - Comments posted to this topic are about the item Multiple Escape Characters
The Last Binary Value of the Year - Comments posted to this topic are about the item The Last Binary Value of the Year
SQL Art, Part 2: New Year Fireworks in SSMS - Comments posted to this topic are about the item SQL Art, Part 2: New Year Fireworks in SSMS, which is is not currently available on the site.
Database security permissions save script - Comments posted to this topic are about the item Database security permissions save script
SQL Server 2025 Backup Compression Algorithm - Comments posted to this topic are about the item SQL Server 2025 Backup Compression Algorithm
The Large Encoded Value - Comments posted to this topic are about the item The Large Encoded Value
UNISTR Escape - Comments posted to this topic are about the item UNISTR Escape
SQL Server 2022 - Development
reaching ftp thru winscp but erroring in ssis ftp task connection - Hi, below i show various results trying to reach our ftp site (a globalscape product) from both winscp and ssis's ftp task as a certain user on a certain port.   as far as i know, in winscp i choose FTP as the protocol even though its more appropriately FTPS (not sftp).  in ssis i tried […]
 

 

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

 

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