T-SQL Tuesday #10 - Indexes
It’s time for T-SQL Tuesday again, the brainchild of Adam Machanic (Blog|Twitter), and this month’s topic is Indexes. A thanks...
2010-09-14
1,637 reads
Blog Posts
24 (28) Hours of PASS on Sep 15, 2010
It’s back with a slightly different format this time, 28 hours of seminars delivered over two days, and it’s all...
2010-09-13
568 reads
Database automation and appliances
10 years ago IT professionals considered database technology “mature” and analysts were preparing to...
2010-09-13
13 reads
Database automation and appliances
10 years ago IT professionals considered database technology “mature” and analysts were preparing to slide it into a commodity status… But on the Exabyte era, we depend on databases...
2010-09-13
13 reads
Getting Drive Info, Part 4, the SSIS Script Component
In this installment of the Getting Drive Info series (Part 1, Part 2, Part 3), SSIS will be used to...
2010-09-13
1,340 reads
Getting Drive Info, Part 4, the SSIS Script Component
In this installment of the Getting Drive Info series (Part 1, Part 2, Part 3), SSIS will be used to collect and save the drive information. SSIS provides multiple...
2010-09-13
10 reads
Project Phoenix expands to Australia and New Zealand
A couple of months ago, many Microsoft MVPs received Visual Studio 2010 Ultimate MSDN subscriptions (retail value: ~$12,000) to distribute...
2010-09-13
627 reads
Quote of the Day
I do not usually post a quote of the day but since this is my own quote I decided to...
2010-09-13
356 reads
Space Coast User Group Recap
I had the pleasure of making my second annual September visit to the Space Coast SQL Server User Group in...
2010-09-13
339 reads
SQL Bloggers – Build Your Brand And Sponsor SQLSaturday #49
As you may know we like to try new stuff here in Orlando, and this is another new thing. I’ve...
2010-09-13
610 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