T-SQL Tuesday #119 – Changing My Mind
This post is for the most recent #tsql2sday, a monthly exercise where a topic is proposed by a community member and everyone is invited to post their thoughts on...
2019-10-08
8 reads
DesertDBA
- Website: https://desertdba.com
How I applied 13 cumulative updates in 12 minutes
Twitter is a strange place. I mean, aside from all the outrage practice and animal videos. Last week I sent out a tweet about how I used dbatools to...
2019-10-04
7 reads
Find and fix that troublesome Windows Power setting
For the most part, the default configurations for SQL Server are pretty good. Yeah, there are a few you should definitely change (like say, the ones involving parallelism), but...
2019-08-30
10 reads
Find and fix that troublesome Windows Power setting
For the most part, the default configurations for SQL Server are pretty good. Yeah, there are a few you should definitely change (like say, the ones involving parallelism), but...
2019-08-30
7 reads
For those who want to be a Junior DBA
I’ve been fortunate to have spoken at a few SQL Saturday events this year, and one of the sessions I’ve had the pleasure of presenting has been about getting...
2019-08-01
7 reads
For those who want to be a Junior DBA
I’ve been fortunate to have spoken at a few SQL Saturday events this year, and one of the sessions I’ve had the pleasure of presenting has been about getting...
2019-08-01
7 reads
So, my first SQL Saturday presentation had some issues
It’s been a while since I’ve had a new post here, and that’s largely due to the quantity of other things on which I’ve been working. This list of...
2019-04-19
7 reads
So, my first SQL Saturday presentation had some issues
It’s been a while since I’ve had a new post here, and that’s largely due to the quantity of other things on which I’ve been working. This list of...
2019-04-19
3 reads
Central Management Server – not just three boring words
Maybe more people would use the Central Management Server feature of Management Studio if it had a name that didn’t sound as utilitarian as a heat pump. Something like...
2019-01-28
6 reads
Central Management Server – not just three boring words
Maybe more people would use the Central Management Server feature of Management Studio if it had a name that didn’t sound as utilitarian as a heat pump. Something like...
2019-01-28
10 reads
Blogs
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...
Monday Monitor Tips: SQL Auditing Preview
By Steve Jones
One of the features we advocates have been advocating for is a better way...
Forums
Level 28: DAX Text Functions: The DAX Extract & Modify Functions: LEFT(), RIGHT(), MID(), REPLACE(), SUBSTITUTE()
Comments posted to this topic are about the item Level 28: DAX Text Functions:...
Creating JSON I
Comments posted to this topic are about the item Creating JSON I
Expensive CPUs
Comments posted to this topic are about the item Expensive CPUs
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