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
 

Let's Talk Community Events!

It’s conference season for many of us who spend our time traveling and attending events. I have attended conferences in the past, but always in a secondary role; I was still primarily a DBA and team manager. I attended events to network with others and stay up to date on new technologies. Now I spend my time networking and training others on new technologies or ideas.  

Attending an event for DB professionals is not just about learning something new; it provides perhaps the most important thing you can have for your career. A Network. Your network will decide in the future how easily it is for you to get a job, work on other projects, perhaps receive contracts for future work, and generally increase your social circle and better your life.  

I know a lot of people say this, but I’ve seen it firsthand, not only for myself but also for many of the professionals I work with. I’ve had friends let go by companies due to layoffs or reorgs, and those individuals could reach out to me and others. This meant they could be back at work in just a few days, rather than weeks or months.  

Just as you need to learn new skills to be productive at work, you need to cultivate and improve your network. To do that, you need to reach out and meet people at events, whether that’s local user groups, regional events, or large summits. 

I urge everyone to find your local Day of Data, User group/Meetup, or attend the Large PASS Summit later this year. Do this before something in your career changes your situation. It will make all the difference in your future.  

One last thought: if you are interested in putting on an event and helping others, please reach out to me! I will happily sit down and guide you through everything you need to get ready for an event.  

Pat Wright

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

Safe Database Change at Scale with Flyway Enterprise

How do teams keep database change safe, controlled, and traceable as AI-assisted coding increases the pace of delivery? Redgate Flyway Enterprise builds the necessary controls, visibility, security checks, and traceability, directly into the database change process, so every change follows a controlled and verifiable path from commit to deployment.

How to find the PII hiding in your database

Column names lie about what's inside. Redgate's AI Classification scans your actual data to catch PII that metadata rules miss, all locally.

How to define your monitoring requirements (before you talk to a vendor)

Choosing the right database monitoring vendor isn’t just a technical decision, it’s a strategic one that affects your teams, your estate, your growth plans, and the culture of your organisation. It’s also a personal one if you’re a DBA. Something as critical as your monitoring system will shape your day-to-day work, and, in many cases, how well you sleep at night.

AI/Machine Learning/Cognitive Services

Local vs remote MCP servers – which should you choose?

MCP (Model Context Protocol) servers let AI apps access real-time data and external tools, improving accuracy beyond static model knowledge. Choosing between local and remote MCP servers affects security, scalability, and integration. In this article, learn all about these servers and which to choose for your use case.

When, and when not, to use LLMs in your data pipeline

Drawing on real-world experience building large-scale ML systems, this guide breaks down exactly where LLMs belong in your data pipeline and, just as importantly, where they don’t.

Local vs remote MCP servers – which should you choose?

From Simple Talk

MCP (Model Context Protocol) servers let AI apps a...

The Challenge of AI in Business Today

From DBAKevlar

Outside of my work at Redgate, I spend an hour or ...

Most AI Initiatives Don’t Fail for the Reason You Think

From Sherpa of Data

Over the past few weeks, I’ve been writing about...

This tool could show how consciousness works

From Technology Review Feed - Tech Review Top Stories

How does the physical matter in our brains transla...

The Download: introducing the 10 Things That Matter in AI Right Now

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. Introducing: 10 Things That Matter...

AI at MIT

From Technology Review Feed - Tech Review Top Stories

At MIT, AI has become so pervasive that you can a...

Administration of SQL Server

Advanced T-SQL Triage: I’m Running a Full-Day Pre-Con in Jacksonville

From Erik Darling Data

Advanced T-SQL Triage: I’m Running a Full-Day Pr...

SQL Server Monitoring Across Cloud, Hybrid, and On-Prem

From Journey to SQL Authority with Pinal Dave

Let us talk about SQL Server Monitoring Across Cloud, Hybrid, and On-Prem. This is not a tooling problem. First appeared on SQL Server Monitoring Across Cloud, Hybrid, and On-Prem

Conferences, Classes, Events, and Webinars

T-SQL Tuesday #197 – An impactful session or two from a conference – RECAP

From Data on Wheels (Steve Hughes)

Thanks to everyone who joined the blog party this ...

Data Mining / Data Analysis

How to handle large datasets and parallel processing in esProc SPL

Learn how to tackle one of the most challenging aspects of data analysis: handling datasets that are too large to fit into memory.

Database Design, Theory and Development

The Human Infrastructure: How Netflix Built the Operations Layer Behind Live at Scale

From Netflix TechBlog - Medium

By: Brett Axler, Casper Choffat, and Alo LowryIn ...

General

On Speaking Well

Professor Patrick Winston of MIT used to give a one-hour talk about how to speak. Though Professor Winston is no longer with us, his talk still is. If you want to get better at speaking, even if you’re an experienced speaker, I recommend taking the hour to watch the recorded video:

PostgreSQL

Chao Li: Understanding PostgreSQL REPACK Through repack.c

From Planet Postgres

REPACK is a new PostgreSQL 19 feature for physical...

Richard Yen: The Postgres Performance Triangle

From Planet Postgres

Everyone who’s gone at least knee-deep in photog...

Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 19 – Add CONCURRENTLY option to REPACK

From Planet Postgres

On 6th of April 2026, Álvaro Herrera committed pa...

Enforcing Constraints across Postgres Partitions

From Curated SQL

Shaun Thomas explains a rule: Postgres table parti...

Antony Pegg: Introducing the AI DBA Workbench: PostgreSQL Monitoring That Diagnoses, Not Just Reports

From Planet Postgres

PostgreSQL is dominating the database market, and the monitoring tools haven't noticed.More teams run Postgres in production every year. More of those deployments are distributed, multi-region, and mission-critical. And...

Christophe Pettus: All your GUCs in a row: allow_system_table_mods

From Planet Postgres

Here is a GUC that ships with a warning label. The docs, which are normally restrained to the point of parody, state plainly that setting this parameter wrong can...

SQL

The second (and most important) software test

From Dr SQL

There is an old computer science adage that the so...

 
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

 

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