It sure would be grand to have interesting interviews
Coincidentally, in a week of debate and thinking and writing on IT interviews and candidates, XKCD has gifted us with...
2013-11-22
538 reads
Jen McCown
Compare tables to find missing rows
Let’s talk about the case where you want to compare tables to see what’s missing. We might be comparing a...
2013-11-14
919 reads
Quick note: Redgate SQL Data Compare using the command line
I’ve been working on an automated data compare process for one client. I’ve been struggling a little with odd hangups...
2013-10-22
1,144 reads
Liveblogging PASS Sumit Day 1 Keynote with Quentin Clark (#SQLPASS #Summit13)
Welcome to the live blog! Have some resources to start: Watch the keynote live here: http://www.passsummit.com #sqlserver Take a look at...
2013-10-16
518 reads
Next Week, in or out of Charlotte (#sqlpass #Summit13 #SQLHighTea #TooManyHashtags)
Welcome to Tuesday. We hope you enjoy your stay! Edit: We have been informed that today is actually Wednesday. We...
2013-10-09
535 reads
MidnightSQL Server Evaluation script, version 1.0
Server evaluations are a major part of my consulting business. I need to get up to speed very quickly on...
2013-09-30
1,257 reads
Interviews with Great SQL People – Authors, MVPs, many more
I’m trying really hard to write a blog that goes over all the great #sqlpass interviews we’ve done, but work...
2013-09-27
1,266 reads
Hit Fast Forward: Converting and deploying DTS packages
This one is just a quick shout-out to Pragmatic Works, and to Sean. Pragmatic Works made DTS xChange, which I...
2013-09-19
521 reads
SQL Tip: Get Log Space with DBCC SQLPERF(LOGSPACE)
Every so often I’m reminded that the “basics” aren’t really basics. None of us go to take “How to be...
2013-09-19
696 reads
#TribalSQL: A new book by new voices in SQL Server
Two years ago, we were talking about how cool it would be to get a bunch of unpublished authors to...
2013-09-17
522 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