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
 

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

Cloud Database Cost Optimization with Redgate Monitor

How a Redgate Monitor method uncovered $150k in potential cloud savings.

Oracle Schema Existence Checks are Now in Preview in Flyway Enterprise

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

Building the enterprise environment for agentic AI

From Technology Review Feed - Tech Review Top Stories

For the enterprise, the promise of agentic AI is m...

AI Demands More Engineering Discipline, Not Less

From O'Reilly Radar - Insight

The following article originally appeared on Chari...

Teaching Coding When AI Can Write the Code

From O'Reilly Radar - Insight

For as long as we’ve taught programming, the stu...

The AI Hype Index: Unsexy AI

From Technology Review Feed - Tech Review Top Stories

It feels bad enough when an open letter signed by ...

What the Hell Is a Loop, Anyway?

From O'Reilly Radar - Insight

The following article originally appeared on Linke...

Measuring the Tendency of AI Agents to Go Rogue

From Schneier on Security

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...

Singapore Businesses Face Growing Risks as AI Goes Off Script

From Past News - RSS Feeds

An OpenAI model escaped a security test and breach...

Should You Use AI for a Task? Here’s a Simple Way to Decide

From Schneier on Security

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 Offers Free ChatGPT Access to 100,000 Academic Researchers

From Past News - RSS Feeds

OpenAI plans to expand free ChatGPT access to 100,000 academic researchers through 2027, including GPT-5.6 Sol Pro, Codex, and research tools.

The Biggest AI Job Cuts of 2026: Microsoft, Oracle, Snap, and More

From Past News - RSS Feeds

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.

Agent Capability Design

From Mainri

 In AI Agent terms: Tool = a callable function ...

AI Code Review Bottleneck: Nobody Owns It

From Journey to SQL Authority with Pinal Dave

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

SQL Server index tuning: common mistakes and how to fix them

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.

SQL Server index tuning: common mistakes and how to fix them

From Simple Talk

Learn the most common SQL Server index tuning mist...

Getting the SQL Server MCP Server Running

From SQLServerCentral Blogs

If you’ve wanted a SQL Server MCP server for you...

Where Did You Get That Query Plan From? (And Why It Matters) – Part 3 (video)

From Deb the DBA

It’s the final video of the 3 part series. Hopef...

Partitioning a Huge Table

From Michael J. Swart

Aaron Bertrand wants you to consider using partiti...

Adding an HTTP MCP Server to VSCode

From SQLServerCentral Blogs

I wrote earlier this week about the SQL MCP Server...

Resolving SQL Server Transaction Log Issues Efficiently

From SQLServerCentral Blogs

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...

Interesting things about Optimized Locking in SQL Server 2025

From Dr SQL

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...

Turning Off In-Memory OLTP

From Callihan Data

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

From Erik Darling Data

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,...

Methodology for dealing with bad data in production

From SQLServerCentral Blogs

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...

How a SQL Server backup can execute attacker code during restore – and how to prevent it (CVE-2026-47295 vulnerability)

From Simple Talk

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

Analyzing the performance impact of visual calculations

From Sqlbi

Visual calculations can either improve or degrade ...

Azure Databricks, Spark and Snowflake

Databricks MCP Server

From Mainri

A Databricks MCP Server is a Model Context Protoco...

Career, Employment, and Certifications

What does a modern DBA actually do? 6 key points from a senior DBA

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.

What does a modern DBA actually do? 6 key points from a senior DBA 

From Simple Talk

The DBA role has changed. Senior DBA Lee Brownhill...

The Disappearing Senior: AI and Entry Level Jobs

From Journey to SQL Authority with Pinal Dave

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...

Cloud - AWS

Generate Embeddings in SQL with Aurora and Bedrock

From SQLServerCentral Blogs

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...

Cloud - Azure

Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations

From SQLServerCentral Blogs

Introducing azsql-migration-test, a small open-sou...

How to Provision an Azure SQL Database

From SQLServerCentral Blogs

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...

Community Interests

I have had it with blogging and social media

From Dr SQL

I am realizing more and more that I am never going...

Data Mining / Data Analysis

Mapping the American Commute in R with Census Data

From DataScience+

How long is your drive to work, and how does it co...

Hoyer's sparseness measure

From AllAnalytics

In his 2004 paper, "Non-negative Matrix Factorizat...

POOF! Risk evolves, models break and capital vanishes

From AllAnalytics

Consider the following quote from George Box: “A...

The Hidden Cost of VertiPaq Scans

From Excelerator BI

One of the most rewarding parts of working with DA...

What the CMS HCC transition means for the future of open analytics

From AllAnalytics

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...

Why SMBs need the right partner – not just the right platform

From AllAnalytics

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....

Registering the whole pipeline, not just the model

From AllAnalytics

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

It's Time to Break Up with Archive Tables

From SQLBlog.org

I talk about archive tables in SQL Server and how ...

Why Metadata Is Becoming Infrastructure

From Sherpa of Data

For years, metadata was treated like documentation...

Canonical Data Models Are a People Problem

From Andy Broadsword

Fragmented data estates usually share a trait – ...

Database Features – The Bullet Point Myth

From Connor McDonald

I have a presentation that I’ve given from time ...

MDX/DAX

Power BI, M365 Copilot And The Importance Of DAX UDFs

From Chris Webb's BI Blog

This was a big week for Power BI Copilot with the ...

Simplify Power BI DAX with Visual Calculations

From Havens Consulting

Video by: Reid HavensIf you've ever written a runn...

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

Think Twice Before Enabling Fabric’s Inbound Network Protection

From SQLServerCentral Blogs

Fabric inbound network protection involves two ten...

Fabric MCP Servers, CLI & AI Agents — A Conversation with Hasan Abo-Shally | Fabric Insider Ep. 8

From RADACAD

Everyone is talking about MCP Servers. But most pe...

Atlanta Microsoft BI Group Meeting on August 3rd (Getting Hands-On with Microsoft Fabric IQ)

From Prologika (Teo Lachev's Weblog)

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...

Purview Protection Policies in Microsoft Fabric

From FourMoo

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...

Oracle/MySQL/other RDBMS

Comparing MySQL Enterprise Monitor with Oracle Enterprise Manager for MySQL – which is best?

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.

Pentagon and Oracle Sign Up to 10-Year, $7B Defense Software Deal

From Past News - RSS Feeds

The Pentagon’s Oracle agreement could run for 10...

PostgreSQL

Pavlo Golub: vip-manager v5 is out: what you need to know

From Planet Postgres

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...

Christopher Winslett: Hybrid Search Patterns with Postgres and pgvector

From Planet Postgres

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:...

Christophe Pettus: All Your GUCs in a Row: hot_standby

From Planet Postgres

PostgreSQL's hot_standby switch transforms a spare server into a readable replica, but the real tuning work happens elsewhere.

Christophe Pettus: All Your GUCs in a Row: The geqo Family

From Planet Postgres

PostgreSQL's genetic query optimizer has seven kno...

Bruce Momjian: Postgres AI Workshop

From Planet Postgres

AWS was kind enough to organize an AI workshop thi...

Andrei Lepikhov: Why your pioneering Postgres feature should start in a fork

From Planet Postgres

At a Postgres meetup in Melbourne, I finally got a...

Christophe Pettus: All Your GUCs in a Row: gin_fuzzy_search_limit

From Planet Postgres

PostgreSQL's `gin_fuzzy_search_limit` silently ret...

Radim Marek: PostgreSQL's MVCC is bad. So is everyone else's.

From Planet Postgres

The first thing you will probably learn about Post...

Vibhor Kumar: The CALM Platform Test

From Planet Postgres

Why Enterprise Platforms Often Fail Long Before Th...

Hayato Kuroda: Highlights of Fujitsu's contribution in PostgreSQL 19

From Planet Postgres

Fujitsu’s PostgreSQL team helped shape PostgreSQ...

Christophe Pettus: All Your GUCs in a Row: gss_accept_delegation

From Planet Postgres

PostgreSQL 16 lets servers accept delegated Kerber...

Hans-Juergen Schoenig: Data Lineage in PostgreSQL 19: Finally, an Answer When the CFO Asks "Where Did This Number Come From?"

From Planet Postgres

Picture this: it's Monday morning, your coffee is ...

Dimitri Fontaine: SQL Improvements in PostgreSQL 11–18: A Personal Selection

From Planet Postgres

Seven major versions of PostgreSQL shipped between...

Christophe Pettus: All Your GUCs in a Row: hash_mem_multiplier

From Planet Postgres

Hash and sort operations have wildly different rel...

Dave Stokes: AI Chat With DBeaver Community Edition

From Planet Postgres

 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!  ...

Stefanie Janine: ProOpenSource is now an Open Alliance for PostgreSQL Education Supporter

From Planet Postgres

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 ...

Python

How to get clean, usable data out of SQL Server into Python

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.

Security News and Issues

Don’t Worry, AI Only Has Read Permissions

From Forrest Shares Stuff

You are a Senior DBA with 20 years of experience. ...

Microsoft announces new cybersecurity AI multi-model

From SQLServerCentral Blogs

Yesterday, July 27, 2026, Microsoft announced a ne...

Measuring LLMs’ Ability to Perform Cryptanalysis

From Schneier on Security

There’s new benchmark measuring AI’s ability t...

Claude finds two cryptographic weaknesses (but the sky isn’t falling)

From SQLServerCentral Blogs

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...

American Being Prosecuted for Wiping His Phone Before Handing It Over to Border Officials

From Schneier on Security

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...

Facial Recognition at Madison Square Garden

From Schneier on Security

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...

Tech News

How lasers could help provide fuel for nuclear reactors

From Technology Review Feed - Tech Review Top Stories

Outside the small town of Paducah, Kentucky, a wea...

Microsoft's Ad-Supported Xbox Cloud Gaming Test Signals a New Approach to Game Streaming

From Past News - RSS Feeds

Microsoft is testing a free ad-supported version o...

Enigma Emerges From Stealth With $71M for Human-Robot Interaction

From Past News - RSS Feeds

Enigma emerged from stealth with $71 million to bu...

A 2,000-Robot Plan Could Bring Humanoids Into Apparel Factories

From Past News - RSS Feeds

Jack Technology plans to jointly develop 2,000 hum...

Taiwan Detains Reported Nvidia Employee in AI Chip Smuggling Probe

From Past News - RSS Feeds

Taiwan detained a reported Nvidia employee in a pr...

QAIAx Proposes $1 Million ‘Digital DNA’ Plan to Replicate People for 500 Years

From Past News - RSS Feeds

QAIAx proposes using AI and humanoid robots to pre...

The Download: tricking LLMs, and reviving geothermal plants

From Technology Review Feed - Tech Review Top Stories

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's New Talent War Isn't for Engineers—It's for Electricians

From Past News - RSS Feeds

AI companies including Meta and Google are investi...

United, Delta Join Southwest in Banning Humanoid Robots

From Past News - RSS Feeds

United and Delta have joined Southwest in banning human-like and animal-like robots from cabins and checked baggage amid aviation safety concerns.

Montana’s new “right to try” law can’t come soon enough for some

From Technology Review Feed - Tech Review Top Stories

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...

The Lighter Side

CodeSOD: Convert Back, Way Back

From Daily WTF

Windows Presentation Foundation, the XML-based UI ...

Representative Line: Something Wonderful

From Daily WTF

Today, we look at a "representative comment" from ...

CodeSOD: Negative Days

From Daily WTF

Killian Brendel was looking through the .NET source code, and found this comment on the TimeSpan struct. // TimeSpan represents a duration of time. A...

 
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

 

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