2017-01-18
188 reads
Editorial
Delaying Patches is Problematic
Many of our security issues come down to not patching software when there are updates available.
2017-01-17
115 reads
Writing the Correct Query is Important
Making simple mistakes in queries can have far reaching consequences.
2017-01-16
170 reads
The Development Lab
This week Steve Jones looks at hardware and the ways in which you might assemble a set of computers for building software.
2017-01-16
58 reads
Securing Your Instances
This week Steve Jones looks at moving the port numbers of your instances for a bit of security.
2022-11-25 (first published: 2017-01-13)
204 reads
Backup Data Security
We need better security for our data, especially for our choices in managing data.
2017-01-12
86 reads
2017-01-11
170 reads
SQL Server is Getting More Popular
Today, Steve Jones looks at the popularity of SQL Server, which was named DBMS of 2017.
2017-01-10
140 reads
Keeping up to, and down with, Date
It is foolish to insist on reading only up-to-date books on technology. Nothing beats getting the broad perspective.
2017-01-09
83 reads
Changes are Coming to the SQLServerCentral Forums
SQLServerCentral is getting an upgrade, and Steve Jones has a few words.
2017-01-09
141 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