List instances hosting similarly named databases
Lists instances, aliased linked servers, and databases pattern matched on the linked server and database names
2016-06-03 (first published: 2016-05-06)
351 reads
Scripts
2016-06-02 (first published: 2016-05-10)
967 reads
Translate function for SQL Server
Relational database management systems such as Oracle, Postgres, DB2 and Teradata, as well as other programming languages such as Python, Hive, XSLT and SAS have a Translate function. Now we have one for SQL Server.
2016-06-01 (first published: 2016-05-12)
1,068 reads
Testing all Linked Servers in all SQL SERVER servers with Powershell
This Script shows how to use powershell to test all linked servers in all SQL SERVER servers. previously registered in a txt.
2016-05-27 (first published: 2009-04-01)
3,384 reads
2016-05-25 (first published: 2014-03-06)
2,227 reads
Generate script to rebuild indexes in a database
Generate script for reconstgruir ena database indexes
2016-05-23 (first published: 2014-03-20)
2,636 reads
Split string using multiple delimiters
This script is used to split the string using multiple delimiters
2016-05-18 (first published: 2014-10-09)
6,039 reads
2016-05-17 (first published: 2014-08-25)
2,557 reads
2016-05-16 (first published: 2012-10-17)
5,571 reads
Compare two tables for structure and layout
Compare the structure/layout of two tables within an instance of SQL Server (version 2012) and return non-matches.
2016-05-13 (first published: 2014-04-23)
2,927 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