(last updated: 2019-01-05 @ 23:15 EST / 2019-01-06 @ 04:15 UTC )
Let’s say that you execute the following T-SQL:
SET CONTEXT_INFO 1234;
SELECT CONVERT(INT, CONTEXT_INFO());
The...
2018-04-09
1,129 reads
Encryption is a good technique using which a particular data is obfuscated with a key or password. This makes the...
2018-04-07
563 reads
Encryption is a good technique using which a particular data is obfuscated with a key or password. This makes the data useless until any decryption key or password is...
2018-04-07
5 reads
How to build an abstraction layer between physical and logical layers in the database code
2018-04-07
173 reads
Feels like an age since I posted some links. So busy these days!
I’m really excited today as tomorrow I head...
2018-04-06
264 reads
SQL Server 2017 now is considered as a hybrid database enterprise solution as it expands its market and is ported to...
2018-04-06
390 reads
Much has been said about SQL Saturday tools and how PASS is pulling back from development of those tools past...
2018-04-06 (first published: 2018-03-27)
2,638 reads
SQL Server comes with a default SQL agent job installed (for most installations) to help manage the collection of system health data. I would dare say this job is...
2018-04-06
69 reads
This blog post is about how to diagnose what your Azure VM is doing while it is booting.
I have a...
2018-04-06 (first published: 2018-04-04)
1,642 reads
Keep a good eye on your backup and maintenance; they’re kind of important to the health and well-being of your job wait I mean...
2018-04-06
362 reads
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
A while back I wrote a quick post on setting up key mappings in...
By Steve Jones
In 100 years a lot of what we take to be true now will...
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
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