Changes to Service Packs and Cumulative Updates for SQL Server 2017
For a few years now, Microsoft has augmented its irregular release of Service Packs with a more frequent Cumulative Update...
2017-10-04
443 reads
Born SQL with Randolph West
Compañero Conference and SQL Modernization Roadshow
October is a busy month for me. I am flying all over the US and Canada for speaking engagements to...
2017-09-27
545 reads
Does rebuilding my clustered index also rebuild my non-clustered indexes?
I’ve been working with SQL Server for many years now, and up until recently, I assumed that rebuilding any clustered...
2017-09-20
433 reads
A trillion and one
Joe Obbish wrote an epic post a few weeks ago about loading a trillion rows into a non-partitioned table in...
2017-09-13
443 reads
Connect Windows 10 client to a VPN on Windows Server 2012 R2
I got a strange request in a Slack channel the other day. A colleague in South Africa, who uses Windows,...
2017-09-06
389 reads
What you need to know about memory limits on SQL Server
Last week, I posted this statement on Twitter, along with a screen capture of the official Microsoft documentation: Reminder: Max...
2017-08-30
343 reads
Speaking at SQLSaturday #635 in Vancouver this weekend
This coming weekend, at SQLSaturday #635 in Vancouver BC, I will be presenting a brand new talk about Temporal Tables,...
2017-08-23
122 reads
Microsoft presents: MySQL and PostgreSQL?
For the longest time, MySQL has been the recommended database platform for blogs and other websites. It’s free. It’s available...
2017-08-16
151 reads
This is how I recovered from a catastrophic failure
I was fresh off the boat* from South Africa, working in a small computer store in an equally small town...
2017-08-09
148 reads
Locks, Blocks, and Isolation Levels
Last week we looked at ACID compliance. This week we dive a little deeper into the Isolation portion, and what...
2017-08-02
131 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
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...
ROLLUP to calculate Month total for all Categories
Good Afternoon, I have built a table with four columns: Period(Month), Category, Numerator, Denominator....
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