A "Clawdbot" in every row with 400 lines of Postgres SQL - calebwin/pgclaw

A database should contain all observable objects as system views. An introduction to how Floe Database handles system views.

It's an overcast afternoon at Atlantis Paradise Island in the Bahamas, so since I can't go into the water, might as well go through your top-voted questions from Here's what we covered: 00:00 Start 00:48 jrl: What makes a good Office Hours question? 01:22 Nils: Do you have any experience with Babelfish or similar tools to migrate from SQL Server to PostgreSQL or another DMBS.

Announcing Free SQL Server Performance Monitoring I built a free, open-source SQL Server performance monitoring tool. Two editions, no licensing fees, no telemetry, no cloud dependency. Here’s what…

Two big sets of news this month! The Consultant Toolkit now supports imports to a database so you can track your clients' health and performance over time, and sp_BlitzCache has a new @AI parameter. Set @AI = 1, and get a prompt you can copy/paste into the AI of your choice to help you tune the query. Set @AI = 2, and we'll actually call ChatGPT or Google Gemini for you and return the advice.

SSMS extension - Color and name tabs by environment - Blake-goofy/SSMS-EnvTabs

For SQLBits this year, I wanted to submit a performance tuning session about one of the most classic, timeless problems I run into: why is the same query fast in development but slow in production? All of my regular readers - if there is such a thing - are now yelling out, "Parameter sniffing!" And yes, that's the most common cause, by far!

Tech roles are changing rapidly due to AI coding advances. You shouldn’t be using AI to write production SQL code without incredibly heavy review and revisions, but you should be using it to…

SQL Server 2016 goes end of life on July 14, 2026. That's five months from now. If you're still running 2016 in production, you're not a...

The 1970s oil crisis changed cars forever. Gas shortages were so big that General Motors developed a car that used a turbine that burned coal

GitHub Copilot is a service, you can buy subscription from here https://github.com/features/copilot.GitHub Copilot is available from website https://github.com/copilot together with services like…

On the world's largest floating electronic dance music festival, I took your top-voted database questions from Here's what we covered: 00:00 Start 01:54 Frost: What is your opinion on Group Managed Service Accounts? 04:09 Elwood: What AI tool or skills do you recommend learning for DBAs to stay relevant? 07:59 GSurgeon: What are the telltale signs that a database has flaws?

I was about to walk out the door to take a flight, when my phone rang. Our major software system we had just released last week was returning weird data. FirstName and LastName was being reversed. …

For many over the years, they didn’t choose their role. The Accidental DBA was a recognised path into the profession. With platforms and skills changing, I thought it worth asking – are…

A long time ago in a galaxy far, far away, SQL Server Management Studio was included as part of the SQL Server installer. Back then, upgrading SSMS was not only a technical problem, but a political one too. Organizations would say things like, "Sorry, we haven't certified that cool new SQL Server 1982 here yet, so you can't have access to the installer." Developers and DBAs were forced to run SSMS from whatever ancient legacy version of SQL Server that their company had certified.

In China, we picked one of these up: Some people call it a tri-fold, which isn’t right – it’s only got two folds in it. When it’s folded up like a Z, you have a reasonably s…

In China, we picked one of these up: Some people call it a tri-fold, which isn't right - it's only got two folds in it. When it's folded up like a Z, you have a reasonably sized phone: It's thick, but not unreasonably thick. It still fits easily in a pocket, and it's about the same thickness as the single-fold Samsung Galaxy phones I've handled, or as thick as two iPhones on top of each other.

SQL Server Availability Groups can be a great feature to help support your High Availability needs, but what happens when they fail to work as expected? Do you have an expiring certificate on used by…

Is your company hiring for a database position as of February 2026? Do you wanna work with the kinds of people who read this blog? Let's make a love connection. If your company is hiring, leave a comment. The rules: Your comment must include the job title, and either a link to the full job description, or the text of it.

A Flappy Bird game implemented entirely in SQL Server - Best2Two/SQL-FlappyBird