SQL Server Management Data Warehouse (MDW) – Why it Rocks
Ensuring excellent performance for users and customers is a high priority for Database Administrators.
Today I want to share a free and easy...
2013-04-16
2,488 reads
John Sansom
SQL Server Management Data Warehouse (MDW) – Why it Rocks
Ensuring excellent performance for users and customers is a high priority for Database Administrators.
Here I share a free and easy way for you to get valuable insight into the...
2013-04-16
141 reads
Implicit Conversions and Avoiding Them With Computed Columns
I recently encountered an interesting performance issue (due to implicit conversions) that I was able to solve using a lesser known...
2013-04-02 (first published: 2013-03-25)
3,965 reads
Implicit Conversions and Avoiding Them With Computed Columns
I recently encountered an interesting performance issue (due to implicit conversions) that I was able to solve using a lesser known technique and I wanted to share it with...
2013-03-25
28 reads
How To Be An Expert At What You Do
Every successful company has them. They’re the lifeblood of their organisations. Linchpins essential to getting things done and doing them...
2013-03-20
1,040 reads
Career Growth and How You Can Achieve Explosive Results
Continued investment in your professional development for career growth is hard. It’s also essential to being a successful Data Professional.
You’ve...
2013-03-05
1,510 reads
Something for the Weekend – SQL Server Links 01/03/13
It’s SFTW Time, I hope you’ve had a great week!
Make sure you don’t miss this weekly round-up of SQL Server...
2013-03-01
1,067 reads
Restart the SQL Server Agent Service using PowerShell
Just a quick one today chaps, to show how you can restart the SQL Server Agent Service using PowerShell.
Whilst covering...
2013-02-26
4,845 reads
Multitasking A Ridiculous Workload – How I Do It
I don’t! There’s no such thing as multitasking. At least, not how most of us think about it……
Being successful as...
2013-02-19
960 reads
Overconfidence – How it Almost Cost Me and What You Can Do to Avoid It
It was early one morning and I was working on a production deployment to add a new Subscriber to an...
2013-02-15 (first published: 2013-02-05)
3,767 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
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....
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:...
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