FLOAT datatype casting issue
Do you use the FLOAT datatype? If so you had better read this……
Today I came across an issue somebody posted...
2013-02-01
5,133 reads
Richard Douglas
New Year Aspirations – Christian Bolton – Author
As a former mentor Christian is used to me asking him all sorts of random questions, but this time it’s...
2013-01-29
1,535 reads
New Year Aspirations – Annette Allen – WiT
Thanks for agreeing to do this Annette, with your SQL Saturday event only a few weeks away thing must be...
2013-01-28
936 reads
New Years Aspirations – Kevin Kline – Presenting
I’ve been very privileged to be able to work alongside Kevin on a few projects during our time together at...
2013-01-25
883 reads
SQLSaturday 194 (Exeter)
It’s an exciting time for SQL Server Professionals in the South West of the UK, we’re now just a few...
2013-01-24
733 reads
New Year Aspirations – Jonathan Allen – DBA
Thanks for agreeing to do this Jonathan, I know you’re busy with arrangements for SQL Saturday #194 in Exeter
Before we...
2013-01-24
1,077 reads
New Year Aspirations – Gavin Payne – MCA
Thanks for agreeing to do this Gavin. It’s great to be able to interview an MCA as there are so...
2013-01-23
944 reads
New Year Aspirations – boB Taylor – MCM
Thanks for agreeing to do this boB. It’s great to be able to interview the Microsoft program manager for the...
2013-01-22
1,890 reads
New Year Aspirations – Thomas La Rock – Blogging
Most readers will know you already, but before we start on the main part of the interview, tell us all...
2013-01-21
1,018 reads
New Year Aspirations – Mark Broadbent – SQLSaturday
I’ve known you for quite a while now through Twitter and later at SQLBits (your mum was right kids, don’t...
2013-01-18
1,118 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