Data Warehousing Explained
Why Warehouse
Data warehousing is the act of transforming application database into a format more suited for reporting and offloading it...
2017-05-14
273 reads
Gavin Draper
Using The SQL Server Merge Statement
Note : Since publishing this I’ve been notified that there are a number of outstanding issues with the SQL Server merge...
2017-05-08
57 reads
SQL Server Dynamic Pivot
Often when trying to pivot data you wont know what the possible values that you need to pivot on, in...
2017-05-07
61 reads
Using JSON In SQL Server 2016
The new JSON bits in SQL Server 2016 give you the ability to pull stuff out of JSON and to...
2017-05-06
93 reads
C#7 Show Me The New Stuff!
I’m going to walk through an example that we can build up and improve with a number of the new...
2017-05-05
34 reads
SQL Server Pivot and Unpivot Explained
The Pivot and Unpivot features in SQL Server are I find quite underused. For a long time I got by...
2017-05-04
51 reads
Why CROSS APPLY is AWESOME
CROSS APPLY was introducted as part of TSQL in SQL Server 2005. Origionally it was created as a way to...
2017-05-03
42 reads
Switch Your Site To HTTPS Using CloudFlare
SSL All the Things
Browsers are starting to highlight sites without SSL as insecure in a bid to push everyone to...
2017-04-26
131 reads
SQL 2016 Temporal Tables By Example
Brief Description
Temporal tables allow automated change tracking of a table directly in to a history table which can be queried...
2016-04-15
77 reads
.Net CLI Cross Platform Awesomeness
.Net CLI is the new tooling that sits in front of .Net Core, allowing you to create and run projects...
2016-02-07
39 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