| | The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | | Hand-picked content to sharpen your professional edge |
| VACATION! Yeah, I've got the Go-Go's running in my head because I'm going on vacation tomorrow (holiday for you UK types). I've been slogging through a really dense book, War in Human Civilization. Total recommendation. Get it. Read it. However, I'm right near the end and there's been a lot of discussion about the impact of prosperity on warfare. Which means a lot of discussion about prosperity itself. Most importantly, the factors that make prosperity possible. It's multifactored, way beyond my ability, or the amount of space, to discuss it here. However, what it brings up in my mind is the fact that I get to go on vacation. The vast majority of us working in IT get to take paid time off. Sure, maybe you can't take all your time off this year because of work deadlines or whatever. Maybe you don't like taking time off for whatever reason and you sell it back to the organization (assuming you can do that). And yes, some of us will still be on call, even while on holiday. I get all that. Still, we are privileged to live in a time and place where that opportunity exists. What's more, we work in an industry where it's possible to take that time. My advice is simple. Take it. I know, seems silly. Of course we want to take that time. Yet, a lot of people don't. I suggest you do it for two reasons. First, it just gives your brain a chance to reset. You don't have to got so some vacation spot. Visit a local museum. Take in a show. Go for a long walk in the woods. Break up your routine and orient your mind on something besides tech. Second, you get the chance to be with those you love. Take some time to go see that Aunt you haven't seen in a few years (my own personal objective). Play games with the kids like you've been meaning to do. Focus on others as well as yourself. We do live in an age of prosperity and it has given us opportunities that our ancestors didn't even bother to dream about because they were utterly unimaginable, even less than a hundred years ago. Don't squander it. Appreciate it. Take advantage of it. Why not? Now, I'm off to the beach. Grant Fritchey 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 |
How a Redgate Monitor method uncovered $150k in potential cloud savings. |
When generating versioned and undo migration scripts for Oracle database projects, you can set a comparison option to include object existence checks in the generated SQL. When enabled, Flyway checks whether a table, column, view, or other object already exists before attempting to create or drop them. |
| AI/Machine Learning/Cognitive Services |
For the enterprise, the promise of agentic AI is m... |
The following article originally appeared on Chari... |
For as long as we’ve taught programming, the stu... |
It feels bad enough when an open letter signed by ... |
The following article originally appeared on Linke... |
This essay was written with Barath Raghavan, and originally appeared in The Guardian. In July, Hugging Face, a company that hosts much of the world’s AI software and open-source AI... |
An OpenAI model escaped a security test and breach... |
This essay originally appeared in The Guardian. I teach public policy at the Harvard Kennedy School and the Munk School at the University of Toronto. And it will come as... |
OpenAI plans to expand free ChatGPT access to 100,000 academic researchers through 2027, including GPT-5.6 Sol Pro, Codex, and research tools. |
Explore the biggest AI-related job cuts of 2026, including Microsoft, Snap, Oracle, and Atlassian, and what they reveal about how AI is reshaping the workforce. |
In AI Agent terms: Tool = a callable function ... |
Everybody agrees the AI code review bottleneck is real. Then go look at the org chart. First appeared on AI Code Review Bottleneck: Nobody Owns It |
| Administration of SQL Server |
This guide walks through the most common SQL Server index tuning mistakes seen in production environments, such as over-indexing, oversized INCLUDE lists, unnecessary fill factor settings, misuse of SORT_IN_TEMPDB, over-aggressive index maintenance – and the myth that heaps are a shortcut to speed. Features real examples. |
Learn the most common SQL Server index tuning mist... |
If you’ve wanted a SQL Server MCP server for you... |
It’s the final video of the 3 part series. Hopef... |
Aaron Bertrand wants you to consider using partiti... |
I wrote earlier this week about the SQL MCP Server... |
Transaction log issues are one of the quietest ways a healthy database turns into an incident. A log file fills up, backups fall behind, and by the time anyone... The... |
A feature I have been trying to find time to write about since it arrived is Optimized Locking, which first shipped in SQL Server 2025. This is a feature... |
Decisions can be hard. There are negligible decisions like paper or plastic but also dicey decisions like figuring out what your wife really wants for dinner when she asks... |
Learn T-SQL With Erik: Variables and Date Math Chapters 00:00:00 – Introduction 00:02:15 – Understanding Parameter Sniffing 00:03:13 – Query Plan Analysis 00:08:48 – Performance Comparison Full Transcript Alright,... |
Pinal Dave wrote up his methodology for what to do when you discover bad data in production. If you’ve never been in this situation, having a plan beforehand is... The... |
CVE-2026-47295: a truncation bug in SQL Server's replication cleanup lets a malicious backup execute attacker code as sysadmin during RESTORE DATABASE. Learn more, including how to prevent it.… The post... |
| Analysis Services / BI on the MS Stack |
Visual calculations can either improve or degrade ... |
| Azure Databricks, Spark and Snowflake |
A Databricks MCP Server is a Model Context Protoco... |
| Career, Employment, and Certifications |
Cloud spend dashboards, AI-generated pull requests, 30-second downtime windows – these are just some of the new elements that make up the DBA role of today. We sat down with Lee Brownhill, a senior DBA and Redgate Ambassador with 20 years of experience, to get his honest take on where the role is heading – and what database professionals are actually focused on right now. |
The DBA role has changed. Senior DBA Lee Brownhill... |
The AI code review bottleneck is real and everyone agrees on it. Then look at the org chart. There is no verifier and no budget line anywhere. First appeared on... |
Most embedding pipelines on AWS have the same shape: a job reads rows out of the database, calls Amazon Bedrock, and writes the vectors back. That is a second... The... |
Introducing azsql-migration-test, a small open-sou... |
Aside from spinning up a SQL Server instance container, the free Azure SQL Database is another great tool for learning SQL. You can even use it for low-traffic or... The... |
I am realizing more and more that I am never going... |
| Data Mining / Data Analysis |
How long is your drive to work, and how does it co... |
In his 2004 paper, "Non-negative Matrix Factorizat... |
Consider the following quote from George Box: “A... |
One of the most rewarding parts of working with DA... |
Open-source technologies have become a standard part of modern analytics, data science and AI. Organizations across regulated industries are adopting tools like Python to accelerate innovation while building more... |
Small and midsized businesses are entering a defining period for AI adoption. Data, analytics and AI platforms are becoming essential for organizations that want to compete, adapt and grow.... |
Most machine learning models produce a probability, but many times logic is applied to that prediction to produce a decision. That last logic step often lives in a downstream... |
| Database Design, Theory and Development |
I talk about archive tables in SQL Server and how ... |
For years, metadata was treated like documentation... |
Fragmented data estates usually share a trait – ... |
I have a presentation that I’ve given from time ... |
This was a big week for Power BI Copilot with the ... |
Video by: Reid HavensIf you've ever written a runn... |
| Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) |
Fabric inbound network protection involves two ten... |
Everyone is talking about MCP Servers. But most pe... |
Atlanta BI fans, please join us online for our next meeting on Monday, August 3rd at 18:30 ET. Dean Jurecic will introduce you to Fabric IQ that helps organizations... |
How to use Microsoft Purview Protection Policies so a Fabric workspace Admin can still fully administer the workspace… but is completely blocked from seeing any of the sensitive data... |
MySQL Enterprise Monitor was a tool many database administrators turned to in times of need – that was, until Oracle Enterprise Manager for MySQL came along and stole the show, leading to its phasing out at the start of 2025. Plenty of DBAs have since made the switch to Enterprise Manager, but have you? If the answer’s ‘no’, I’ll explain why you should make the upgrade, and how to do it. |
The Pentagon’s Oracle agreement could run for 10... |
High availability setups are never “set and forget”. Every new release of your tooling can change how your cluster behaves at 03:00 when something breaks. vip-manager v5 is... |
Most production vector queries are not simple nearest-neighbor searches. Rarely is the query to return "the 10 most similar documents in the entire table." Typically, it's something closer to:... |
PostgreSQL's hot_standby switch transforms a spare server into a readable replica, but the real tuning work happens elsewhere. |
PostgreSQL's genetic query optimizer has seven kno... |
AWS was kind enough to organize an AI workshop thi... |
At a Postgres meetup in Melbourne, I finally got a... |
PostgreSQL's `gin_fuzzy_search_limit` silently ret... |
The first thing you will probably learn about Post... |
Why Enterprise Platforms Often Fail Long Before Th... |
Fujitsu’s PostgreSQL team helped shape PostgreSQ... |
PostgreSQL 16 lets servers accept delegated Kerber... |
Picture this: it's Monday morning, your coffee is ... |
Seven major versions of PostgreSQL shipped between... |
Hash and sort operations have wildly different rel... |
DBeaver recently introduced interactive chat capabilities into the free, open-source Community Edition. What does that mean? It means some of your database tasks can be accomplished significantly faster! ... |
What Is Open Alliance for PostgreSQL Education (OAPE)? The OAPE is the recently founded organistion that will offer indipendent community PostgreSQL certifications. Why Becoming A Supporter ... |
In the modern data landscape, most of the effort doesn’t go into building models or dashboards. It goes into getting the data into a usable state. Generally, a large portion of time is spent extracting, cleaning, and reshaping data before any analysis can begin. While Python and SQL together form a powerful stack, the boundary between them is often where things start to break down. In this article, you’ll learn how to build a more reliable flow by pushing the right work into SQL and keeping Python focused on what it does best: analysis. Plus, expert tips and advice on views, CTEs, pruning, and efficient data extraction. |
You are a Senior DBA with 20 years of experience. ... |
Yesterday, July 27, 2026, Microsoft announced a ne... |
There’s new benchmark measuring AI’s ability t... |
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview) to find cryptographic weaknesses in two algorithms. However, this doesn't impact anything anyone has in... The... |
He’s being prosecuted for giving border officials a code that wiped his phone: The case centers on a feature included in GrapheneOS, a custom Android operating system that runs in... |
Last month, the story broke (alternate link) that Madison Square Garden uses facial recognition software on everyone entering the facility, and—among other groups—flags activists that oppose using facial recognition. Turns... |
Outside the small town of Paducah, Kentucky, a wea... |
Microsoft is testing a free ad-supported version o... |
Enigma emerged from stealth with $71 million to bu... |
Jack Technology plans to jointly develop 2,000 hum... |
Taiwan detained a reported Nvidia employee in a pr... |
QAIAx proposes using AI and humanoid robots to pre... |
This is today’s edition of The Download, our weekday newsletter that provides a daily dose of what’s going on in the world of technology. A fundamental flaw leaves LLMs... |
AI companies including Meta and Google are investi... |
United and Delta have joined Southwest in banning human-like and animal-like robots from cabins and checked baggage amid aviation safety concerns. |
Kris DeVault is desperate. His son, Brody, was born in March 2023. It wasn’t long before he started to show signs of developmental delay, says DeVault. As time went... |
Windows Presentation Foundation, the XML-based UI ... |
Today, we look at a "representative comment" from ... |
Killian Brendel was looking through the .NET source code, and found this comment on the TimeSpan struct. // TimeSpan represents a duration of time. A... |
  | 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. |
|
|