Running a Small User Group - Getting Quality Speakers
Midlands PASS is a small user group. We average about 15 people coming to meetings, which is good for Columbia,...
2009-12-30
1,349 reads
Articles
The SQL of Scrabble and Rapping
In which Phil decides to use a table consisting of all the common words in English to explore ways of cheating at Scrabble and writing doggerel using SQL Server. He then issues a SQL challenge.
2009-12-30
3,255 reads
The Year in Review - 2009
Steve Jones looks back at 2009 and examines some of the predictions he made at the beginning of the year.
2009-12-30
1,882 reads
The Year in Review - 2009
Steve Jones looks back at 2009 and examines some of the predictions he made at the beginning of the year.
2009-12-30
2,385 reads
The Year in Review - 2009th
Steve Jones looks back at 2009 and examines some of the predictions he made at the beginning of the year.
2009-12-30
2,204 reads
Scripting in SSIS – Part 1
Learning to script is a valuable skill for a DBA. Learning to script is invaluable for an SSIS developer and MVP Andy Warren starts a new series that examines the basics of adding scripts to your packages.
2009-12-29
13,777 reads
Crash and Burn
A recent crash of the popular Coding Horror blog brings the responsibility of backups to the front of today's editorial. See if you agree with Steve Jones and his take on backups and restores.
2009-12-29
1,597 reads
Crash and Burn
A recent crash of the popular Coding Horror blog brings the responsibility of backups to the front of today's editorial. See if you agree with Steve Jones and his take on backups and restores.
2009-12-29
2,221 reads
Crash and Burn
A recent crash of the popular Coding Horror blog brings the responsibility of backups to the front of today's editorial. See if you agree with Steve Jones and his take on backups and restores.
2009-12-29
2,388 reads
How To Get a Count of SQL Connections BY IP Address
These queries (which work on both SQL Server 2005 and 2008) are very handy if you want to know who...
2009-12-29
3,772 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