I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But why keep this important visual warning at the bottom of the screen? In this post,...
2026-10-14 (first published: 2026-10-05)
554 reads
Here are the resources for my talk at Day of Data Boston. Slides – ArchitectingZeroDowntime.pptx Slides also at: https://dayofdata.org/2026-10-03-dayofdata1150/#schedule Code: https://github.com/way0utwest/ZeroDowntime Book: Refactoring Databases Some interesting questions. I’ll write...
2026-10-04
109 reads
I’ve covered the values in a number of previous posts on the Book of Redgate. Those values came from our founders, Simon Galbraith and Neil Davidson. I am lucky...
2026-10-02
59 reads
When the evidence names the database, it says so. When it doesn’t, it stops. Three databases have no recorded full backup. One backup job failed. Many tools would link...
2026-10-12 (first published: 2026-10-02)
203 reads
Making Data AI-Ready, Part 3 (This is the final article in a three-part series on making data AI-ready. Part 1 covered what AI-ready data means, Part 2 looked at...
2026-10-12 (first published: 2026-10-01)
333 reads
I recently attended SQLCon and FabCon Europe in Barcelona, and as you would expect, there was a LOT of talk about Fabric, Azure, AI, agents, Copilot, and where the...
2026-09-30
15 reads
I use ConEmu for my terminal interface. I’m still on Windows 10 at home, and for consistency’s sake, I run this on my Win11 laptop and the home machine....
2026-09-30
42 reads
Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built content in them takes a lot longer. Moving content to another workspace usually means redeploying...
2026-10-09 (first published: 2026-09-29)
417 reads
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the object history for different schema changes, so as you are evaluating how your changes might...
2026-10-09 (first published: 2026-09-28)
198 reads
Software is hard. While I love our Lucid Gravity, I realize that they are behind Tesla with software. A few of the weird UX and software engineering decisions they’ve...
2026-09-25
79 reads
By James Serra
(This is the third post in a three-part series on how AI is changing...
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
Comments posted to this topic are about the item Pay for Performance, which is...
I wrote about this several years ago but will contribute again a life hack...
Hi I have this query that is slow during the 'not in' part of...
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers