SQL Saturday 467 – Precon – Query processing and internals
Im not doing a tremendous amount of public speaking this year and concentrating on more professional matters, however im pleased...
2015-10-04
300 reads
Dave Ballantynes blog
Getting out of the ground with TSQL Smells.
At SQLBits I had a number of conversations with a number of people over TSQL Smells, my open source project...
2015-03-23
684 reads
Increasing ColumnStore compression ratio for archival and “Cold storage”
At my present client, part of the task I have to under take is to re-engineer the “Cold Storage”. This...
2015-03-17
359 reads
SQLBits, Incremental Statistics and Demo Fail
So another great SQLBits is done and dusted, many thanks to the team, helpers and sponsors for putting on such...
2015-03-08
481 reads
Non use of persisted data – Part Three
A long time ago I looked at some reasons as to why persisted computed columns ( and therefore indexes on those...
2014-11-02
363 reads
Please please tell me now…
.. Is there something I should know, sang Duran Duran many moons ago when I was young and before I knew...
2014-08-15
398 reads
Reasons why your plans suck : No 56,536
I have been working with SQL server for more years than I really care to mention and like to think...
2014-04-12
388 reads
T4 Support in SSDT
Sometimes a piece of technology passes you by completely, T4 templating happens to have done that for me. On tuesday night,...
2014-03-29
1,149 reads
Whats This Command Bar ?
One of the challenges I faced while creating my TSQL Smells visual studio (SSDT) add in, was trying to find out...
2014-03-13
320 reads
On the move
Its been a fair few years since I started blogging on SQLBlogCasts and the time has now come to find...
2013-04-14
621 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