A New Word: Lilo
lilo– n. a friendship that can lie dormant for years only to pick right back up instantly, as if you’d seen each other last week – which is al...
2024-12-27
35 reads
Learning Database Design and Power BI Performance
I spend my days working on and managing SQL Server instances—working days at least, and sometimes even on non-working days. I’ve been working with SQL Server for years now,...
2025-01-08 (first published: 2024-12-24)
2,303 reads
Free SQL Training: Dive into Databases This December!
Want to learn SQL and get some real practice this December? Check out the Basic SQL Practice: A Store course – it's totally free for the entire month! This...
2024-12-25 (first published: 2024-12-24)
36 reads
Monday Monitor Tips: CIS Compliant
A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many enterprises think about as their auditors use this as a benchmark. If you’ve never looked...
2025-01-06 (first published: 2024-12-23)
333 reads
My 2024 in Data: Music
This is my last week of the year working (I guess I come back on the 30th for a minute), so I decided to do some analysis of my...
2024-12-20
33 reads
A New Word: Suente
suente– n. the state of being so familiar with someone that you can be in a room with them without thinking, without holding anything back, or without having to...
2024-12-20
38 reads
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to really learn, you need a project. I’m a DBA by trade and as such…haven’t really...
2025-01-06 (first published: 2024-12-20)
385 reads
My 2024 in Data: Health and Workouts
This is my last week of the year working (I guess I come back on the 30th for a minute), so I decided to do some analysis of my...
2024-12-19
18 reads
My 2024 in Data: Reading
This is my last week of the year working (I guess I come back on the 30th for a minute), so I decided to do some analysis of my...
2024-12-18
41 reads
Book Review – Agile Data Warehouse Design
I recently read the book Agile Data Warehouse Design – Collaborative Dimensional Modeling, from Whiteboard to Star Schema (quite the title) by Lawrence Corr and Jim Stagnitto. The book...
2024-12-30 (first published: 2024-12-18)
1,200 reads
Blogs
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
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 ...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
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...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers