| | The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | | Hand-picked content to sharpen your professional edge |
| 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 |
| 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 |
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. |
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 |
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. |
Let us learn about Local AI Models for SQL Server ... |
Isabella Velasquez is feeling creative: If you use... |
The next time you use a tool like ChatGPT or Perpl... |
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 |
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. |
If you’ve ever asked yourself, “Why does my SQ... |
As the final quarter ramps up, development teams a... |
This Office Hours episode comes to you from Virgin... |
Accelerated database recovery was introduced in SQ... |
Rich Benner diagnoses an issue: We’ve recently c... |
Every Scooby-Doo episode has one thing in common �... |
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 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... |
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... |
| Azure Databricks, Spark and Snowflake |
Janani Annur Thiruvengadam stands some common advi... |
In PowerShell, error handling is a crucial aspect ... |
| Database Design, Theory and Development |
There are some fundamental boxes that your reporti... |
When you sit down at Rick Bayless’ Topolobampo r... |
| DevOps and Continuous Delivery (CI/CD) |
Jess Pomfret describes a use case: I recently made... |
| ETL/SSIS/Azure Data Factory/Biml |
Last week we looked at calling a Data Factory Pip... |
This article outlines the process of creating a me... |
User Defined Functions is a new feature in PowerBI... |
| Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) |
Adam Saxton has a list: This month’s update deli... |
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… |
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... |
Introduction These are my SQL Server Diagnostic In... |
A Little About Optimizer Nudging In SQL Server Goi... |
In #PostgresMarathon 2-009, we focused on Lock Man... |
In #PostgresMarathon 2-009 and #PostgresMarathon 2... |
Umair Shahid explains what dirty pages are in Post... |
From time to time I get to investigate issues with... |
Beyond Start and End columns with PostgreSQL range... |
In one of our earlier blogs, we explored how impro... |
| PowerPivot/PowerQuery/PowerBI |
In my last post I talked about the text index that... |
It can be tedious to check what visual interaction... |
What motivates human behaviour can be captured in ... |
| T-SQL and Query Languages |
On another connection (on another computer for tha... |
Kenneth Omorodion builds a validation process: As ... |
Vlad Drumea does a bit of digging: Back in June I ... |
Hans-Jürgen Schönig ran out of fingers: The purp... |
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.... |
  | 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. |
|
|