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
 

The New World Of AI Robots

It's been a good time for robots. While on vacation last week I caught this video of a robot running. It's impressive for a bit, and then it devolves into the inspiration for lots humorous comments as it crashes into a wall. There are some funny comments, but some pedantic ones that note the robot can't beat a human record because it's not a human.

That's correct, but ...

The comments miss the point. The robot will improve it's capabilities, and much faster than a human can. The AI/ML advances of the last few years mean that we don't have to program robots to be precise and exact. The fact that a robot can balance and run and stay inside the lanes is incredible. I suspect these robots, both humanoid and other form factors will start to become more commonplace in our world.

Which is scary.

Not for us tech people, though certainly AI advances are worrisome. More, I worry about other jobs. Think about the industrial robots of the last 30 years that have been used in places like car manufacturing. They are bespoke, designed to do certain jobs, and in a certain way. They are programmed with fairly tight tolerances to perform a specific task, often at a quicker and more reliable (and repeatable) way than a human can. There were plenty of false starts here, but today many robots are used alongside humans to assemble cars. You can see them working here, doing tasks that would be slower and harder for humans, even with mechanical aids.

There is talk of humanoid robots being used in place of some humans, reducing the slow and complex setup . This also lets the robots work in the same places and spaces, moving the same way, as humans do. This might reduce some of the labor costs in the future. That might not seem like a big change overall, as lots of manufacturing uses automation in some way today, but think past this.

You can purchase a humanoid robot for under $5000. That might not be very capable now, but as LLMs get more capable and perhaps specialized models for different purposes like image recognition, this is an issue. Imagine you own an oil change business. You pay 5 people to do most of the work on cars. Those people likely cost you $2000-2500 a month each. That's the cost of 2 robots, without the hassles of hiring, termination, breaks, etc. An AI LLM can already identify items from a camera image. Is it a far stretch to think that a robot could identify the oil drain plug and the oil filter on a car by moving around it? How hard would it be for a robot to grab a human ratchet, pick the right socket after a database lookup, and remove the plug. They could tell when the oil finished draining and then replace the plug, tightening it to the correct torque. And being a robot, they might do this without forgetting to position the drain or replace the plug.

In my mind, a $5k robot quickly becomes capable of a lot of human jobs. There might still be the need for some humans, but we might easily replace 50%+ of them in a lot of common jobs. Stocking shelves, acting as cashiers, who knows what else these AI driven systems might accomplish. That's truly a scary world, where human labor in many cases might be devalued.

In the software world, it seems the people having the most success have the best judgment. People who are above average software engineers get above average results from LLMs, and I suspect this will be the case for a long time. Very average, or worse, engineers get worse results and I think are the source of many of the stories of AI coding failures.

I don't know what a lot of manual labor jobs will do when management starts to experiment with robots, but I know that in our world you can compete and succeed against AI coding agents by learning to work with them, apply your judgment and use them as tools that make you more effective.

 

Steve Jones - SSC Editor

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

Shared-Database Blue-Green Deployments in Practice

Preserving backward compatibility during a shared-database Blue-Green deployment comes down to how well you implement Expand-Contract. This article compares the pros and cons of four practical techniques so you can pick the best fit. In each case, Flyway Enterprise is the control layer for the Expand-Contract cycle, managing migrations, testing, verification, and cleanup.

AI/Machine Learning/Cognitive Services

The new division of labor between people and AI agents

From AllAnalytics

Much of the conversation around agentic AI focuses on autonomy. How much work can an agent complete on its own? How many decisions can it make? How far can...

Building a Human-in-the-Loop Validation Workflow for AI Systems in Python

From DataScience+

AI systems often fail in production not because th...

The First 90 Days of an AI Readiness Program

From Sherpa of Data

By now, we’ve talked about why so many AI initiatives struggle. The good news? You don’t have to solve all of those problems before you begin preparing for AI....

Alibaba’s Qwen Passes 3 Billion Downloads, Ahead of Meta and Google

From Past News - RSS Feeds

Alibaba says Qwen has passed 3 billion downloads, moving ahead of Meta and Google as its global open-model developer ecosystem continues to expand.

Administration of SQL Server

JSON indexing in SQL Server 2025: how it works and current limitations

This guide has everything you need to know about JSON indexing in SQL Server 2025: what it is, how it works, and current limitations.

How to avoid nested REPLACE functions with TRANSLATE in SQL Server

This guide covers how TRANSLATE() works, how it compares to REPLACE(), and where it falls short compared to other SQL dialects like PostgreSQL and Oracle.

JSON indexing in SQL Server 2025: how it works and current limitations

From Simple Talk

SQL Server 2025 introduces native JSON indexing via CREATE JSON INDEX. Learn how it works, when to use it, and its current preview-stage limitations.… The post JSON indexing in SQL...

SQL Server gMSA: Why So Many DBAs Still Aren't Using It in 2026

From SQLServerCentral Blogs

SQL Server gMSA: Why DBAs Still Aren't Using It in 2026 Group Managed Service Accounts (gMSAs) solve the classic service-account password problem - just look at... The post SQL Server gMSA:...

CU8 Is Here. Your Monitoring Query Is the New Casualty.

From SQLFingers

Cumulative Update 8 for SQL Server 2025 landed on August 13th, build 17.0.4075.5. Eleven fixes. Three known issues. One of those known issues arrived with the July updates, and...

 
Career, Employment, and Certifications

Eleven SQL Server Interview Questions That Look Far Too Easy

From Journey to SQL Authority with Pinal Dave

These eleven SQL Server interview questions look far too easy, and every one of them has stopped somebody senior. First appeared on Eleven SQL Server Interview Questions That Look Far...

From DBA or Data Engineer to AI Engineer: A Realistic Path

From SQLServerCentral Blogs

If you spend your days tuning queries, managing pipelines, or keeping a production database alive, you already carry most of what an AI engineering role needs. What is missing... The...

Databricks, Spark, and Snowflake

Data Federation

From Mainri

Data Federation lets Databricks/Unity Catalog access and query data that remains in its original system, without first copying all of that data into Delta tables in Databricks. Suppose I...

Databricks Genie

From Mainri

Databricks Genie is Databricks’ natural-language analytics interface. It allows business users to ask questions about governed enterprise data in plain English, instead of writing SQL. Think of Genie as:...

HA/DR/Always On/Clustering

How Outages Impact CDC And Replication

As anyone in IT will tell you, when an outage strikes, and all hands are on deck, that is something that will wake you up faster than any cup of coffee. That was me.

Asynchronous Replication of Snapshots from an ActiveCluster Pod to a Third Array

From SQLServerCentral Blogs

I’ve been rebuilding my three-site SQL Server demo lab, and I ran into something I’ve wanted for a long time. If you’ve ever designed a SQL Server environment on... The...

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

When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?

From SQLServerCentral Blogs

Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform. Power BI, data engineering, warehousing, data science, real-time analytics, Copilot, and other experiences can all... The...

Reusable AI Skills for Writing to Microsoft Fabric Lakehouse Tables from Python Notebooks and to reduce Capacity Units consumption

From FourMoo

In this blog post below, I explain what the two skills do, why I use them in Fabric Python notebooks, how they can reduce unnecessary capacity consumption, and how...

Oracle/MySQL/other RDBMS

How to implement Deep Data Security (DeepSec) in Oracle 26ai: complete step-by-step guide (part one)

So you’ve been tasked with deploying a Generative AI, RAG (retrieval-augmented generation), or Agentic AI application. Have you thought about how to secure your most sensitive structured data – as well as your vectorized unstructured data? The good news is, it’s relatively simple to implement complex security policies through the latest release ­of Oracle Database 26ai Deep Data Security (DeepSec).

Performance Tuning SQL Server

sp_executesql and Execution Plans

From DualCoreDBA

Last Updated: August 17, 2026 Whilst I would say t...

PostgreSQL

Zero downtime: Franck Pachot’s ‘migration’ from Oracle to PostgreSQL

We catch up with Franck Pachot, a longtime database community figure who has moved through Oracle, CERN, Yugabyte, MongoDB and, most recently, the PostgreSQL team at Microsoft.

Andrei Lepikhov: Do Global Hash Tables Strike Back in PostgreSQL?

From Planet Postgres

In this article written for experienced PostgreSQL engineers and core developers, I want to describe how we tested one hypothesis — whether a shared hash table can be used...

Christophe Pettus: All Your GUCs in a Row: lock_timeout

From Planet Postgres

Prevent your migration from starving behind long-running queries.

Christophe Pettus: All Your GUCs in a Row: join_collapse_limit

From Planet Postgres

PostgreSQL famously does not implement query hints. This is about 95% true, and join_collapse_limit is the other 5%: set it to 1, and the planner joins your tables in...

PowerPivot/PowerQuery/PowerBI

Building Custom Data Experiences with Power BI and Fabric Apps (w/ Stephen Godderidge)

From Havens Consulting

LIVESTREAM DATE/TIME ??August 21st 2026 - 9:30 AM (Pacific Time)DESCRIPTION ??Power BI reports are great for helping people understand their data, but some scenarios call for more flexibility, customization,...

Displaying The Output Of Detail Rows Expressions In Power BI Reports Using The Paginated Report Visual

From Chris Webb's BI Blog

In last week’s post I mentioned that while Power...

Product Upgrades and Releases

Updated SQL Server Database Application Security & HA Checklist – Version 3 available

I have updated the SQL Server Database Application Security & High Availability Checklist and moved the current version to the Sarpedon Quality Lab website

New Claude Plugin For SQL Server Query Plan Analysis

From Erik Darling Data

New Claude Plugin For SQL Server Query Plan Analysis Chapters 00:00:00 – Introduction 00:00:29 – New Cloud Marketplace Skill 00:01:39 – Cloud Agent Analysis 00:03:13 – Query Plan Analysis...

R Language

Mapping a Hospital Desert in R

From DataScience+

A "hospital desert" map measures, for each neighbo...

SQL Server Security and Auditing

How Azure Arc allows a DB admin to become SQL Server sysadmin – the vulnerability explained

Azure Arc-enabled SQL Server is designed to bring on-premises and multi-cloud SQL Server instances under centralized Azure management, but a newly documented privilege escalation technique shows how that same management workflow can be turned against the server it’s meant to protect. In this investigative guide, Fabiano Amorim explains how the vulnerability works, how to reproduce it in a lab environment, why Microsoft classified it as Low severity, why that classification is disputed, and what mitigations are available today.

How Azure Arc allows a DB admin to become SQL Server sysadmin – the vulnerability explained

From Simple Talk

Learn how db_ddladmin permissions plus Azure Arc's...

T-SQL and Query Languages

sp_TexasHoldEm: Multi-Player Poker in T-SQL

From Brent Ozar Unlimited

Wanna play some Texas Hold ‘Em style poker and make a pile of Query Bucks? Wanna watch other database people playing? Fire up SSMS and connect to: Server: firstresponderkit.database.windows.net...

Beautiful T-SQL Queries: Three Could Delete the Company

From Journey to SQL Authority with Pinal Dave

AI writes genuinely beautiful T-SQL. Aligned, alia...

Simpler Date Patterns in SQL Server

From Andy Broadsword

Date handling in SQL Server tends to accumulate tried and trusted combinations of DATEPART(), DATEADD(), and DATEDIFF() – with nested variations. The challenge with these isn’t raw performance, but...

A script to script a script that scripts jobs

From SQLBlog.org

I demonstrate a procedure I wrote to script SQL Server Agent jobs idempotently, avoiding GOTO labels and schedule spaghetti.

Tech News

AI Is Learning to Write Genetic Code

From Schneier on Security

This sort of research is both exciting and terrifying: The two models in question were told to generate complete genomes for a viable bacteriophage—a type of virus able to infect...

Microsoft AI Power Bottleneck Raises Risks for Azure Growth

From Past News - RSS Feeds

Microsoft is racing to expand Azure AI capacity as...

China’s Z.ai Claims GLM-5.3 Rivals Top US Models in Coding, Cybersecurity

From Past News - RSS Feeds

Z.ai says GLM-5.3 approaches leading U.S. models on coding and cybersecurity benchmarks while delaying its open-weight release for safety testing.

The Lighter Side

How Much Does a Humanoid Robot Cost?

From Past News - RSS Feeds

How much does a humanoid robot really cost? Explore current pricing, hidden expenses, manufacturing costs, and what businesses should consider before buying.

Amazon Is Reportedly Buying and Destroying Books to Feed Its AI

From Past News - RSS Feeds

Amazon is buying and destroying printed books for ...

Waymo Wins Approval for Wider Robotaxi Service Across California

From Past News - RSS Feeds

California regulators cleared Waymo to expand paid...

Unitree ‘Superman’ Robot Hits 45.6 km/h, Tops Usain Bolt’s Peak Speed

From Past News - RSS Feeds

Unitree’s new Superman humanoid reaches 12.66 m/s, edging past Usain Bolt’s peak speed and raising new questions about faster robots at work.

Tools for Dev (SSMS, ADS, VS, etc.)

MSSQL Extension for VS Code: SQL Formatter, Azure SQL Database Provisioning, and More

With the MSSQL extension for VS Code v1.45, we’re introducing the Public Preview of the SQL Formatter alongside the General Availability of Azure SQL Database Provisioning and Shortcuts Configuration.

Accessing the Data API Builder MCP Server from VS Code

From SQLServerCentral Blogs

I recently started playing with the MCP Server for SQL Server, which is a part of the Data API Builder (DAB). I’m not sure why there wasn’t a separate... The...

Throwback Review: Using the Original SQL Server Debugger

From Brent Ozar Unlimited

I’ve got a special treat for you today! I was cleaning out my garage and you’ll never guess what I found! That’s right: it’s an original SQL Server debugger...

 
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

 

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