Learning SQL Server 2014
A list of technologies in SQL Server 2014 that you might want to learn more about.
2015-06-29
1,646 reads
SQL Server 2014
Learning about the Cardinality Estimator
A few links to help you understand the Cardinality Estimator.
2015-06-29
319 reads
SQL Server 2014 Build List
A list of builds for SQL Server 2014, through CU4 for SP2 and CU11 for SP1.
2023-02-17 (first published: 2015-02-23)
19,461 reads
2015-02-19
1,789 reads
2014-10-20
1,540 reads
Natively Compiled Stored Procedures: What they are all about
What are natively compiled stored procedures? Why would we want to use them and what are the performance benefits of using them over classic disk-based stored procedures?
2016-05-20 (first published: 2014-08-04)
24,858 reads
2014-06-04
1,379 reads
2014-06-02
1,403 reads
2014-05-15
1,466 reads
2014-05-08
1,451 reads
Blogs
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...
dataMinds Saturday 2026 – Slides
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at...
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