New Domain - My blog has a new domain name gethynellis.com
About a year ago I started to write a blog, previously to that, for about three years I had been...
2010-11-28
611 reads
Gethyn Ellis
SQLServerPedia – Awards 2010
The results of the SQLServerPedia Awards 2010 are out....I was nominated in two categories and I won the "New to...
2010-11-10
1,092 reads
Post 100 – A Year Gone (not quite)!
I wasn’t going to make a special effort for the one hundredth post on my blog, I was intending to...
2010-11-05
778 reads
SQL ServerPedia – Blog Awards
I have been catching up on some blog posts and I read a few posts by well known bloggers like...
2010-11-04
596 reads
What’s in a Full Backup?
I got asked a question today that I though was quite interesting. If my backup starts at 6pm and it...
2010-11-04
684 reads
TSQL2SDAY #12 - Why are DBA Skills Necessary?
WOW this is the 12th TSQL2Sday albeit this month’s is week early because of the PASS summit next week, so...
2010-11-02
629 reads
Movember – Team IPMO
Some friends of mine decided to support the Movember charity this year. I would try and explain what Movember is...
2010-11-01
713 reads
Bulk Insert Permissions
In order to be able to execute bulk operations you need to certain level of privilege both on the database...
2010-10-28
32,749 reads
What I Did This Weekend
About two weeks ago my good friend and former colleague Justin Hostettler-Davie -JHD (Blog | Twitter) asked me via my wife...
2010-10-18
777 reads
SQL Server Recovery Models
A SQL Server database can be in one of three recovery models. FULL, BULK_LOGGED and SIMPLE. The recovery model you...
2010-10-12
1,945 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