Dev Days
I heard about the Stackoverflow Dev Days earlier this year and thought it was an interesting idea. We had talked...
2009-10-16
1,156 reads
Blog Posts
Free E-Book on XSD SQL Server Schema Collections
Whether you like it or not, as a SQL Server DBA or Developer, you will eventually have to learn about...
2009-10-16
554 reads
PASS Board of Directors Debate - Transparency and Vision
There is an amazing debate occurring on Brent Ozar's blog where he interviewed Matt Morollo. Being a little out of...
2009-10-16
1,376 reads
Shipping
I've got a conference to attend in a few weeks, and needed to get some things out the door. Every...
2009-10-16
632 reads
SQLSaturday #21 Shirt Snafu!
Thought I’d share a funny story. Way back before SQLSaturday #1 my friend Shawn recommended a local shirt/embroidery vendor, I...
2009-10-16
496 reads
Table Variable and Temp Table
Today I come across the great blog by Wayne Sheffield on Sqlservercentral.com about temp table and table variable so I...
2009-10-16
577 reads
Vetting the PASS Board of Directors candidates
I've had a pretty heavy involvement in Brent Ozar's interview of Matt Morollo. The reason for my intense activity is he was...
2009-10-16
1,358 reads
A DBA's Role with Respect to Improving Microsoft Dynamics CRM 4.0 Performance
1linerForward: here's a webinar from Microsoft regarding this subject, the following is a summary of what was required to improve CRM performance.
Microsoft's...
2009-10-15
3,401 reads
Are you sticking to your goals? Do you know what they are?
I've engaged a little in the discussion on Matt Morollo's interview on Brent Ozar's blog. It made me go back...
2009-10-15
1,187 reads
Book Review: The Deceived
The Deceived by Brett Battles
I haven’t post on any fiction lately, thought it was time to write about something more...
2009-10-15
346 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