SQL Saturday
I've just received notice that I will be a presenter at the upcoming SQL Saturday event in Jacksonville, Florida. I'll...
2008-03-30
1,529 reads
Tim Mitchell
Give us SP3!
There has been a great deal of wailing and gnashing of teeth regarding the scuttlebutt that SP2 will be the...
2008-03-12
702 reads
We Are Microsoft Charity Challenge Weekend
This weekend, I had the unique opportunity to donate some time to a worthwhile charity organization. Through the efforts of...
2008-01-21
840 reads
On the Importance of Documentation...
It seems that I keep inheriting old systems that provide a singular, albeit mission critical, function to their owners. In...
2008-01-09
536 reads
Passed 70-431
After putting it off for six months, I finally took - and passed - 70-431 yesterday. I know, I'm probably one of...
2007-11-25
1,437 reads
PASS and new SSC design
I'm rarely a "needy" guy, but I have to admit that I'm feeling a little left out. Due to project...
2007-09-23
1,447 reads
Working in solitude
If you've spent much time at all reading Steve Jones's blog posts and SSC editorials, you quickly glean that he...
2007-07-12
1,484 reads
Gartner Developer Conference
It's been quite a week at the Gartner Application Development and Integration converence here in Nashville. I've never been to...
2007-06-13
2,003 reads
Webcast on exceptions and errors in SQL Server
When you have an hour to spare, jump over and view this useful discussion about errors and exceptions in SQL...
2007-05-21
1,447 reads
SQL Server SP2 released
Today, Microsoft released Service Pack 2 for SQL Server 2005. Though mostly a series of fixes for minor issues, there...
2007-02-19
1,426 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