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
274 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
58 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
62 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
35 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
52 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
43 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
132 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
40 reads
Blogs
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
Forums
AllocationType as ROW_OVERFLOW_DATA
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
is it true we cant debug c# scripts in ssis anymore under vs
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
Question of the Day
Missing the Jaro Winkler Distance
I upgraded a SQL Server 2019 instance to SQL Server 2025. I wanted to test the fuzzy string search functions. I run this code:
SELECT JARO_WINKLER_DISTANCE('tim', 'tom')
I get this error message:Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.What is wrong? See possible answers