The Work of the Ancients
We tend to keep data around for a long time. Today Steve Jones is looking to see how long you've kept your databases around.
2019-10-11 (first published: 2015-10-02)
316 reads
Editorials
Feedback and Change
Today Steve asks you to be a part of the change you'd like to see in our professional organization.
2019-10-10
149 reads
Priorities and Productivity
Managing a complex workload is a skill many of us need to acquire and maintain. Today Steve has a few ideas on how to do that.
2019-10-09
210 reads
Very Hot Patches
Azure SQL Database can be patched without stopping the sqlsrvr.exe process. Quite a feat of engineering.
2019-10-08
187 reads
T-SQL Context Switching
Being a standards advocate, Steve has a few thoughts on team code structure.
2019-10-07
419 reads
Which Service in Azure Should You Use for SQL?
I remember when Azure SQL Database was first released in 2010. Microsoft has tweaked the name a couple of times over the years, and back then it was called SQL Azure. The largest database you could create was just 50 GB, and there were quite a few restrictions, such as heaps not being supported. Since […]
2019-10-05
459 reads
Documenting with Tests
The idea of using more unit tests to improve code quality has been around for some time. However Steve Jones notes today that some people use tests for documentation.
2019-10-04 (first published: 2015-05-14)
277 reads
2019-10-03
235 reads
Searching for Answers Inside
Learning how an organization, or even just a codebase, works can be a challenge for new employees.
2019-10-02
143 reads
It's Natural to Avoid Problems
Culture change is hard, and it's one of the most difficult things to implement when trying to get your team to work in a DevOps fashion.
2019-10-01
232 reads
Blogs
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...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
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