| | The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | | Hand-picked content to sharpen your professional edge |
| 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 |
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 |
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... |
AI systems often fail in production not because th... |
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 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 |
This guide has everything you need to know about JSON indexing in SQL Server 2025: what it is, how it works, and current limitations. |
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. |
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 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:... |
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 |
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... |
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 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 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 |
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. |
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) |
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... |
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... |
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 |
Last Updated: August 17, 2026 Whilst I would say t... |
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. |
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... |
Prevent your migration from starving behind long-running queries. |
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 |
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,... |
In last week’s post I mentioned that while Power... |
| Product Upgrades and Releases |
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 Chapters 00:00:00 – Introduction 00:00:29 – New Cloud Marketplace Skill 00:01:39 – Cloud Agent Analysis 00:03:13 – Query Plan Analysis... |
A "hospital desert" map measures, for each neighbo... |
| SQL Server Security and Auditing |
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. |
Learn how db_ddladmin permissions plus Azure Arc's... |
| T-SQL and Query Languages |
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... |
AI writes genuinely beautiful T-SQL. Aligned, alia... |
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... |
I demonstrate a procedure I wrote to script SQL Server Agent jobs idempotently, avoiding GOTO labels and schedule spaghetti. |
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 is racing to expand Azure AI capacity as... |
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. |
How much does a humanoid robot really cost? Explore current pricing, hidden expenses, manufacturing costs, and what businesses should consider before buying. |
Amazon is buying and destroying printed books for ... |
California regulators cleared Waymo to expand paid... |
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.) |
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. |
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... |
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... |
  | 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. |
|
|