SQL Saturday 103 Recap
SQL Saturday 103 was in Curacao, a beautiful Dutch Island in the Caribbean. I was fortunate enough to be able...
2012-03-14
622 reads
Tim Radney
Find the version of the Master DB from a backup
Try researching recovering the master database online and you will see countless references to having to have SQL at the...
2012-01-25 (first published: 2012-01-20)
3,018 reads
SQL Server Login Auditing
In recent months I have been asked to ensure we are auditing both successful and failed logins, not just failed...
2012-01-05 (first published: 2012-01-03)
2,887 reads
Increase SQL Server Error Log Files
Recently I learned that you can and probably should increase the number of SQL Server Error logs that your instance...
2012-01-04 (first published: 2011-12-30)
4,046 reads
RedGate SQL Index Manager BETA
I recently attended the first micro training event with Red Gate where Grant Fritchey demonstrated a BETA tool called SQL...
2011-12-29
2,552 reads
First Blog Since the PASS Summit
The time following the PASS Summit has been absolutely crazy for me. Upon returning home I spent some much needed...
2011-12-08
542 reads
When training is just that good!
I have the privilege of attending SQL Skills Immersion Event week one in Atlanta GA this week. My expectations were...
2011-12-08
505 reads
Summit Sessions Day 2
Day two of sessions only had me attending three sessions. One of them was 3 hours. I started out after...
2011-10-15
604 reads
Summit Sessions Day Three
I started out day three after the keynote by attending Adam Machanic session on Query Tuning. I must say that...
2011-10-15
610 reads
Final Summit Keynote – NoSQL = Not Only SQL
The keynote started out with Rob Farley and Buck Woody singing an awesome song about a slow running query. What...
2011-10-14
1,623 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