How to Get Started with Always Encrypted for Beginners Part 2
In this post we will pick up where we left off in Part 1, if you haven’t read that please...
2017-12-29 (first published: 2017-12-13)
1,734 reads
SQLEspresso
How to get started with Always Encrypted for Beginners Part 1
Encryption has always been intriguing to me but seemed like it could be a very complex process to set up....
2017-11-29
1,313 reads
Thankful DBA
This week is Thanksgiving in the United States, so I thought it fitting to write a quick blog on what...
2017-11-22
408 reads
Do Not Pass GO!
What is the GO statement and why is it so important to use? When do I have to use it?...
2017-11-15
1,069 reads
What Are These Backup Settings All About?
I ran across a client the other day that had these Backup and Recovery options set like the picture below...
2017-11-08
811 reads
Quick Model Database Tidbit
Are you using your Model Database to its full potential?
I am finding more and more that Database Admins are not...
2017-10-30
736 reads
Synchronous VS Asynchronous Statistics Updates
One of the things I’ve been able to implement to help with performance is changing from Update Statistics Synchronous to...
2017-11-07 (first published: 2017-10-25)
1,820 reads
Does Your Code Have a Preamble?
Okay, here is a pet peeve of mine, I think every stored procedure, function, view etc. should all contain a...
2017-10-18
475 reads
Why I Go to Summit Each Year?
This year will be my 6thPASS Summit that I will have attended. Some people have asked me why I still...
2017-10-11
316 reads
SQL Sequence vs Identity Column
Let’s take a look at what a Sequence is in relation to an Identity Column in SQL Server. Did you...
2017-10-04
5,240 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