T-SQL Tuesday #200: When I Look at a Query …
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound big, but this is a monthly party (started by Adam Machanic). We have 12 blog...
2026-07-07
40 reads
Understanding Microsoft Fabric OneLake Security
The idea behind Fabric OneLake Security (which GA’d on April 2026) is to centralize data access controls at the data layer, rather than configuring security separately for every Fabric...
2026-07-06
60 reads
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly invisible to many. Those countless sleepness nights are a testament to our dedication. Whether that...
2026-07-15 (first published: 2026-07-06)
631 reads
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is small enough to dump and restore in a maintenance window, or it isn't. Once you...
2026-07-15 (first published: 2026-07-03)
255 reads
A Spread of Vacation
I’m off on vacation today. Which is a little weird as I just got back from a week long vacation in May, cruising with my family. Usually my trips...
2026-07-03
30 reads
How AgentDBA Identifies Backup Failures
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of it, nobody’s fixed it, it’s just there — a handful of small compliance gaps that...
2026-07-03 (first published: 2026-07-02)
51 reads
Tip: Expanding a SQL statement
In all recent versions of the database you can call DBMS_UTILITY.EXPAND_SQL_TEXT to get the “true” version of a SQL that the database will run. It takes your SQL as...
2026-07-03 (first published: 2026-07-02)
110 reads
AI Helps Me with My Sloppiness
I type fairly well. Well, I type fast, but I do wear out a backspace key relatively quickly on most keyboards. That and a space bar. AI helps me...
2026-07-01
43 reads
WITH clause gets a 26ai boost!
By way of background, a while back I did video called “My New Favourite Join” on the LATERAL clause. The reason I like it is that it lets you...
2026-07-13 (first published: 2026-07-01)
607 reads
Mystery Backups: Estimating Disk Space When All You Have Are .BAK Files
How Do You Determine How Much Disk Space You Need If You’re Handed 18 SQL Server Backups and No History? Happy last day of June, dear reader. Today’s post...
2026-06-30
15 reads
Blogs
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Forums
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers