At Redgate, we’re experimenting with how AI can help developers and DBAs become better at their jobs. Everyone is asking for AI, as well as the ability to turn...
2026-02-02 (first published: 2026-01-23)
25 reads
I was messing around performing investigative work on a pod running SQL Server 2025 in Kubernetes the other day and noticed something…the sqlservr process is no longer PID 1...
2026-02-02 (first published: 2026-01-23)
68 reads
Leave a gate behind you the way you first found it. – from Excellent Advice for Living This is a ranch rule. Leave something as you found it. If...
2026-01-30
11 reads
Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes
After tempdb, msdb is often the most abused system database, growing unchecked until it tanks...
2026-01-30
18 reads
I’m not trying to start up a debate whether you should use tabs or spaces when indenting code. Personally, I prefer spaces because when I copy the code to...
2026-01-30 (first published: 2026-01-19)
395 reads
Organizations increasingly want Snowflake and Microsoft Fabric to coexist without duplicating data or fragmenting governance. With Fabric OneLake and open table formats like Iceberg and Delta, there are now...
2026-01-30 (first published: 2026-01-29)
44 reads
I was listening to the radio the other day and the hosts were discussing the NFL playoffs in 2026. Someone mentioned the winningest coach was Nick Sirianni of the...
2026-01-30 (first published: 2026-01-21)
121 reads
In a previous post, I deployed a model to a database using SQL Compare 16. This used a new feature in that connects to Redgate Data Modeler. In this...
2026-01-28
23 reads
I remember a meeting where a client’s CEO leaned in and asked me, “So, we have tons of data… Why can’t we just add AI and call it a...
2026-01-28 (first published: 2026-01-14)
237 reads
Last week I spent a few days in Cambridge, UK for the Redgate Company Kickoff. I landed at 1130a Monday and flew away at 1215p Thursday. I wish I...
2026-01-28 (first published: 2026-01-26)
16 reads
By Steve Jones
Leave a gate behind you the way you first found it. – from Excellent...
By SQLPals
Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes ...
By James Serra
Organizations increasingly want Snowflake and Microsoft Fabric to coexist without duplicating data or fragmenting...
Comments posted to this topic are about the item 25 Years of SQL Server...
Comments posted to this topic are about the item The Decoded Value
Comments posted to this topic are about the item Deploying SQL Server Developer Edition...
In SQL Server 2025, what is returned from this code:
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(CAST(@message AS VARBINARY(1000))); SELECT BASE64_DECODE(@encoded)See possible answers