2016-09-14
127 reads
Editorial
Encryption Keys Matter
Protecting the keys used for encrypion can really matter for companies, and in today's complex world, that can be difficult. Monitoring becomes important to helping here.
2016-09-13
72 reads
Ignoring Database Version Control
Steve Jones thinks version control is important, even for databases.
2016-09-12
149 reads
Teaching a dog to sing
To survive the inevitable downturns in the IT industry, Phil Factor argues that a IT manager needs to take time to maintain technical skills. It is not enough to understand development; you have to be able to do it.
2016-09-12
105 reads
You know what we really need? Better interpersonal communication
Today we have a guest editorial as Steve is traveling. Ben Kubicek notes that sometimes it is hard for technical people to communicate well.
2021-03-03 (first published: 2016-09-08)
204 reads
Does Log Data Belong in a Table or a File?
Today we have a guest editorial that asks how one might want to manage all those logging metrics produced by applications.
2021-08-25 (first published: 2016-09-06)
312 reads
Towards a Single Management Stack
Phil Factor argues that with both SQL Server and PowerShell now running on Linux, the latter becomes increasingly important in achieving the goal of a single management stack for databases across all hosting environments.
2016-09-05
69 reads
SQL Server docks in Linux
The Database Engine on the Data Platform departs for Linux. A late arrival but worthwhile, says Phil Factor.
2016-08-29
65 reads
2016-08-26
82 reads
Better Coding
The Australian Census was a mess, and supposedly some university students build a better version. Steve Jones comments on better coding practices.
2016-08-25
131 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