SSIS - Fast Parse
I had another chance last week to answer an email follow up question from the session Brian and I gave...
2008-12-15
8,507 reads
Blog Posts
St. Louis Day of .Net
Yesterday I spoke on 2008 T-SQL and Data Types at the St. Louis Day of .Net event. This was an...
2008-12-14
419 reads
FriendFeed Review
I’ve been trying the social networking thing, with accounts on Twitter, Facebook, and LinkedIn. I guess I have one on...
2008-12-12
774 reads
SQL Quiz #2 - Toughest Challenges in my Career
I finally got tagged for the SQL Quiz, which I've been following. Michelle Ufford, aka SQLFool, tagged me following her...
2008-12-12
1,328 reads
Calories Burned During Sex
Ah, if you're reading this aren't you the curious one! I ran across the link below a while back and...
2008-12-11
641 reads
How Do I Configure SSIS to Work With a Named Instance
How Do I Configure SSIS to Work With a Named Instance?
By default, SSIS (SQL Server Integration Services) uses the msdb...
2008-12-11
12,798 reads
Stupid Coding Tricks
Can anyone here write a SQL statement that generates a Mandelbrot Set? I’m sure a few of you can, and...
2008-12-11
866 reads
Just Do It
I was recently reading Joel Spolsky’s column in Inc. on management and I thought it was an interesting story. In...
2008-12-10
854 reads
SQL Quiz Part 2: Career Challenges
I’ve read a number of responses from Chris Shaw’s first DBA networking quiz. I missed out on the first one,...
2008-12-10
1,273 reads
You're Not Dumb...And Neither am I
One of the things I'm not fond of is self-deprecation. Smacking yourself on the forehead when you screw up a...
2008-12-10
529 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