Problems displaying this newsletter? View online.
Database Weekly
The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com
Hand-picked content to sharpen your professional edge
Editorial
 

Economics of AI: What is the Real Cost to Profit?

Artificial intelligence is everywhere: It’s in our tools, our workflows, our marketing pitches…and increasingly, in our bottom lines. But a thought-provoking article published recently on the AI bubble asks a far more sobering question: What’s it really going to cost to profit from AI?

Many people will roll their eyes and say, “Isn’t that obvious? Companies are already making millions from AI initiatives.” And yes, there are undeniable success stories around organizations that have harnessed AI to drive innovation, efficiency, and competitive advantage, but if we peel back the layers, it’s clear that the real winners so far are the cloud providers and tech giants selling AI infrastructure, APIs, and compute power.

For many organizations, the pursuit of AI value has been far less strategic and far more experimental. I’m reminded of that old saying: “Just throw things at the wall and see what sticks.” Over the past few years, that’s exactly how many have approached AI. Without a clear understanding of the specific problems AI was meant to solve, companies pressured every department to “do something with AI” and the result? A scattershot collection of initiatives, including chatbots here, predictive dashboards there, all launched not out of strategy, but obligation.

Now, as the hype cools and the bills come due, the question isn’t who’s using AI, but who’s profiting from it. True economic success with AI won’t come from experimentation for its own sake, but will come from thoughtful integration, measurable outcomes, and a clear understanding of where AI creates sustainable value versus where it’s just an expensive science project.

Peace out.

dbakevlar

Join the debate, and respond to the editorial on the forums

 
Ad for State of Database Landscape survey
The Weekly News
All the headlines and interesting SQL Server information that we've collected over the past week, and sometimes even a few repeats if we think they fit.
Vendors/3rd Party Products

Tracking Aborted Queries and Memory Grants in Redgate Monitor

Redgate Monitor now surfaces two common SQL Server query issues that usually take manual work to uncover: cancelled or aborted queries and high memory-grant queries. You can see both in the Query Executions view for each SQL Server instance, directly alongside server activity and alerts, so you can diagnose the cause much faster.

Finish the year strong: make SQL Server development faster, more reliable, and more consistent

When SQL Server development is slowed down by manual tasks, inconsistent processes, and deployment errors, even the best teams can struggle to keep up. That’s why many teams are turning to SQL Toolbelt Essentials: a powerful, easy-to-adopt toolkit that helps teams to speed up database development, reduce risk, and standardize workflows. With a fast set up time, your team can start seeing results immediately and finish the year strong.

AI/Machine Learning/Cognitive Services

Building dbRosetta Using AI: Part 1 of Many

Like many of you, over the last couple of years, I’ve been using AI, or, well, let’s just name it appropriately, Large Language Models (LLM), as a part of my job. I’ve also used it in my hobby. With it, I’ve generated snippets of code, tested data conversions, even built a small database for a presentation. However, to date, I haven’t tried doing everything through the LLM. Now, I’m going to.

Local AI Models for SQL Server – A Complete Guide

From Journey to SQL Authority with Pinal Dave

Let us learn about Local AI Models for SQL Server ...

Creating Your Own ggplot2 Geom

From Curated SQL

Isabella Velasquez is feeling creative: If you use...

Balancing Cost, Power, and AI Performance

From O'Reilly Radar - Insight

The next time you use a tool like ChatGPT or Perpl...

AI, bandwagons and other things I don’t jump on (S:01 E:01)

From Dr SQL

This week I give you episode 1 from my Tilting WIth Tuples Podcast where I talk about the AI bandwagon and how I really do like it, I am...

Administration of SQL Server

Unlocking the Power of FULL OUTER JOIN in SQL: Performance, Use Cases & Examples

The JOIN statement is one of the most common operations SQL developers perform. Yet in a world ruled by Inner and Left Joins, the poor Full Outer Join is like Cinderella before the ball – allowed out on only the rarest of occasions. In an (unscientific) survey I once performed of SQL developers at one Fortune 100 firm, half of the developers had never used a Full Outer Join in production code, and the rest had used it in a tiny handful of occasions.

Hyper-V and SQL Server Best Practices: What We Wish You Knew

From StraightPath Solutions SQL Blog

If you’ve ever asked yourself, “Why does my SQ...

Finish the year strong: make SQL Server development faster, more reliable, and more consistent

From Blog – Redgate Software

As the final quarter ramps up, development teams a...

[Video] Office Hours at Sea

From Brent Ozar Unlimited

This Office Hours episode comes to you from Virgin...

Accelerated Database Recovery for tempdb in SQL Server 2025

From DBA From The Cold

Accelerated database recovery was introduced in SQ...

An Error with Log Shipping in an Contained Availability Group

From Curated SQL

Rich Benner diagnoses an issue: We’ve recently c...

Scooby Dooing Episode 10: The Case of the Copy-and-Paste Consultant

From SQLServerCentral Blogs

Every Scooby-Doo episode has one thing in common �...

Working with JSON Indexes in SQL Server 2025

From Curated SQL

Koen Verbeeck tries out a new index type: We’re trying the new JSON data type in SQL Server for data stored as JSON in a…

Always On Availability Group

From DallasDBAs.com

  Always On Availability Group Official Definition An Availability Group (AG) provides HA/DR by hosting a set of databases that fail over together between replicas. Simplified Explanation Availability Groups...

Query Intelligence in SQL Server 2025: What Developers Need to Know

From SQLServerCentral Blogs

When Microsoft announced SQL Server 2025, I was curious about what would truly change the way developers and DBA’s interact with data. Over the years, we have seen incremental... The...

Ad for State of Database Landscape survey
Azure Databricks, Spark and Snowflake

When repartition() Beats coalesce() in Spark

From Curated SQL

Janani Annur Thiruvengadam stands some common advi...

DMO/SMO/Powershell

Understanding the trap Statement in PowerShell

From Sid 500 PoSh

In PowerShell, error handling is a crucial aspect ...

Database Design, Theory and Development

The fundamental requirements of a reporting system

From SQLServerCentral Blogs

There are some fundamental boxes that your reporti...

Good, Clean, Fair: It’s Time for a Slow Data Movement

From StraightPath Solutions SQL Blog

When you sit down at Rick Bayless’ Topolobampo r...

DevOps and Continuous Delivery (CI/CD)

CI/CD Pipelines with DACPACS Allowing Potential Data Loss

From Curated SQL

Jess Pomfret describes a use case: I recently made...

ETL/SSIS/Azure Data Factory/Biml

Calling Logic Apps from Data Factory Pipelines

From Andy Broadsword

Last week we looked at calling a Data Factory Pip...

MDX/DAX

Find the products in the top 10 every year with DAX

From Sqlbi

This article outlines the process of creating a me...

Regression Testing: DAX User Defined Functions

From SQLServerCentral Blogs

User Defined Functions is a new feature in PowerBI...

Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science)

Microsoft Fabric October 2025 Feature Summary

From Curated SQL

Adam Saxton has a list: This month’s update deli...

Azure Tenants and Microsoft Fabric

From Curated SQL

Andy Cutler begins a new series on Microsoft Fabric architecture: Our Fabric Architecture journey starts with Azure Tenants (the kick-off blog in this series is here with a few…

Oracle/MySQL/other RDBMS

MySQL Index Overviews: PRIMARY KEY Indexes

While most of you may be aware of the power that B-tree indexes help you unleash, you may not be aware of specific types of indexes that exist but often remain behind the spotlight – these are PRIMARY KEY indexes.

Performance Tuning SQL Server

A Little About Table Variable Deferred Compilation Depth In SQL Server

From Erik Darling Data

A Little About Table Variable Deferred Compilation...

SQL Server Diagnostic Information Queries for November 2025

From Glenn Berry

Introduction These are my SQL Server Diagnostic In...

A Little About Optimizer Nudging In SQL Server

From Erik Darling Data

A Little About Optimizer Nudging In SQL Server Goi...

PostgreSQL

Nikolay Samokhvalov: #PostgresMarathon 2-010: Prepared statements and partitioned table lock explosion, part 2

From Planet Postgres

In #PostgresMarathon 2-009, we focused on Lock Man...

Nikolay Samokhvalov: #PostgresMarathon 2-011: Prepared statements and partitioned tables — the paradox, part 3

From Planet Postgres

In #PostgresMarathon 2-009 and #PostgresMarathon 2...

Dealing with Dirty Pages in PostgreSQL

From Curated SQL

Umair Shahid explains what dirty pages are in Post...

Tomas Vondra: Don't give Postgres too much memory

From Planet Postgres

From time to time I get to investigate issues with...

Radim Marek: Beyond Start and End: PostgreSQL Range Types

From Planet Postgres

Beyond Start and End columns with PostgreSQL range...

Deepak Mahto: PostgreSQL Partition Pruning: The Role of Function Volatility

From Planet Postgres

In one of our earlier blogs, we explored how impro...

PowerPivot/PowerQuery/PowerBI

Monitoring The DAX Queries Generated When The Power BI Copilot Index Is Built

From Chris Webb's BI Blog

In my last post I talked about the text index that...

Check Power BI report interactions with Semantic Link Labs

From SQLServerCentral Blogs

It can be tedious to check what visual interaction...

R Language

Little useless-useful R functions – Useless Pyramid of R needs

From TomazTsql

What motivates human behaviour can be captured in ...

T-SQL and Query Languages

Temporary Stored Procedures: Outputting Status in Scripts

From Dr SQL

On another connection (on another computer for tha...

Simple Data Quality Validation with T-SQL

From Curated SQL

Kenneth Omorodion builds a validation process: As ...

Replicating PBKDF2 Hashing with T-SQL

From Curated SQL

Vlad Drumea does a bit of digging: Back in June I ...

Consider What You Count

From Curated SQL

Hans-Jürgen Schönig ran out of fingers: The purp...

A Lot About Multi-Statement Table Valued Function In SQL Server

From Erik Darling Data

A Lot About Multi-Statement Table Valued Function In SQL Server Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love my training....

 
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. Note: This is not the SQLServerCentral.com daily newsletter list, and unsubscribing to this newsletter will not stop you receiving the SQL Server Central daily newsletters. If you want to be removed from that list, you can follow the instructions on the daily newsletter.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

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