Has SQL Server Performance Improved?
This week Steve found a question of whether SQL Server 2019 uses more CPU than 2016.
2023-04-01
714 reads
Editorials
Building a Better Profile
Steve thinks building a brand is important in today's competitive world of job seekers.
2023-03-31
124 reads
Being Responsible for Data
There is an interesting court case on who is responsible for the data being posted on the Internet. Steve has a few thoughts today.
2023-03-29
272 reads
2023-03-27
314 reads
Review Early and Often
Several years ago, I was brought in on a project to review a database design. I was provided a time for a meeting. No written requirements were available, but I generally knew what the system was supposed to do. No before/after schema images showed what was being changed were available. Still, I was assured that […]
2023-03-25
108 reads
How Important is Zero Downtime?
Zero downtime used to be more important in Steve's job, but lately it seems customers aren't as concerned.
2023-03-24
119 reads
What's a Code Smell?
Poor patterns and practices are code smells. Steve Jones notes we have plenty in T-SQL.
2023-03-22 (first published: 2015-10-05)
564 reads
Metrics and Measures
We need to measure and monitor things to become better, but we need to keep an eye on what the actual goal is from this monitoring.
2023-03-20
153 reads
The Human Factor
A week ago I was in Pasadena attending the SCaLE 20x conference, a gathering of many different open-source communities discussing the technologies and platforms that draw them together. I was fortunate enough to hear some excellent presentations on PostgreSQL and give two talks as well. After the first round of talks on Friday morning a […]
2023-03-18
92 reads
Annual Security Compliance Training
A guest editorial from Andy Warren that looks at annual training to try and improve security.
2023-03-17 (first published: 2015-08-21)
191 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