Watch Your Repairs
Apparently PC repair people have learned a few things from auto mechanics of the past. A news group in the...
2009-07-23
618 reads
Blog Posts
Database Mirroring - Hitting the Limits
When I first heard about database mirroring in 2004, I was excited. Here was a great new feature that would...
2009-07-22
4,374 reads
Featured Blogger: Glenn Berry
This month I’m featuring Glenn Berry, a Denver based MVP that writes Glenn Berry's SQL Server Performance blog. He blogs...
2009-07-22
725 reads
Kindle Alternatives – B&N on Blackberry
I’m not a fan of Blackberry devices. Actually that’s not true, I really dislike them. They’re not intuitive, and I’ve...
2009-07-22
1,287 reads
My Virtual Lab setup Hyper-V 2008 and Virtual Server 2005 R2
One of the things I’ve maintained over the years is a lab to do everything I need. From testing new...
2009-07-22
3,537 reads
Replication Snapshot Errors Caused By Compatibility Level Setting
I ran across an interesting replication error recently that's worth sharing. It happened while using a distributor running SQL 2008,...
2009-07-22
447 reads
Barnes and Noble eBooks
I saw yesterday that Barnes and Noble released their e-reader for iTouch/iPhone, Blackerrys, Mac, and PCs and at the same...
2009-07-21
795 reads
Contest to Win a Free Trip to PASS
MSSQLTips & Idera are sponsoring a contest where the grand prize in an all expenses paid trip to the PASS Summit...
2009-07-21
708 reads
Conversations
Do you know how to start a conversation or how to join one? I usually wait for a pause and...
2009-07-21
665 reads
Kindle Update - Broken
🙁
I was literally stunned and it must have shown on my face because my daughter asked me if I was...
2009-07-21
791 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