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
Editorials
The Future for Database Administrators
Today Steve Jones talks about the job changes and prospects for those that manage IT systems.
2016-08-24
207 reads
Security Leaks from Websites
No matter what we do to secure our databases, we need to be sure our applications are well written, both with secure coding, but also good information handling.
2016-08-23
112 reads
Is Rollback Feasible for Database Changes?
Many of us would like to be sure we could rollback changes made during a deployment if they caused issues. Steve Jones notes that it might not be worth actually building those scripts in advance.
2016-08-22
496 reads
2016-08-22
94 reads
What's Your Smoke Test?
A smoke test can be a good way to ensure complex systems are working as expected after maintenance or changes.
2016-08-19
952 reads
Designing for the Public
The way that governments build software and work with data must change if we want to be more efficient.
2016-08-18
59 reads
2016-08-16
120 reads
Point-in-time data
Phil Factor explains why data detached from its temporal context often loses all meaning.
2016-08-15
85 reads
2016-08-15
84 reads
Blogs
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Forums
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
The String Distance I
Comments posted to this topic are about the item The String Distance I
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers