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
 

Life Moves Pretty Fast

Driving my soon-to-be granddaughter to school today (my son is getting married and will adopt the young lady), we saw a dead armadillo, a turtle in the road (rescued it) and an escaped cow (left it alone). THEN... old soon-to-be granddad had forgotten lunch, so had to deliver that back at the school (cow must have gone back into its field). But only after I caught my son's dog which had slipped his collar while I was walking him. Oh, AND, I've still got work to do, including writing this editorial.

Anyway, how's your day going?

I may not have mentioned this previously, but I work for Redgate Software. I love the job. A lot. However, let me tell you about one of our products, Redgate Monitor. It started life as a monitoring tool for SQL Server. Now it also supports PostgreSQL. Oh, and we have limited Oracle and MySQL support as well with much more to come. All the cloud platforms are in there. In fact, there are eight (8) teams of developers working on the product right now. This means, almost every time I demo the product, I get to say the phrase, "Oh, that's new." Keeping up is frequently just an act of discovery.

There is a lot going on in the world, in technology, in our lives. Keeping up with it, well, ain't always easy. But, keep up we must. However, don't forget the Ferris Bueller quote: Live moves pretty fast. If you don't stop and look around once in a while, you may miss it.

 

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

Reducing Database Complexity and Size using Subsetting

Getting realistic test data from large production databases can be a challenge, especially when you're trying to keep dev environments lightweight and secure. Redgate Test Data Manager includes a subsetting CLI that simplifies this by letting you generate smaller, fully representative subsets automatically. This article will walk you through getting started: from setup and configuration to running and refining simple subset operations.

DB-Engines shares Q1 2025 database industry rankings and top climbers: Snowflake and PostgreSQL trending

Oracle maintains its top-ranking spot; persistent growth trends from PostgreSQL and Snowflake highlight Q1 2025 DB-Engines rankings analysis.

AI/Machine Learning/Cognitive Services

Saying ‘Please and Thank You’ to ChatGPT is Burning Cash and Energy: Why It Matters

From Past News - RSS Feeds

Does saying 'please' and 'thank you' to ChatGPT re...

The Truth is Out There: AI is Helping Search for Aliens & Earth-Like Planets

From Past News - RSS Feeds

Two recent developments in AI and astrophysics mig...

Why modern risk modeling is a game-changer for banks

From AllAnalytics

The financial industry is evolving at an unprecede...

ChatGPT’s Flattery Problem: Praise That Comes at a Price

From Past News - RSS Feeds

OpenAI’s March update responded to user preferen...

Closing the AI skills gap: Why training matters more than ever

From AllAnalytics

As someone deeply involved in the world of data sc...

AI secretly helped write California bar exam, sparking uproar

From Ars Technica

A contractor used AI to create 23 out of the 171 s...

Preparing for the EU AI Act in insurance

From AllAnalytics

What insurance companies need to know about the Fundamental Rights Impact Assessment (FRIA)  The EU Artificial Intelligence Act (EU AI Act) is ushering in a new era of accountability...

Building trust in AI: A principled approach to ethical agent development

From AllAnalytics

AI agents are no longer confined to labs and prototypes. They’re shaping how we live, work and make decisions. From customer service bots and self-driving cars to robotic surgical...

Administration of SQL Server

Change Data Capture and the Value of Real-Time Data Integration

From Dataversity

Business insights are only as good as the accuracy...

SQL Server Index Primer

From SQLServerCentral Blogs

Indexes 101: What, Why, and When? “What Is an In...

Analysis Services / BI on the MS Stack

Updating old SAS programs: A case study with PROC LOESS

From AllAnalytics

SAS programmers love to brag that the SAS will sti...

Azure DevOps

Automate testing Microsoft Fabric Data Pipelines with Azure DevOps

From Kevin Chant

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

Azure SQL Managed Instance

Secure Azure SQL Server Backups Using Managed Identities

From SQLServerCentral Blogs

I do believe most people know about the ability to...

Cloud - AWS

AWS Weekly Roundup: Upcoming AWS Summits, Amazon Q Developer, Amazon CloudFront updates, and more (April 21, 2025)

From AWS News Blog

Last week, we had the AWS Summit Amsterdam, one of...

New Amazon EC2 Graviton4-based instances with NVMe SSD storage

From AWS News Blog

AWS introduces new EC2 instance families (C8gd, M8...

Enhance real-time applications with AWS AppSync Events data source integrations

From AWS News Blog

Developers can connect Lambda functions, DynamoDB tables, and other resources to create sophisticated real-time applications with features like data transformation, persistent storage, and validation.

Cloud - Azure

In the works – New Availability Zone in Maryland for US East (Northern Virginia) Region

From AWS News Blog

AWS is adding a new Availability Zone in Maryland to the US East (Northern Virginia) Region by 2026, enhancing redundancy and supporting growing AI workloads while maintaining high-bandwidth, low-latency...

Community Interests

SQL Saturday Richmond Roundup

From Simple Talk

On the weekend of April 5, 2025, I attended (and R...

Redgate Summit Is Coming To New York, Dallas, and the Netherlands this Fall!

From Blog – Redgate Software

After an amazing Redgate Summit in London earlier ...

Austin, Texas Best Microsoft Technical Training Oppertunity

From John Sterrett

If you’re looking to master SQL Server, Power BI...

Computing in the Cloud (Azure, Google, AWS)

Driving business value by optimizing the cloud

From Technology Review Feed - Tech Review Top Stories

Organizations are deepening their cloud investment...

DMO/SMO/Powershell

Why Invoke-DbaQuery Is My Most-Used dbatools Query

From StraightPath Solutions SQL Blog

In this blog post, we will audit the dbatools comm...

Using a Local Large Language Model (LLM): Interacting with Local LLMs Using PowerShell

From SQLServerCentral Blogs

As AI continues to evolve, many of us are looking ...

Data Mining / Data Analysis

From Parchment to Python: How Smart Data Evolved to What It Is Today

From Dataversity

Data used to be a physical thing, stored on paper ...

WordPress and Google Analytics: From Setup to Insights

From https://chrisadkin.io

Your website can’t grow without data. Learn how to connect WordPress and Google Analytics to improve your website performance.

DevOps and Continuous Delivery (CI/CD)

The Concepts of TestOps

This article will discuss testing and introduce the concept of Test Operations (testOps). By the end of this article, you should see testing in a broader picture and see cases where testOps come in. You’ll also know a variety of the tools you can use to implement testOps in your development workflow.

Introduction to GitHub Actions Part 2: GitHub-hosted runners

From Simple Talk

In the first article of this series, you learned h...

MLOps vs. DevOps: Key Differences — and Why They Work Better Together

From IT Pro - Microsoft Windows Information, Solutions, Tools

Explore the differences between MLOps and DevOps �...

Reducing Database Complexity and Size using Subsetting

From Product learning – Redgate Software

Getting realistic test data from large production ...

Why IT Pros Should Start Paying Attention to Git

From IT Pro - Microsoft Windows Information, Solutions, Tools

Once the domain of developers, Git is fast becoming essential for IT operations, offering powerful benefits for managing infrastructure, automation, and documentation in a DevOps-driven world.

Hardware

Hardware Accelerated GPU Scheduling Instability

From Essence of Code

I recently upgraded to a powerful developer-class ...

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

What are the advantages of using Python Notebook vs a Spark Notebook in Microsoft Fabric

From FourMoo

I would like to start off because I am by no means...

How to Load a Date Dimension in Microsoft Fabric using Macros in dbt?

From Simple Talk

With the popular data transformation tool dbt (dat...

Oracle/PostgreSQL/MySQL/other RDBMS

MySQL vs PostgreSQL – String Datatypes

A very common task in creating a database is to store string data. For example, words, paragraph(s) or even documents. String data types allow you to do just that and store and represent text. They handle everything from simple names and addresses to complex data.

Oracle Memory Management: Common Configurations, Parameters, and Recommended Practices

From DBAKevlar

After the initial overview of memory monitoring in...

Performance Tuning SQL Server

Can AI Read Execution Plans?

From Scary DBA (Grant Fritchey)

Yeah, yeah, second AI post in a row. I promise not...

All About SQL Server Stored Procedures: Temporary Object Performance

From Erik Darling Data

All About SQL Server Stored Procedures: Temporary ...

SQL SERVER – Catching Non-SARGable Queries in Action

From Journey to SQL Authority with Pinal Dave

If you ever wondered why a query that looks harmle...

Introducing sp_IndexCleanup!

From Erik Darling Data

Introducing sp_IndexCleanup! Going Further If this...

Monday Monitor Tips: Finding the Hostname for Queries

From SQLServerCentral Blogs

I was chatting with a customer recently and they w...

PostgreSQL

Pavel Stehule: Article about PostgreSQL 18

From Planet Postgres

I wrote an article about PostgreSQL 18.  It is in...

Laurenz Albe: Type alignment and padding bytes: how to not waste space in PostgreSQL tables

From Planet Postgres

© Laurenz Albe 2025 Saving storage space shou...

Andrei Lepikhov: On expressions' reordering in Postgres

From Planet Postgres

Today, I would like to discuss additional techniqu...

Ernst-Georg Schmid: TRAKTOR revisited

From Planet Postgres

Working on TRAKTOR again. The good news is, it sti...

Ibrar Ahmed: 8 Steps to Proactively Handle PostgreSQL Database Disaster Recovery

From Planet Postgres

When disaster strikes, whether a natural disaster ...

Kaarel Moppel: Striping Postgres data volumes - a free lunch?

From Planet Postgres

A small follow up on my previous post on various Postgres scale-up avenues in my preferred order. The post received quite a bit of interest - meaning people at...

LogRotate Policy For PostgreSQL

From Ajay Dwivedi's SQL Server Blog

Learn how to create a log rotation policy for postgresql logs based on size The post LogRotate Policy For PostgreSQL appeared first on Performance Tuning And Infra Automation.

Using Cron in Postgres Flex

From SQLServerCentral Blogs

pg_cron is a simple cron-based job scheduler for P...

Ernst-Georg Schmid: TRAKTOR 2 is out!

From Planet Postgres

Check TRAKTOR 2 - less complicated, more stable, cloud ready! Compatible with PostgreSQL 16 and 17.

PowerPivot/PowerQuery/PowerBI

Memory Overhead Of Distinct Count Measures In Power BI

From Chris Webb's BI Blog

The series of blog posts I wrote last year on sema...

Dynamic Pareto analysis in Power BI

From SQLBI

This article describes how to implement a dynamic ...

Dynamic Pareto analysis in Power BI

From SQLBI

Implement a dynamic Pareto calculation in Power BI...

Professional Development

The Rise of the AI Data Engineer

From Dataversity

Although it’s a rewarding career, the job of chi...

Inside-out learning

From Technology Review Feed - Tech Review Top Stories

When the prison doors first closed behind him more...

How to Tell When You're Working Your IT Team Too Hard

From IT Pro - Microsoft Windows Information, Solutions, Tools

Even the most dedicated IT team is vulnerable to b...

Leading Through Tech Workforce Changes

From IT Pro - Microsoft Windows Information, Solutions, Tools

As workforce reductions sweep through federal agencies and beyond, technology leaders face the difficult task of preserving capabilities and trust while making irreversible decisions.

AI Skills Gap Is Real — and Faking AI Fluency Won't Cut It Anymore

From IT Pro - Microsoft Windows Information, Solutions, Tools

As AI reshapes the tech landscape, a growing gap b...

Optimizing WordPress Performance: How to Analyze and Improve Your Website Speed

From https://chrisadkin.io

Improve WordPress performance with practical tips to test your site speed, optimize loading times, and deliver a faster experience for your visitors.

Security News and Issues

Android Improves Its Security

From Schneier on Security

Android phones will soon reboot themselves after s...

Odd Error with Contained Database Users - look out for your 3rd party vendors

From SQL DBA with A Beard

Introduction A contained user can create a Windows...

T-SQL and Query Languages

Introduction to SQL Commands, Part 2: Adding, Updating Data

From IT Pro - Microsoft Windows Information, Solutions, Tools

This installment of our three-part series on SQL c...

Exploring the SQL Server CHOOSE Function

From Simple Talk

I preface a lot of what I write with whether or no...

Introduction to SQL Commands, Part 3: Retrieving and Sorting Data

From IT Pro - Microsoft Windows Information, Solutions, Tools

In the final part of this series, learn how to use...

Can I Change a Primary Key Value? #SQLNewBlogger

From SQLServerCentral Blogs

I heard someone say recently that you can’t chan...

How SQL Server’s Compute Scalar Will Impede You

From No Column Name

Time to read: ~ 2 minutes Words: 417 Postgres Blogs We’re getting more and more Postgres instances at work. To get up to speed on Postgres, I’ve started to...

Tech News

Domain vs Hosting: A Jargon-Free Beginner’s Guide

From https://chrisadkin.io

Domain vs hosting: they’re not the same. Learn t...

Cheaper buildings, courtesy of mud

From Technology Review Feed - Tech Review Top Stories

One costly and time-consuming step in constructing...

Odd new tricks from a massive black hole

From Technology Review Feed - Tech Review Top Stories

In 2018 astronomers at MIT and elsewhere observed ...

How the brain, with sleep, maps space

From Technology Review Feed - Tech Review Top Stories

Scientists have known for decades that certain neu...

Bug-size robots that fly and flip could pollinate futuristic farms’ crops

From Technology Review Feed - Tech Review Top Stories

Tiny flying robots could perform such useful tasks...

Why we still need AM radio

From Technology Review Feed - Tech Review Top Stories

Ariel Aberg-Riger is the author of America Redux: ...

Reusable rockets are here, so why is NASA paying more to launch stuff to space?

From Ars Technica

Something appears to be broken in how NASA procures launch services.

The Lighter Side

XJSOML

From Daily WTF

When Steve's employer went hunting for a new custo...

Predicting Survivor winners with Python: Real-world modeling from 47 Seasons of Data

From AllAnalytics

Using 47 seasons of Survivor data, this analysis explores what gameplay traits correlate with winning, applying Python and SAS Viya Workbench to build predictive models. While stats like challenge...

Virtualization and Containers/Kubernetes

Securing the DevOps Pipeline Part 2: Hardening Kubernetes and Cloud Security

From Simple Talk

Strengthening Deployments and Runtime Protection I...

Kubernetes 1.33 'Octarine' Delivers Major Upgrades for Cloud-Native and AI Workloads

From IT Pro - Microsoft Windows Information, Solutions, Tools

The first Kubernetes release of 2025 introduces 64 enhancements — including sidecar containers, user namespaces, and advanced AI workload support — marking a new era of cloud-native "magic."

history

A 2,000-year-old battle ended in fire, and a tree species never recovered

From Ars Technica

An ancient Chinese army set fire to an enemy capital, but things got out of hand.

 
RSS FeedTwitter
This email has been sent to newsletter@newslettercollector.com. 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

 

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