Encrypt usernames and passwords stored in files
I was looking at a product recently and came across a rather unpleasant surprise: the install instructions specified that I...
2014-04-02
3,305 reads
Blog Posts
Grant View Server State
There are lots of Dynamic Management Objects (DMO’s, more commonly referred to generically as DMV’s) that require extra permissions. Without...
2014-04-02 (first published: 2014-03-25)
93,543 reads
PASS Election Season Begins
Saw the announcement in the Connector today that the process of selecting the Nominating Committee (which vets applications for the...
2014-04-02
526 reads
PowerShell GUI Tool – Network Ping – Version 2
The first version of the tool was developed by Amandhally and it can be found in the below path. Thanks...
2014-04-02
1,619 reads
PowerShell GUI Tool – Network Ping – Version 2
The first version of the tool was developed by Amandhally and it can be found in the below path. Thanks...
2014-04-02
547 reads
Received MVP Award for SQL Server // Ausgezeichnet mit dem MVP-Award
Ausgezeichnet mit dem MVP-Award für SQL Server
(de)
Gestern, am 1. April 2014 erhielt ich die frohe Botschaft: Für meine Beiträge zur...
2014-04-02
3,481 reads
Three Days to the first Nevada SQL Saturday
It’s three days to the first SQL Saturday in Nevada, taking place this Saturday in Las Vegas. I’m looking forward...
2014-04-02
655 reads
VMware vExpert 2014
Today VMware released the list of 754 people who are the proud recipients of the coveted vExpert award for 2014....
2014-04-02
491 reads
AlwaysOn Availability Groups Setting
Many of us are planning to move to SQL Server 2012 in the coming year, and one of the feature...
2014-04-01
326 reads
Goodbye SQL Server, Hello FileMaker…
The last weeks were very time consuming for me, because I had to make a very tough decision: staying independent...
2014-04-01
897 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