2016-08-23 (first published: 2015-05-01)
1,467 reads
2013-04-17 (first published: 2013-04-03)
1,460 reads
2013-03-19 (first published: 2013-03-01)
1,052 reads
Get Detach or Attach all user databases script
Script to generate script to detach or attach user databases
2013-02-15 (first published: 2013-01-29)
5,832 reads
Reorganize indexes for all tables in all user databases
Script to reorganize all indexes on all tables in user databases
2013-02-14 (first published: 2013-01-31)
3,258 reads
2013-02-06 (first published: 2012-12-27)
1,846 reads
Change database compatability level of all databases
Changes the database compatibility level of all databases to the given level.
2013-01-31 (first published: 2013-01-07)
929 reads
2012-12-03 (first published: 2012-11-07)
2,022 reads
2012-10-04 (first published: 2012-04-10)
2,021 reads
2012-07-25 (first published: 2012-07-12)
2,514 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