2023-03-27
315 reads
Editorials
Review Early and Often
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
108 reads
How Important is Zero Downtime?
Zero downtime used to be more important in Steve's job, but lately it seems customers aren't as concerned.
2023-03-24
121 reads
What's a Code Smell?
Poor patterns and practices are code smells. Steve Jones notes we have plenty in T-SQL.
2023-03-22 (first published: 2015-10-05)
566 reads
Metrics and Measures
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
154 reads
The Human Factor
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
93 reads
Annual Security Compliance Training
A guest editorial from Andy Warren that looks at annual training to try and improve security.
2023-03-17 (first published: 2015-08-21)
193 reads
Better Writing
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
Watching the Watchers
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)
156 reads
Sources of Inspiration
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)
87 reads
Blogs
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
This Week's AI Trust Problem Became Everyone’s Problem
Comments posted to this topic are about the item This Week's AI Trust Problem...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers