Influence Skills: Live From London Day 3
The main news this morning: Wales' heroic efforts at the Euros came to end last night with a 2-0 defeat...
2016-07-07
380 reads
Blog Posts
Managing migrations with RedGate SQL Source Control 5
This is a good day for me. I’ve finally tried the improved migrations feature in the latest version of RedGate SQL Source Control ...
2016-07-07 (first published: 2016-06-30)
2,775 reads
SQL Server and Continuous Integration
This is the 1st in a series of posts on SQL Server and Continuous Integration. Some of the tools I’ll be...
2016-07-07
752 reads
Tempdb monitoring - Free space alert
SQL Server uses tempdb for many features, including row versioning, service broker and query execution amongst others. During the execution...
2016-07-07
3,828 reads
T-SQL Tuesday #080
T-SQL Tuesday time is here again! And I’m honored to be hosting this months block party. Why you ask? T-SQL...
2016-07-07
915 reads
Using sp_executesql Parameters –#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-07-07
877 reads
Virtualization does not equal a private cloud
I see a lot of confusion when it comes to creating a private cloud. Many seem to think that by...
2016-07-07
1,354 reads
Zilch to Speaker: 2016 Summit Abstract Reviews
Steve Jones (b/t) has been asking people to post their Pass Summit submissions and the reviews that came back, along...
2016-07-07
445 reads
CASE Statement in GROUP BY
Set based operations means you should put everything into a single statement, right?
Well, not really. People seem to think that...
2016-07-06 (first published: 2016-06-28)
4,819 reads
Do you have Influence? Live from London Day 2
Live from London Day 2
In the most important news of the day, Wales play Portugal in the semi-final of the...
2016-07-06
479 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