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
 

Greener Grass

Before I start the whining (whinging if you prefer), let me just say I have the greatest job in the world. I'm exceedingly lucky to have it. I'm grateful as can be. And someone else (looking at you Tim) can get it when they pry it from my dead cold fingers.

With that out of the way....

Today is my second day this week working out of a hotel room. Many times on the road, the hotels have "Executive Lounges" which are decent places to go and get work done. However, not always. So you get stuck in the room. This particular one doesn't have a desk of any sort. There's a table (a bit too high) and a chair (a bit too low with a low back) that are not conducive to typing. A couple of weeks back I was stranded by Deutsche Bahn 2/3 of the way to my destination. Earlier this week a five hour layover (not a bad thing actually) turned into less than an hour because of weather. I've been stranded multiple times in different airports all around the world, calling hotels to get a last-minute room somewhere. Jet lag sucks. Hotel rooms are usually too hot, too cold, or alternate between the two. I actually find most of the beds to be comfortable enough, but oh my god the pillows.

In short, travel can be extremely uncomfortable.

I'm just sharing that so you know, sure, I have a fantastic job that I truly love, but it's not perfect. There are real challenges to it some days. The grass isn't always greener on the other side of the hill. Sometimes, it's just different grass.

I say all this because I've had a couple of conversations recently with people who were looking to leave their jobs for another. Yet, when you drill down on what they're moving for, or to, you frequently find that they work for, let's say a bank, and they're interviewing at other banks. For the same position as the one they are currently in. I try to point out to them that... really, they're not looking at greener grass, just different grass. Maybe even not that different.

If you are thinking of changing jobs, be sure that it's a real change. At the very least, the same position, but in a different industry will bring new challenges and some excitement. It should be a real change that drives you though, not just the appearance of greener grass.

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

Automated State-based Deployments in Flyway

Learn how Flyway's state-based deployments help teams coordinate database changes and automate deployments, reducing risk, without disrupting existing development workflows. This article explains how they work, where they fit best, and when it makes sense to move to a migration-based approach.

Database monitoring in Financial Services: why this high-stakes sector requires a scalable, more comprehensive solution

IT and data teams in Financial Services must meet the more exacting demands for data integrity, compliance, performance, high availability and security that are expected in the sector. These demands require a dedicated, comprehensive, and scalable monitoring solution to help teams succeed in this high stakes environment.

Sensitive Action Log in Redgate Monitor Enterprise

I’m excited to announce a new capability in Redgate Monitor Enterprise: the Sensitive Action Log. As infrastructure becomes more complex, it’s more critical than ever to maintain control over how your monitoring environment is configured and accessed. Whether you’re responding to internal compliance policies, preparing for audits, or simply tightening operational security, it’s key to understand who did what, when.

AI/Machine Learning/Cognitive Services

Anthropic CEO: AI Will Soon Take Nearly Half of Entry-Level White-Collar Jobs

From Past News - RSS Feeds

Experts urge action as AI accelerates workplace au...

New AI Model Threatens Blackmail After Implication It Might Be Replaced

From Past News - RSS Feeds

In a series of tests, Anthropic’s newly released...

Google’s Veo 3 AI Video Generator: Its Major Cons Might Outweigh Pros

From Past News - RSS Feeds

At the core of Flow is Veo 3, Google’s latest AI video generation model. While Veo 3’s capabilities are impressive, its realism comes with serious concerns. The post Google’s Veo...

Hidden AI instructions reveal how Anthropic controls Claude 4

From Ars Technica

Expert analysis shows Anthropic's attempts to skip chatbot praise and avoid copyrighted content.

Achieving Successful Outcomes: Why AI Must Be Considered an Extension of Data Products

From Dataversity

 In many organizations, AI exists as a secret weapon. It’s essentially locked away in a box, brought out to work on a limited use case, and then put back...

The AI Hype Index: College students are hooked on ChatGPT

From Technology Review Feed - Tech Review Top Stories

Separating AI reality from hyped-up fiction isn’t always easy. That’s why we’ve created the AI Hype Index—a simple, at-a-glance summary of everything you need to know about the state...

This Requirement Would ‘Kill’ UK’s AI Industry, Says Former Meta Exec Clegg

From Past News - RSS Feeds

Nick Clegg described it as “implausible” to seek permission from every artist before using their work to train AI models given the vast scale of data used. The post This...

Administration of SQL Server

Uninstall PolyBase from SQL Server

From Jeff Taylor

If you have SQL Server 2019 or SQL Server 2022 ins...

SQL Inventory Dashboards: From Raw Data to Real Insight

From SQLServerCentral Blogs

Tired of inventory headaches? Stock shortages and ...

SQL Server 2025 Standard Developer Edition

From John Sterrett

With the release candidate of SQL Server 2025, whi...

Query Hints and Estimated Plans

From Scary DBA (Grant Fritchey)

I’m working on an update to my Query Performance...

SQL Server Management Studio 21 is GA

From Callihan Data

In case you missed it, SQL Server Management Studi...

SQL Server Logins vs. Users: Why You Really Need to Know the Difference

From DallasDBAs.com

The Two-Layer Model Explained “We added them to the database, but they still can’t connect.” Sound familiar? That’s the kind of confusion SQL Server’s two-layer security model creates when...

Big Data

Data Quality: The Foundation for Business Agility and Growth

We live in a world awash with vast amounts of data. Today’s modern enterprises generate and rely on vast amounts of data every single day, but data is only as valuable as its quality. Organizations across industries are increasingly aware of the critical role data quality plays in their success, especially within today’s intricate customer landscape. However, despite its significance, poor data quality persists as a common challenge, driven by fragmented systems and siloed data.

Cloud - AWS

Enhance AI-assisted development with Amazon ECS, Amazon EKS and AWS Serverless MCP server

From AWS News Blog

AWS introduces specialized Model Context Protocol ...

AWS Weekly Roundup: Claude 4 in Amazon Bedrock, EKS Dashboard, community events, and more (May 26, 2025)

From AWS News Blog

As the tech community we continue to have many opp...

Amazon Aurora DSQL, the fastest serverless distributed SQL database is now generally available

From AWS News Blog

Amazon Aurora DSQL is the fastest serverless distributed SQL database with virtually unlimited scale, the highest availability, and zero infrastructure management for always available applications. You can remove the...

Community Interests

Henrietta Dombrovskaya: Prairie Postgres Developers Summit

From Planet Postgres

Even before the Community Summit in Montreal, I wa...

Karen Jex: PostgreSQL Europe Diversity Task Force (Deep Dive and Updates)

From Planet Postgres

I'm sharing the slides and transcript from my talk about the PostgreSQL Europe Diversity Task Force at PostgreSQL Development Conference 2025. It's an extended version of the 5...

Data Mining / Data Analysis

Visualize the Gini-Simpson diversity index

From AllAnalytics

A previous article discusses the Gini-Simpson diversity index and how to compute it in SAS. Suppose you have a sample that contains R classes. (Classes are also called groups...

Perimenopause power-up: beyond basic nutrition

From AllAnalytics

In the last post, we explored fundamental nutritional habits to manage inflammation, insulin resistance, gut health and stress resilience which can all impact perimenopause symptoms. Now, let’s build on...

Database Design, Theory and Development

Unstructured Data Management Tips

From IT Pro - Microsoft Windows Information, Solutions, Tools

Managing unstructured data can be both challenging and confusing. A few handy tips can make the task much faster and easier.

Your SQL Starting Line: Best Free Databases for Beginners

From SQLServerCentral Blogs

Wondering which database to tackle first? I’ve got the lowdown on the top free choices for anyone new to SQL, and I’ll tell you exactly why they’re stellar for... The...

DevOps and Continuous Delivery (CI/CD)

Create Data Pipeline tests with GitHub Copilot in Visual Studio Code

From Kevin Chant

Reading Time: 7 minutesIn this post I want to co...

DevOps Devour Hour Slides

From SQLServerCentral Blogs

Here are the slides from my talk today at the Redg...

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

Fabric Database: Advanced Vector Search Features

Let’s talk about some advanced features available both in Fabric Databases and Azure SQL.

Generating Sample Data With Copilot In Fabric Dataflows Gen2

From Chris Webb's BI Blog

As a Power Query fan I’m naturally interested in...

Metadata-Driven Fabric Data Factory Pipeline Orchestration From ADF

From AndyLeonard.blog()

Blog Post Note / Disclaimer / Apology: This is a l...

Current state of Microsoft Fabric workloads

From Kevin Chant

Reading Time: 4 minutesIn this post I want to cover the current state of Microsoft Fabric workloads. As per the below diagram that I created. In reality,...

Using a Python Notebook to Query Multiple Lakehouse Tables into a Data frame

From FourMoo

In this blog post I am going to explain how to query multiple Lakehouse tables into a data frame. The example I am going to use is when you...

Oracle/PostgreSQL/MySQL/other RDBMS

Oracle Data Guard: Disaster Recovery AND High Availability

From DBAKevlar

In its traditional, (and free) configuration, Orac...

Running a MySQL database in a Docker Container

From Simple Talk

Relational databases provide a structured approach...

The Value of Cost: Oracle’s Optimizer

From DBAKevlar

When you first begin your journey into Oracle performance tuning, you quickly discover that you’re not just working with databases,

PostgreSQL

Multi-Version Concurrency Control (MVCC) in PostgreSQL: Learning PostgreSQL with Grant

It’s a tale as old as time. You want to read data. Your mate wants to write data. You’re stepping on each other’s toes, all the time. When we’re talking about relational data stores, one aspect that makes them what they are is the need to comply with the ACID properties...

semab tariq: Understanding Split-Brain Scenarios in Highly Available PostgreSQL Clusters

From Planet Postgres

High Availability (HA) refers to a system design a...

Performing PostgreSQL Version Upgrades

From Curated SQL

Warda Bibi upgrades a server: Upgrading to the lat...

Andrew Atkinson: Tip: Put your Rails app on a SQL Query diet

From Planet Postgres

Introduction Much of the time taken processing...

David Wheeler: Postgres Extensions: Use PG_MODULE_MAGIC_EXT

From Planet Postgres

A quick note for PostgreSQL extension maintainers:...

Álvaro Hernández: How to Build Postgres with Zig: A Drop-In GCC/Clang Alternative

From Planet Postgres

What’s Zig and Zig’s C/C++ compiler? In ca...

Andrew Atkinson: Big Problems From Big IN lists with Ruby on Rails and PostgreSQL

From Planet Postgres

Introduction If you’ve created web apps with...

Comparing DiskANN in SQL Server & HNSW in RavenDB

From Ayende @ Rahien

When building RavenDB 7.0, a major feature was Vec...

Andreas 'ads' Scherbaum: Dirk Krautschick

From Planet Postgres

PostgreSQL Person of the Week Interview with Dirk ...

Andrew Farries: pgroll 0.13.0: Start using pgroll on existing databases with the new baseline feature

From Planet Postgres

The new baseline feature in pgroll 0.13.0 makes it easy to start using pgroll on databases with existing schema and keep your schema histories clean.

Webinar: RavenDB's Upcoming Optimizations Deep Dive

From Ayende @ Rahien

Tomorrow I’m going to be doing a Discord webinar about the deep optimizations we did in how  RavenDB talks to the disk. We are talking about some of the biggest...

Per-backend IO stats in PostgreSQL 18

From Blog – Redgate Software

One of my favorite new PostgreSQL 18 features which hasn’t had much attention yet is tracking session-level IO stats. It’s going to be really helpful for more quickly finding...

PowerPivot/PowerQuery/PowerBI

Sharing Power BI Reports with External Users – Part 1: Understanding the Problem and Core Concepts

From BI Insight

Sharing Power BI reports with external users is a common but often misunderstood scenario. While it may seem simple on the surface, doing it properly and securely involves many...

Python

Python ML pipelines with Scikit-learn: A beginner’s guide

From AllAnalytics

Using SAS Viya Workbench for efficient setup and e...

R Language

Little useless-useful R functions – Absurd bias DAG with useless mental shortcuts

From TomazTsql

Exploring graphs is always a fun. Attaching the ed...

Security News and Issues

Zero-Trust Architecture for Cloud-Based AI Systems

From Simple Talk

Cloud-based artificial intelligence’s growth has...

MCP: What It Is and Why It Matters—Part 2

From O'Reilly Radar - Insight

This is the second of four parts in this series. Part 1 can be found here. 4. The Architecture of MCP: Clients, Protocol, Servers, and Services How does MCP...

Thousands of Asus routers are being hit with stealthy, persistent backdoors

From Ars Technica

Backdoor giving full administrative control can survive reboots and firmware updates.

T-SQL and Query Languages

Free SQL Practice: 9 Killer Resources to Boost Your Query Skills

From SQLServerCentral Blogs

So, you want to get your SQL skills razor-sharp wi...

DISTINCT and UNION: What happens when you use them together?

From Simple Talk

When I was perusing my LinkedIn feed the other day...

Video: Retrieving Child Records with APPLY

From 36 Chambers – The Legendary Journeys

THE VIDEO THE SYNOPSIS In this video, I show how we can use the APPLY operator to find records associated with a “parent” table. We look at getting the...

Learn T-SQL With Erik: DISTINCT Isn’t Always Evil

From Erik Darling Data

Learn T-SQL With Erik: DISTINCT Isn’t Always Evil Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering...

Using AI to Test a SQL Query

From SQLServerCentral Blogs

Someone sent me this code. WITH p AS ( SELECT ID, ROW_NUMBER() OVER (ORDER BY ID ASC) AS RN FROM wp_posts WHERE post_parent = 94341; ) UPDATE p SET... The...

Tech News

Desktop Survivors 98 is more than just a retro Windows nostalgia trip

From Ars Technica

Tight mouse controls and inventive weapons build o...

Have we finally solved mystery of magnetic moon rocks?

From Ars Technica

Simulations show how effects of asteroid impact co...

A new sodium metal fuel cell could help clean up transportation

From Technology Review Feed - Tech Review Top Stories

A new type of fuel cell that runs on sodium metal could one day help clean up sectors where it’s difficult to replace fossil fuels, like rail, regional aviation,...

Falcon 9 sonic booms can feel more like seismic waves

From Ars Technica

Trajectories, wind shear, temperature gradients, t...

Tesla’s Robotaxis Rollout in Austin, Texas Will Be Watched ‘Very Carefully’

From Past News - RSS Feeds

Tesla's robotaxis trial in Austin, Texas is slated to launch by the end of June, Elon Musk confirmed. Find out why this is a high-stakes move for the EV...

After the LA fires, scientists study the toxic hazards left behind

From Ars Technica

Researchers are studying the long-term effects on ...

Trump signs executive orders meant to resurrect US nuclear power

From Ars Technica

Plan calls for three new reactors to reach criticality in about a year.

My 3D printing journey, part 2: Printing upgrades and making mistakes

From Ars Technica

3D-printing new parts for the A1 taught me a lot about plastic, and other things.

Ars Live, right now: Three space journos pick apart NASA’s Mars plans

From Ars Technica

Join us on the livestream at 3 pm EDT and ask questions about the future of space!

We now have a good idea about the makeup of Uranus’ atmosphere

From Ars Technica

20 years of observations have given us more knowledge about the icy giant.

Amazon and Stellantis abandon project to create a digital “SmartCockpit”

From Ars Technica

The Amazon/Stellantis STLA SmartCockpit was meant to arrive in 2024.

Autonomous Trucks Breakthrough Doesn’t Halt All Safety Concerns About Path Forward

From Past News - RSS Feeds

Aurora's autonomous trucks are delivering freight in Texas with no human driver. The promise is big, but so are the safety concerns. The post Autonomous Trucks Breakthrough Doesn’t Halt All...

The Lighter Side

Friday Squid Blogging: US Naval Ship Attacked by Squid in 1978

From Schneier on Security

Interesting story: USS Stein was underway when her...

The Missing Link of Ignorance

From Daily WTF

Our anonymous submitter, whom we'll call Craig, wo...

 
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

 

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