Does User Voting for Best Products Work?
I happened to get an email asking me to vote for a product that was being featured in one of...
2007-11-07
657 reads
Blog Posts
Tools: Apex SQL Log, Apex SQL Log API, Sample Corrupted Databases
Apex SQL has announced a new version of Apex SQL Log as well as an API for it.
Release Notes...
2007-11-07
789 reads
SQL Server: Showing permissions for a given database user
Building upon my post from last Tuesday, if you know all the roles for a given user, you'll probably want...
2007-11-06
609 reads
Becoming a DBA, Part II
This is a follow-up to part I from last week. You've considered what you want to do, you've looked at...
2007-11-05
912 reads
Replicate Stored Procedure Execution Published on SSC
Most people 'set it and forget it' when it comes to replication, not realizing that changes to rows on the...
2007-11-05
410 reads
SQL Server Magazine Changes
I was just reading the October 2007 issue and they have done what magazines are apt to do; redesign themselves...
2007-11-05
603 reads
Technical Debt/Steve McConnell is the man!
Steve is the guy who wrote Code Complete (get rev 2 if you buy) which I consider to be required...
2007-11-05
478 reads
The Impact of Architecture/Design Choices
I try my best to get things right the first time. So often, correcting a mistake or bad choice is...
2007-11-05
674 reads
Tuning
Had an interesting debate with Andy Warren on the tuning editorial today. I'm not sure we agree completely, but it's...
2007-11-05
706 reads
Varchar(Max) and ADO
Another note from a friend. They decided to upgrade a large varchar column to varchar(max) and subsequently found strange behavior...
2007-11-05
835 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