Yes, all synchronization is a black art, because RDBMSs are moving targets and it is always an act of faith that the two databases being compared are actually two different...

I can appreciate a migration-based approach for relatively small-scale database development work but I just don't understand migration-based development when used for team-based  development. The problem for me is the...

@frank Fulton
It was  metaphorical goose-quill. It had to be sharpened before use. I suspect that even professional calligraphers use an ordinary knife nowadays. Even I am past...

My guess (and I know no more than you) is that they created a fragile system that would break under heavy demand.
I emphasize that I have no inside...

Maybe we should train our subconscious mind into good habits by treating all servers as though they were production servers.

Every textbook on Typography from the year dot has given the rules for the size of a font. The rules are no different for screens, especially now that we are...

@nelson-2
Yes, I'm using several rhetorical devices in my editorials. In this case, I'm doing so in order to make the point that the way that teams...

You're correct, Users should never be able to access the base tables directly at all, and all calls to the database must be parameterised.  Basically, although I believe that the...

Yes, I became so interested in the family names that were valid SQL that the editorial was already a bit lengthy, so I didn't mention the obvious panacea of parameterizing ...

@david-2
I've used RazorSQL for a while. It has a terrible user interface but is good at passing data and metadata between many different types of database.  It...

You could be right. Data import into R is much less fussy. The SSMS team used the Microsoft Program Synthesis using Examples (PROSE) SDK to take raw semi-structured data and...

@steve-2 jones

I am due to be writing some Mongo and Azure Cosmos DB articles, concentrating on the performance of data aggregation. Maybe I’ll do one for SSC.

@matt-2 miller

What particularly was it that I saw that made me want to endorse the JSON support in SQL?

It is the performance primarily. It is way faster...

I agree that siloed thinking is bad, but so is a lack of understanding of the tasks that your team members have to perform. To participate in any team process,...

Yes, the best intrusion detection systems are community-based, and I reckon there are good reasons for that. I've never considered the idea of a commercial system, but I'd imagine that...