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 Ballantyne
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
AI: Blog a Day – Day 6: Embeddings – How AI Understands
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
The Book of Redgate: Mistakes
By Steve Jones
This is kind of a funny page to look at. The next page has...
ADF Pipeline Debugging Fails with BadRequest – The Sequel
A while ago I blogged about a use case where a pipeline fails during...
Forums
Dynamic Unpivot
I have a table I didn't design that has tons of repeating groups in...
Writing as an Art and a Job
Comments posted to this topic are about the item Writing as an Art and...
String Similarity II
Comments posted to this topic are about the item String Similarity II
Question of the Day
String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers