Attend the PASS Summit From Home
You there, sitting in your cube and fuming at all the PASS Summit talk: you couldn’t talk your company into...
2010-11-01
878 reads
SQL Awesomesauce
A Little SSMS Wish
IN SQL Server 2000, we didn’t have the fancy-schmancy Management Studio…we had Enterprise Manager and Query Analyzer, and we liked em,...
2010-10-27
518 reads
SQL Saturday #56 BI Edition Wrap-up
On Saturday I (unexpectedly) presented at Dallas’ first Business Intelligence-focused SQL Saturday at the Microsoft campus in Irving. I wasn’t on...
2010-10-25
1,506 reads
SQL Saturday #56 – The 24 hour Challenge
SQL Saturday #56, Dallas BI edition, is tomorrow. Last night before the NTSSUG meeting, we had an unusually high number of...
2010-10-22
795 reads
Ground Zero Database Design: Part 2
Last week I wrote Ground Zero Database Design, thinking that was a good enough bare-bones intro (with recommended reading!) that...
2010-10-20
738 reads
SQLKilt / WIT Shirts
This shirt was specifically requested by an online friend who shall remain nameless (his name rhymes with “Duck Hoodie”). Another...
2010-10-20
1,099 reads
Inappropriate PASS Sessions – nearly SOLD OUT!
If you want to get into the Inappropriate PASS Sessions event during the PASS Summit in Seattle this year, you’d better...
2010-10-15
608 reads
Inappropriate PASS Sessions – SOLD OUT!
I’m sorry, but the Inappropriate PASS Sessions event (an after-hours event during the PASS Summit in Seattle) is SOLD OUT.
This all...
2010-10-15
746 reads
S-3-X Talk Week: Wrapup
Image is conjecture; accuracy of percentages not guaranteed (but likely)
We’ve discussed thinking about 53x (Women: whenever it comes up; Men:...
2010-10-15
589 reads
Ground Zero Database Design
All the SQL world should take database modeling classes, and thrive in the light of well-designed data structures. Back in...
2010-10-14
643 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