Prepping for Certification, Part 1 of ?
I thought it would be good to put my thoughts down on how to prepare for a certification. I don't know how many posts I will make on this,...
2025-09-26 (first published: 2025-09-04)
506 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
AI and Cybersecurity: the Genie is Out of the Bottle
Today's reality is that cybercriminals are increasingly using AI to develop better attacks. This is just the latest reported technique, probably because it's starting to be used more often....
2025-09-12 (first published: 2025-08-21)
240 reads
PASS Data Community Summit LinkedIn Contest
If you're not having success in convincing your organization to send you to this year's PASS Data Community Summit, you could win a 3-day registration by submitting some basic...
2025-08-29 (first published: 2025-08-12)
135 reads
New article: Automating SQL Server Builds
I refresh my test SQL Servers at least monthly with a fresh VM. Setting up directories, installing SQL Server, setting up security, and restoring databases all take time. And...
2025-08-28
79 reads
SQL Server 2025 Release Candidate Available
For those testing SQL Server 2025 before it officially releases, Microsoft has made the first release candidate available. There's a lengthy article on all the new features that are...
2025-08-26
133 reads
70 Years of Artificial Intelligence History in 15 Minutes
How long has AI been around in different domains? What was it called before we starting using the phrase, "Artificial Intelligence?" Is Clippy included in said history? Here is...
2025-08-22 (first published: 2025-08-05)
507 reads
Resource: Security Auditing for Databases
If you are responsible for securing databases, SQL Servers and others, I would strongly urge you to read the following post by Andreas Wolter, former data security PM for...
2025-08-18 (first published: 2025-07-30)
516 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
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
Blogs
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...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Forums
Huge frustration - Database watcher with two elastic pools
Think there's a reason why this is still in preview, but have someone manage...
SQL Server 2025 Query Performance Tuning: Troubleshoot and Optimize Query Performance
Comments posted to this topic are about the item SQL Server 2025 Query Performance...
Is it uncommon for Dev's to have a data model of the source data
This is a generic question. To the moderators, I wasn't sure where to place...
Question of the Day
Creating JSON I
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( 'City':'Denver') GOSee possible answers