My SQL Server Management Studio Setup
We’re all creatures of habit, and work more efficiently when we know exactly where to find the tools we need....
2017-12-18
337 reads
Tim Mitchell
Some Thoughts on Community, Leadership, and Continuous Improvement
The SQL Server community is just awesome. I can’t say that enough. I may sound like a broken record when...
2017-12-17
370 reads
The Value of Shortcuts
Decades ago when I was working as a retail clerk, I had a boss named Billy. Billy was a pragmatic...
2017-12-16
413 reads
To Learn, Teach
Back before I started doing technical presentations or writing blog posts, I frequently found myself in awe at those who...
2017-12-15
601 reads
Picking The Right Team
Years ago, back before I became a consultant, a job search led me to an interview with a technical company....
2017-12-14
411 reads
The Value of Consistent Design
Yesterday I wrote about best practices, illustrating that what may be an assumed technical design standard doesn’t fit every scenario....
2017-12-13
397 reads
When Best Practices Aren’t Best
Most everyone is familiar with the term best practices. This phrase describes an industry-specific design or methodology that can be...
2017-12-12
388 reads
The Eleven Days of Festivus 2017
Last year, I celebrated the holiday season by blogging daily during the 11 days leading up to Festivus, writing about...
2017-12-12
315 reads
The One Piece of Career Advice I Wish I’d Gotten
Over the years, I’ve been approached numerous times with requests for advice from folks who are looking to get started...
2017-12-12 (first published: 2017-11-29)
2,519 reads
Long Live OLE DB!
Back in August of 2011, an announcement from Microsoft started a wave of angst among those who build and support...
2017-11-20
357 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