I recommend Smart Brevity (book) for communications
Following the advice in Smart Brevity improves communication.
2026-01-06
19 reads
Blog Posts
Monday Monitor Tips: Native Replication Monitoring
Redgate Monitor has been able to monitor replication for a long term, but it required some work from customers. Now we’ve added native monitoring. This is part of a...
2026-01-05 (first published: 2025-12-15)
295 reads
Resetting on the AI hype train
There's a great article from MIT Technology Review about resetting on the hype of AI. AI's current state is somewhere between the die hard evangelists and the doomsayers
2026-01-05 (first published: 2025-12-19)
383 reads
Advice I Like: Pyramid Schemes
If someone is trying to convince you it’s not a pyramid scheme, it’s a pyramid scheme – from Excellent Advice for Living For sure. As much as I am...
2026-01-02
21 reads
Vibe Coding a Login Tracking System
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t do this natively, as this really needs an XEvent session. I decided to see if...
2026-01-02 (first published: 2025-12-17)
2,299 reads
Why Optimize CPU for RDS SQL Server is a game changer
One feature that I have been waiting for years! The new announcement around optimize CPU for RDS SQL Server is a game changer because it lets you right-size vCPUs...
2026-01-02 (first published: 2025-12-11)
530 reads
Patch Tuesday – Where to get more information
For a number of years I have subscribed to Randy Franklin Smith's Patch Tuesday newsletter. It tends to hit my inbox in the wee hours of Wednesday.
2025-12-31 (first published: 2025-12-10)
251 reads
T-SQL Tuesday #193 – A Note to Your Past, and a Warning from Your Future
I haven’t posted in a while (well, not here at least since I’ve been posting at the Straight Path Solutions site recently), but I did want to reply to...
2025-12-31 (first published: 2025-12-10)
319 reads
2025 Wrapped for Steve
I’ve often done some analysis of my year in different ways. Last year I had a series of posts (health, music, reading, speaking, travel). This year, I took last...
2025-12-29
22 reads
Flyway Tips: Automation Assistance in Flyway Desktop
I was chatting with the product managers at Flyway and one asked me whether I’d seen the new tab for Automation in Flyway Desktop. I hadn’t and decided to...
2025-12-29 (first published: 2025-12-08)
169 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Want to look at cloud reporting but not sure what the costs will be?
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
locking down agent for new user on our dev machine
hi , a new user wants to be able to add sql agent jobs...
SQL Server Enum Implementation: A Single-Row View Strategy for Avoiding Magic Values
Comments posted to this topic are about the item SQL Server Enum Implementation: A...
Question of the Day
BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers