T-SQL Tuesday #104: Just Can’t Cut That Cord
We all have our favorite scripts, tools or utilities. Those are the things that help make our jobs easier. Some...
2018-07-20 (first published: 2018-07-10)
2,189 reads
SQL RNNR
T-SQL Tuesday #104: Just Can’t Cut That Cord
We all have our favorite scripts, tools or utilities. Those are the things that help make our jobs easier. In this article, I share with you a poor mans...
2018-07-10
6 reads
Summiting that Technical Challenge Part II
Conquering Challenges
Months ago, I posted an article about some of the challenges encountered while migrating from one service level to...
2018-07-06
750 reads
Summiting that Technical Challenge Part II
Migrating a wordpress blog comes with its various set of challeneges. This installment covers magically changing percent symbols during that migration.
Related Posts:
Summiting that Technical Challenge January 9, 2018
T-SQL...
2018-07-06
3 reads
Use SSMS with a Different Windows Account – Back to Basics
One of the tasks I find myself doing on a fairly regular basis is running SSMS as a different Windows...
2018-07-06 (first published: 2018-06-28)
2,689 reads
Use SSMS with a Different Windows Account – Back to Basics
Runas should be a very common tool in the toolbox of all IT professionals - not just Data Professionals. Learning how to test different accounts is essential to being...
2018-06-28
262 reads
Single User Mode – Back to Basics
In a recent article, I took you on a trip through how to hack (ethically) a SQL Server to regain...
2018-05-31
561 reads
Single User Mode – Back to Basics
Starting SQL Server in single-user mode should be a tool every data professional holds in the bag. This is an essential tool that can be used in multiple scenarios...
2018-05-31
294 reads
Lost that SQL Server Access?
As a data professional can you recall the last time you needed to support a SQL Server instance for which...
2018-05-30
877 reads
Lost that SQL Server Access?
Losing access to a SQL instance is never a desirable situation - for the DBA. When the people that are supposed to have access, lose that access, all hope...
2018-05-30
14 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