For better Sql code use fake tables
When unit testing code there is a really powerful feature that is either called mocking or faking or sometimes using...
2014-11-18
51 reads
Ed Elliott
For better Sql code use fake tables
When unit testing code there is a really powerful feature that is either called mocking or faking or sometimes using...
2014-11-18
47 reads
Unit tests help document your code!
I recently had the chance honour to spend twenty minutes talking to Boris Hristov about testing with Sql Server for his Google Hangouts series, catch the video here
One of...
2014-11-02
4 reads
Unit tests help document your code!
I recently had the chance honour to spend twenty minutes talking to Boris Hristov about testing with Sql Server for...
2014-11-02
62 reads
Unit tests help document your code!
I recently had the chance honour to spend twenty minutes talking to Boris Hristov about testing with Sql Server for...
2014-11-02
45 reads
What collation variables take on in T-SQL
I was asked an interesting question about collations in sql server recently about where variables in a script got their collation's from. I really wasn't too sure of the...
2014-10-22
8 reads
What collation variables take on in T-SQL
I was asked an interesting question about collations in sql server recently about where variables in a script got their...
2014-10-22
55 reads
What collation variables take on in T-SQL
I was asked an interesting question about collations in sql server recently about where variables in a script got their...
2014-10-22
41 reads
DBAs - Step away from production
I have worked as a DBA and also as a Sql Server developer and in many roles had full access to production, it is OK though I know what...
2014-10-21
3 reads
DBAs - Step away from production
I have worked as a DBA and also as a Sql Server developer and in many roles had full access...
2014-10-21
40 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