SQL Saturday in Orlando
The dates for Microsoft's TechEd 2008 are fast approaching here in North America. Sandwiched between the two weeks of this year's...
2008-05-23
1,953 reads
Blog Posts
Visiting Birmingham SQL Group in June
I'll be doing a presentation for the Steel City SQL Group on June 17 and then on June 18th I'm doing...
2008-05-23
1,375 reads
Hard Core Object Oriented Programming Guidelines
I read Andrew Binstock occassionally in SD Times and in the most recent issue he posted a list of guidelines...
2008-05-21
1,702 reads
Pop Quiz - What's the Max Number of Resultsets Supported by Management Studio?
Ran across this strange occurence while doing some testing. To duplicate the results (the actual code was a little more...
2008-05-20
1,480 reads
Review of How to Cheat at Securing SQL Server 2005
SQL Server MVP Frank Kalis has posted a short review on How to Cheat at Securing SQL Server 2005, a...
2008-05-20
1,902 reads
Answers To DBA Interview Questions
Here are your answers to the questions from last week You should get some variation of what I have given...
2008-05-19
2,738 reads
Answers To SSIS Interview Questions
This is just a starting point for you to prepare for your interview so make sure not to limit yourself...
2008-05-19
4,067 reads
Collation Issues
This is really interesting to me:
CREATE TABLE #TEMP (name varchar(80))
INSERT INTO #TEMP values ('Malteser Schloßschule')
INSERT INTO #TEMP values ('Malteser...
2008-05-19
722 reads
SSIS Interview Questions
I have decided to make a short series of blogs about possible interview questions to help you prepare for an...
2008-05-19
3,012 reads
Technical Podcasts I Listen To
There are a few podcasts I tend to listen to as I have time. Since I work with a wide...
2008-05-19
4,044 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