Being Responsible for Data
There is an interesting court case on who is responsible for the data being posted on the Internet. Steve has a few thoughts today.
2023-03-29
268 reads
Editorials
2023-03-27
293 reads
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
101 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
116 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)
558 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
143 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
86 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)
183 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)
323 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)
148 reads
Blogs
Query to Email….Well Formatted Email
By SteveHood79
When I get alerts from SQL Server I want it to do three things...
Announcements from the Microsoft Fabric Community Conference
By James Serra
A ton of new features for Microsoft Fabric were announced at the Microsoft Fabric Community...
Why Your SQL Server Backups Aren’t Enough
By Kevin3NF
SQL Server backups are database insurance – you don’t really appreciate them until disaster...
Forums
Upgrades to SQL Server 2022
Comments posted to this topic are about the item Upgrades to SQL Server 2022
Elements of the SQL Server Update Statement
Comments posted to this topic are about the item Elements of the SQL Server...
Data Type Names In Powershell - Identity Increment
I am working with a script to exclude certain data types, and I was...
Question of the Day
Upgrades to SQL Server 2022
What is the earliest version from which you can directly upgrade to SQL Server 2022?
See possible answers