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
 

My PASS Summit West 2026

I'm getting ready for Day of Data PNW, here in Portland tomorrow, November 7th, but In a few days I’ll be heading up I-5 to Seattle for PASS Summit West, November 9–11, and I’m excited for the week ahead!

Part of that is for the event itself.  PASS Summit West has a new home this year at the Hyatt Regency Seattle, with sessions, meals, the exhibit hall and evening events all under one roof. The shorter, three-day format means less running between buildings and more time for the hallway conversations that have always been the real heart of PASS.

The biggest part of the event is the people. This community has been part of my career for a long time, and every year I come home with new ideas, new friends and a reminder of why I still love this work. This year I get to give back with four sessions and a bonus event at the end of the week. Three of them circle the question I can’t stop thinking about: how do we bring AI into our databases without losing control of them?

Cleared for Takeoff: the Redgate keynote

Wednesday, November 11, 8:15–9:30 AM, Columbia Ballroom

Being part of a PASS keynote is an honor I don’t take lightly. I’ve been lucky enough to do the keynote for the last couple of years and this year, I’ll be on stage again with Steve Jones, Tushita Gupta, Chris Hawkins, James Murtagh, Shelby Vaught and Tom Hodgson for Cleared for Takeoff: Database Estate Governance and Control Alongside AI.

Most of us that will be in the ballroom aren’t managing one tidy database. We’re managing an estate with multiple platforms, half-finished cloud migrations, inconsistent processes and teams with very different skill levels. Now AI is landing on top of all of it, so our message is that you don’t have to choose between moving fast with AI and keeping control. With the right visibility and governance across the database lifecycle, you can do both, and do it with confidence.

AI;BDR: the Redgate AI Luncheon

Tuesday, November 10, 12:45–2:15 PM, Columbia Ballroom

Yes, the title is AI;BDR (AI; Because Didn’t Read), and yes, it’s based off of a twitter post that I saw. I’ll be on the panel with Kevin Feasel and Jonathan Stewart, and a luncheon makes it all the more fun.  People say things over a sandwich many things they might think twice about in a formal presentation room.

We’ll be tackling the question every data team is being asked right now, such as “when is it defensible to put AI into the data layer?” and  “When an AI agent or assistant queries a production database, what does it see, who invoked it, and where does that data go?” Observability, auditability and governance aren’t the exciting part of AI, but they’re the part that keeps you employed when something goes wrong. I want this to be an honest conversation about where AI is genuinely helping, where it’s being oversold, and how we make sure the people who built this industry aren’t left behind by it.

Who’s Really Logged In? Practical governance for AI

Tuesday, November 10, 4:00–5:15 PM, Room 405 Kachess

My third session, with John Martin, is where the governance conversation gets hands-on.

AI assistants and MCP servers are already connecting to production databases, often through a shared service account nobody quite remembers creating. We’ll walk through a realistic scenario where an AI’s access quietly grows beyond what anyone intended, and show the good practice at each step: giving every connecting entity its own identity, monitoring what it does, and setting security baselines. We’ll also cover the question you hope you never have to answer: after an incident, how do you work out what the AI assistant actually did?

These aren’t new problems. They’re the same identity, security and auditing questions DBAs have always handled, now moving at AI speed. That’s why I believe data professionals belong at the center of AI, not on the sidelines, and I want everyone to walk out with steps they can put in place the week they get home.

Living on a Floating Home: my Hobby Huddle

During lunch in the Community Zone on Wednesday

And then there’s the session that has nothing to do with databases at all, and more about my day-to-day lifestyle. It’s one of the new Hobby Huddles, informal mini sessions in the Community Zone where people gather over lunch to talk about life outside work.

I live on a floating home in Portland, Oregon. Whenever it comes up, the questions never end and hopefully I’ll answer some of them in this session.  Does it rock? What happens in a storm? How does the plumbing work? So I’m finally giving the whole story its own session. I’ll share what floating home life is really like, the good, the surprising and the parts nobody warns you about, and why I wouldn’t trade it for the world.

Community sessions like this are one of my favorite things about PASS. They remind us that we’re whole people, not just job titles, and some of the best connections I’ve made at this event started with a conversation about something other than work.

Day of Data Seattle, PG edition

When PASS wraps up, I’m not heading home just yet. On Friday, November 13, I’m staying for Day of Data Seattle, a free community event at the Seattle Public Library, with a focus on PostgreSQL this year.

My session there is about something I see more teams facing, which is how to keep your sanity when you’re migrating from SQL Server to PostgreSQL. On paper, it’s just one relational database to another. In practice, there’s so much to uncover. Unquoted identifiers fold to lowercase. T-SQL becomes PL/pgSQL. There’s no clustered index to lean on. Vacuum becomes part of your life. Habits that served you well for years suddenly work against you.

We're all learning PostgreSQL, so this will be a valuable session. PostgreSQL is a powerful platform with a passionate community, but a migration goes far better when you know where the surprises are before you hit them, and when you plan for the people side as much as the technical side. That’s what I want everyone to leave with: a clear map of what changes, and the reassurance that they’re not the first to find it hard.

See you in Seattle

Four sessions at PASS Summit West and a bonus day of Postgres afterward. It’s a full week, and I wouldn’t have it any other way.

At this point in my career, I get to choose where I spend my time and energy. I choose this community, because it keeps choosing to show up, share what it knows and lift each other up. If you’re going to be in Seattle, come find me: at the keynote, at the lunch table, in the governance session, at the floating home talk, or on Friday with the Postgres crowd. I’d love to hear what you’re working on.

Peace Out,

~DBAKevlar

 
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.
AI in the Database

AI Functions in the Fabric Warehouse

From Curated SQL

Koen Verbeeck shows off a few functions: We are bu...

AI-Written SQL: The Query That Ran and Lied

From Journey to SQL Authority with Pinal Dave

Part six of ten. AI-written SQL fails in a way that plain bad code never does. It runs, it returns a number, and the number is wrong. Here is...

AI/Machine Learning

How “reverse game theory” could keep AI agents in check

From Technology Review Feed - Tech Review Top Stories

A new approach known as “reverse game theory” ...

The Download: controlling AI agents and “Super Intelligence” loyalty tests

From Technology Review Feed - Tech Review Top Stories

This is today’s edition of The Download, our wee...

Testing AI Agent Skills

From Curated SQL

Eugene Meidinger and Ruben Van de Voorde try things out: Writing a skill takes time, and skills are context that can help but also hurt…

AI remakes IT work but puts the talent pipeline at risk

From IT Pro - Microsoft Windows Information, Solutions, Tools

AI can speed up IT work, but someone still has to ...

Administration of SQL Server

Using Batch Mode on Rowstore Indexes in SQL Server

From Curated SQL

Mehdi Ghapanvari speeds things up: SQL Server colu...

sp_CheckActivity

From Curated SQL

Andrew Kelly announces a new version of an old too...

SQL Server Limits, Verified: Eleven Records Pushed to the Edge

From Journey to SQL Authority with Pinal Dave

SQL Server limits, done the way a record book does...

Apache Iceberg

Amazon S3 Tables now offer managed migration of Apache Hive tables to Apache Iceberg

From AWS News Blog

You can now migrate existing Apache Hive datasets in Amazon S3 to fully managed Apache Iceberg tables in Amazon S3 Tables, with no pipelines to build or compute to...

Cloud - AWS

AWS Certifications for Data Professionals

From MSSQL Tips

Explore the AWS Certification Path for data profes...

Conferences, Classes, Events, and Webinars

Oversized on AWS. Undersized after the move. Both cost you.

Paying for AWS capacity you don’t use, or planning a move? Visit Redgate at AWS re:Invent, Booth 2138, or our talk (MAM420-S), Wed, Dec 2, 2:30 PM. Learn how to size, plan and cost cloud instances, and ship database changes faster.

DMO/SMO/Powershell

PowerShell Insights: IsSerialized, IsPublic & IsSynchronized

From Sid 500 PoSh

In this blog post, I will cover some less common topics in PowerShell. While they are not typically used in everyday scripts, they provide valuable insight into how objects...

Databricks, Spark, and Snowflake

Latest Snowflake blast targets trust in AI and efficient development

From IT Pro - Microsoft Windows Information, Solutions, Tools

Features such as Business Ontology and agentic cap...

MDX/DAX

Optimizing DAX with AI

From Sqlbi

Can AI optimize a DAX expression? Sure, it can. Ho...

Inside DAXBench v2: Results and Your Questions

From Sqlbi

How well do AI models write DAX? DAXBench is a public leaderboard that tests AI models on DAX tasks. Version 2 uses a new set of tasks that run...

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

Fabric Capacity Smoothing: Why This Morning’s Job Is Slowing This Afternoon’s Reports

From Purple Frog Systems

It’s 2pm on a Tuesday. Reports that normally load in a couple of seconds are crawling, a few users are complaining and the obvious question gets asked: what’s running...

Obituaries

In Memory of Hugo Kornelis

Hugo Kornelis passed away this week.

Oracle/MySQL/other RDBMS

The AI World 2026 mega download!

From Connor McDonald

Full disclosure: I cut/pasted this post from last ...

Oracle’s OCI expansion hints at where AI infrastructure is headed

From IT Pro - Microsoft Windows Information, Solutions, Tools

Oracle OCI updates at AI World pointed to infrastr...

Performance Tuning SQL Server

SQL Server Performance Office Hours Episode 93

From Erik Darling Data

SQL Server Performance Office Hours Episode 93 To ...

DOP and Tipping Points In SQL Server

From Erik Darling Data

DOP and Tipping Points In SQL Server Chapters 00:0...

The Top 10 SQL Server Wait Types, Worldwide

From Brent Ozar Unlimited

SQL Server uses wait stats to track what queries a...

PostgreSQL

Jimmy Angelakos: Establishing the PostgreSQL Standard: PGConf.dev 2026 Part Two

From Planet Postgres

Again, apologies for the delay. PGConf.dev was bac...

Making TOAST Work Better in Postgres

From Curated SQL

Shaun Thomas shares a story: The performance of th...

Dimitri Fontaine: Postgres logical replication beyond one writer

From Planet Postgres

In 2014, if you wanted Postgres servers on several...

DML in Postgres

From Curated SQL

Grant Fritchey tries out some syntax: Once your Po...

Ilya Kosmodemiansky: The “default” postgresql.conf

From Planet Postgres

Part 1 of 4: how PostgreSQL configuration works, a...

Jimmy Angelakos: PGConf.EU 2026 MEGAPOST: a busy week in Valencia

From Planet Postgres

This year's PostgreSQL Conference Europe, PGConf.EU 2026, took place from October 20th to 23rd in wonderful Valencia, at the Palacio de Congresos. There was far too much going on...

Ahsan Hadi: Zero Downtime In-Place Major PostgreSQL Upgrades on a Distributed PostgreSQL Cluster

From Planet Postgres

In my last post I walked through a rolling major version upgrade: add a brand new node on the new version, let it join the Spock cluster, retire the...

Power BI/PowerPivot/PowerQuery

Optimizing Power BI Semantic Models via Column Splitting

From Curated SQL

Phil Seamark provides some advice: Column splittin...

Copilot on the Power BI Report Canvas vs. Modern Report Builder

From SQLServerCentral Blogs

(This is the second post in a three-part series on how AI is changing the way we build solutions in Microsoft Fabric. The first post explored the new unified... The...

Professional Development

Peace, Purpose and the Next Book

From DBAKevlar

When I finished Crushing the IT Gender Bias, I tho...

SQL Server on Linux

Installing SQL Server on Linux

From Curated SQL

Dualcore DBA performs an installation: SQL Server ...

Virtualization and Containers/Kubernetes

Running containerd as a Kubernetes Container Runtime

From Curated SQL

Anthony Nocentino tries out containerd: This post ...

Everyone should just use SQL Server Containerization

From MSSQL Tips

Explore the advantages of containerization for SQL...

 
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

 

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