Changing Storage for your SQL Server
A friend pinged me the other day with a question on SQL Server storage. He works as a Windows consultant,...
2010-03-18
2,205 reads
Blog Posts
Need to Persuade Your Manager or Co-Worker to Your Point of View?
At one time or another, each of us has been in a position where we need to persuade a manager,...
2010-03-18
559 reads
New Goal: Security Presentation for End Users on Social Media
Cross-posted from the Goal Keeping DBA:
In recent days I’ve seen folks jump on Facebook groups and become fans of pages...
2010-03-18
694 reads
Script: Backup All your Databases
We all know the importance of taking regular backups of our SQL Server databases. This is a useful little script...
2010-03-18
1,715 reads
Stay Interview Instead of Exit Interview
I had not heard of the stay interview until a friend sent over a link. The idea is that rather...
2010-03-18
1,072 reads
The Coming Upgrade Tidal Wave
Microsoft is poised to release new versions of several different products and technologies that have the potential to have a...
2010-03-18
722 reads
This is Dumb - eBooks
Amazon v Apple, both pressuring publishers on ebook concessions. It’s big business, and it could easily be good or bad...
2010-03-18
942 reads
Undocumented Virtual Column: %%lockres%
One of my development teams needed a mechanism for identifying the value of a key that was part of a...
2010-03-18
4,668 reads
Want to Learn More About How to Master Microsoft Technologies?
If you want to learn more about how to master various Microsoft technologies, visit the website Born to Learn. This...
2010-03-18
1,432 reads
Automating Imports from Access
Access is actually pretty good at importing files, and doesn’t on the surface work much different that import/export from Management...
2010-03-17
872 reads
Blogs
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...
dataMinds Saturday 2026 – Slides
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at...
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