Tech Books: Caveat Emptor
These days, we have a myriad of ways to judge whether any given product – like, say, a book on SQL...
2011-01-05
776 reads
SQL Awesomesauce
Invitation to T-SQL Tuesday #014
Hello and welcome to the first T-SQL Tuesday of 2011!
2010 was a great year for T-SQL Tuesdays, dreamed up and...
2011-01-04
1,289 reads
RTFM365, Week 4
The days are just flying. I have to admit: I may have missed a day or two in the rush...
2011-01-03
490 reads
Beginning Powershell Companion PDF
Howdy all…as is so often the case, I’m studying something – Powershell – and I’m in need of a reference to help...
2011-01-03
2,687 reads
2010 PASS Summit Interviews
It’s entirely fair to say that the highlight of my professional year is the PASS Summit in Seattle, and the...
2010-12-30
1,796 reads
Quick Thoughts on Learning
I’m looking for the attribution for a quote – it’s something I first heard from Sean, and we say it all...
2010-12-29
503 reads
T-SQL: CASE Statement
This is a companion piece to the MidnightDBA video T-SQL: CASE Statement.
In short, a CASE statement is a simplified set...
2010-12-28
2,710 reads
RTFM365, Week 3
Well, my brain has increased by 12.4% in terms of SQL knowledge this week, as a direct result of my...
2010-12-28
759 reads
PASS Summit Speaker Evals – THE ANALYSIS
Rule: No Sushi with Adam within 24 hours of session
I’m inspired by Brent Ozar‘s and Andy Leonard‘s sharing of their PASS...
2010-12-23
778 reads
RTFM365, Week 2 (AND week in review)
Hooboy…the super-structured format of the first two RTFM365 posts just isn’t sustainable for me. I’m going to have to go...
2010-12-20
662 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