Coding More Carefully
If you had less resources or compilation too longer, would you code more carefully? Steve Jones talks about the benefits that might come from not having the latest and greatest hardware.
2012-01-12
218 reads
Editorials
Cloud Safety
Is the cloud secure? How can you be sure? Steve Jones talks a little about some ways you can try to check on your cloud provider.
2012-01-11
174 reads
Referencing Remote Data
Synonyms were added to SQL Server to make the references to remote data easier. However Steve Jones doesn't use them, do you? Are there benefits?
2012-01-10
158 reads
On Database Migrations and Agility
It always surprises me when Application programmers tell me that all 'Agile' techniques are directly applicable to database development. Ideally, yes; but reality gets in the way.
2012-01-09
161 reads
The Stubborn DBA
Today we have a guest editorial from Phil Factor. Phil wonders why so many people in technology can be stubborn. Are you a stubborn DBA?
2012-01-09
533 reads
Read-only Data
Today's poll looks at read only data and how you handle the backup and recovery of this data.
2012-01-06
143 reads
Are Auto-Updates Good?
Internet Explorer is going to get automatic updates soon and Steve Jones thinks it's a mixed blessing.
2012-01-05
130 reads
Truth and Demos
Today Steve Jones reminds us that we are all selling something in technology, even if it's our reputation. We ought to be truthful in our dealings with our clients.
2012-01-04
131 reads
Cloud Patches
The cloud changes the way that we can administer and deploy changes to our systems. Steve Jones highlights an interesting idea, and hopes we get similar techniques applied to databases in the cloud.
2012-01-03
117 reads
SharePoint - Subversive?
A reflective editorial on how SharePoints and other collaborative work spaces are getting used.
2012-01-02
234 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