What I Will Do For You in 2012
Many of you have first hand experience of our phenomenal sql community (affectionately labelled the #sqlfamily).
Your first encounter with it...
2012-01-09
600 reads
John Sansom
Start 2012 with Your Best of 2011
The first week following on from the Christmas break is a very hectic one for us Data Professionals.
Your customers are...
2012-01-03
622 reads
Why Did You Start Blogging?
That’s easy, because Brent Ozar (Blog|Twitter) challenged me to……
Finding time to keep up with awesome blog content can be tough....
2011-12-15
653 reads
SQL Server MVP Deep Dives Volume 2 – My Review
Volume 1 was packed full of knowledge and a very welcome edition to my bookshelf! With the bar already set...
2011-12-09
840 reads
What Makes The Perfect DBA Role?
What is it that makes the perfect role for a Database Administrator?
Well I can’t tell you that because you and...
2011-12-07
1,307 reads
What Every DBA Should Get For Christmas
What is a brilliant gift at Christmas for a DBA? I mean apart from having the day off…..
For those new...
2011-12-05
582 reads
New Year New Job?
Are you 100% satisfied with your current job? Of course not!
When given serious consideration most people will agree that there...
2011-11-28
920 reads
Being an Effective DBA Remotely
Do not let the phrase “out of sight, out of mind” apply to you.
As Data Professionals a lot of us...
2011-11-01
1,125 reads
SQLRelay Just Got Bigger Folks – The King is Back
Return of the King?
As if the original week of action planned was not enough SQLRelay just got Bigger!
Three brand new...
2011-09-07
749 reads
My Guide to Passing MCTS Exam 70-432
A reader wrote in to me last weekend regarding the MCTS Exam 70-432 (SQL Server 2008, Implementation and Maintenance).
Hi John,
I...
2011-09-05
2,388 reads
Blogs
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
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...
Forums
SQL Server 2025 Query Performance Tuning: Troubleshoot and Optimize Query Performance
Comments posted to this topic are about the item SQL Server 2025 Query Performance...
Is it uncommon for Dev's to have a data model of the source data
This is a generic question. To the moderators, I wasn't sure where to place...
ROLLUP to calculate Month total for all Categories
Good Afternoon, I have built a table with four columns: Period(Month), Category, Numerator, Denominator....
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