Choosing a career path; which way do I go?
“Should I get an MBA or an MCSE?” What an odd question. At least these days it seems odd. But,...
2009-10-02
300 reads
Blog Posts
Editorial on the Incidental DBA
You can read the full text of it in today’s SSC Newsletter, the quick summary is that for many businesses...
2009-10-02
255 reads
Free Stuff and a SQL Server Standard Update
Great news. We’ve managed to get one article all the way through the process. We’ll have our first publication out...
2009-10-02
717 reads
Installer Cache – C:\Windows\Installer
Over the past few months I have been upgrading most of my SQL Server Reporting Services (SSRS) 2005 installs to...
2009-10-02
572 reads
MVP Again
It was nice to work through my email and find a bit of positive news instead of more work! I’m...
2009-10-02
390 reads
Perth .NET Users Group First Stop of Down Under Tour
As the first stop of my five city speaking tour of Australia, I spoke at the Perth .NET Users Group...
2009-10-02
477 reads
Security: Development Servers and Workstations
I've written about this before, but probably not as a specific subject or blog post. Trading some comments with a...
2009-10-02
806 reads
SQL Lunch - Memory Management in SQL Server Analysis Services
EVERY ATTENDEE IN THE MEETING WILL BE ENTERED IN A DRAWING FOR A FREEfull license of SQL Sentry Performance Advisor...
2009-10-02
1,015 reads
SQL Server MVP Deep Dives Book available for pre-order
The "SQL Server MVP Deep Dives" book that I wrote two chapters for is up for pre-order. This will be...
2009-10-02
617 reads
SQLSaturday Coming THIS October 24, 2009
Hi, ALL. Sorry I've been light on content this week. I've been battling a cold, and working on some excellent...
2009-10-02
467 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