Demo Data for Everyone
Steve thinks having a known set of data for your system is one way to improve your software development process and make salespeople happy.
2019-08-14
577 reads
Editorials
Organized Learning
Learning to become a DBA is often a winding and twisty road. Steve has a little advice today.
2019-08-13
252 reads
2019-08-12
276 reads
The Sequel to SQL
Phil Factor tacks a few new buzzwords onto his CV and looks forward to joining the new wave of "digital innovators".
2019-08-10
697 reads
The 2019 Home Lab
Steve wants to know what's in your current home lab. Leave a note and help others learn to set one up.
2019-08-09
610 reads
Timing is Everything
A phishing attack is directed at engineers, but it could easily be pointed at IT pros.
2019-08-08
193 reads
2019-08-07
381 reads
2019-08-06
295 reads
2019-08-05
296 reads
Best Practices and Band Plans
Grant Fritchey explains how database best practices should be followed more like those in Ham radio.
2019-08-03
450 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