Index Analysis Post Christmas Update
Last week I mentioned that I had put up a few new versions of my index analysis script. Turns out...
2012-12-28
704 reads
StrateSQL
It’s Another 24 Hours of PASS
With the upcoming PASS Business Analytics Conference, it only makes sense for there to be a 24 Hours of PASS...
2012-12-27
1,142 reads
Last Weeks Top 10 “Reading” Links #12
Happy holidays, seems this post missed coming out this morning as typically scheduled. Thus, a late afternoon post on this...
2012-12-25
723 reads
It’s A Data Type Conversion Chart
This may not be the coolest thing in the world, but it is quite useful. From the annals of Books...
2012-12-21
660 reads
Reblog: December 14 to December 20
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2012-12-21
899 reads
Index Analysis: The Re-Return
A couple years back, I wrote a few blog posts about an indexing script that I use with clients from...
2012-12-25 (first published: 2012-12-18)
3,253 reads
Speaking at PASSMN Tomorrow & Happy Hour
Come on out to the Minnesota PASS SQL Server User Group (PASSMN) tomorrow and hear me speak about extended events....
2012-12-17
770 reads
Last Weeks Top 10 “Reading” Links #11
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2012-12-17
622 reads
Reblog: December 7 to December 13
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2012-12-14
638 reads
December Checklist and Updates
It’s a bit past the first Monday in December, but better a week late than no checklist and update post...
2012-12-10
900 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