T-SQL Tuesday #189–AI and your Career
I’m late to the party this month. Taiob Ali has a great invite for a topic that is likely on most people’s minds: AI and your career. I constantly...
2025-08-13
53 reads
Blog Posts
Using SQL Compare to Revert a Stored Procedure
Imagine this situation, someone edits a stored procedure on a production server to “fix” something. However, they broke the procedure and you find out the next day. How do...
2025-08-13
127 reads
Boost SQL Server Security with gMSA: Real-World Examples & PowerShell Scripts
When deploying SQL Server in enterprise environments, choosing the right service account model is critical for security, manageability, and scalability. Traditionally, DBAs have relied on standard domain accounts with static passwords,...
2025-08-12
30 reads
Andreas Wolter on Evading Data Access Auditing
There are always bad actors who will seek to get access to and, likely, exfiltrate (exfil) the data. But they don't want to get caught; they don't want to...
2025-08-11
21 reads
Azure Arc in Action: Hybrid Cloud Management Made Easy
In today’s hybrid and multi-cloud world, managing SQL Server instances across diverse environments can be a daunting task. Enter Azure Arc—Microsoft’s game-changing solution that brings the power of Azure to...
2025-08-07
21 reads
How AI is Shaping Sustainable Textile Solutions
The textile world is undergoing a transformation, one where creativity meets computation, and tradition dances with technology. Artificial intelligence is not just automating processes; it is unlocking new dimensions...
2025-08-07
23 reads
Microsoft Exchange Hybrid Deployment Vulnerability – Shared Service Principal
On August 6, 2025, Microsoft announced a vulnerability with hybrid deployments because of a shared service principal between the Exchange on-premises deployment and Exchange Online. The vulnerability is found...
2025-08-07
41 reads
A Win in the Fight Against Cyber Scams
Back in June I blogged about pig butchering and the amount of reported losses we're seeing here in the United States of America. This type of cyber scam is...
2025-08-06
22 reads
Just a few weeks to PASS on Tour and the Redgate Summit
It’s just a few weeks until the PASS Summit on Tour in New York City. This is the first event in the series, and I’m excited to go back...
2025-08-06
11 reads
PostgreSQL Database Optimization: Shrinking Tables and Indexes Explained
PostgreSQL is a powerful open-source relational database system, but over time, its tables and indexes can become bloated due to frequent updates and deletions. This can lead to inefficient...
2025-08-05
53 reads
Blogs
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers