Several years ago, I was brought in on a project to review a database design. I was provided a time for a meeting. No written requirements were available, but I generally knew what the system was supposed to do. No before/after schema images showed what was being changed were available. Still, I was assured that […]
2023-03-25
107 reads
Zero downtime used to be more important in Steve's job, but lately it seems customers aren't as concerned.
2023-03-24
119 reads
Poor patterns and practices are code smells. Steve Jones notes we have plenty in T-SQL.
2023-03-22 (first published: 2015-10-05)
562 reads
We need to measure and monitor things to become better, but we need to keep an eye on what the actual goal is from this monitoring.
2023-03-20
152 reads
A week ago I was in Pasadena attending the SCaLE 20x conference, a gathering of many different open-source communities discussing the technologies and platforms that draw them together. I was fortunate enough to hear some excellent presentations on PostgreSQL and give two talks as well. After the first round of talks on Friday morning a […]
2023-03-18
91 reads
A guest editorial from Andy Warren that looks at annual training to try and improve security.
2023-03-17 (first published: 2015-08-21)
190 reads
Are you a good writer? You should be. Steve Jones notes that communication skills are not only important, but that poor ones can set you apart in a way you might not like.
2023-03-15 (first published: 2014-01-20)
329 reads
This editorial was originally published on Jan 16, 2007. It is being republished today as Steve is on vacation. This one looks at the potential issues with data mining when data might be shared between companies.
2023-03-13 (first published: 2011-11-10)
153 reads
I honestly enjoy writing editorials. Something pops into my tiny brain next to something else, and I'm off. However, today, as I started to write on the topic of learning, I suddenly felt like I had just written this same editorial. I go and look, sure enough, several of my recent editorials have been on […]
2023-03-12 (first published: 2023-03-11)
86 reads
Steve thinks the world is close to normal for him after the pandemic. What about you?
2023-03-10
152 reads
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Comments posted to this topic are about the item The Max PK Length
Comments posted to this topic are about the item My experience using the GitHub...
Comments posted to this topic are about the item The Microsoft SQL Year in...
If I create a multiple column Primary Key constraint, what is the most number of bytes I can include in the constraint?
See possible answers