When designing the initial model for a database, I'd rather err on the side of tight constraints (ie: default to not-null if the business can't think of a good reason...

DevOps is a collection of tools and processes for deploying code. It's a means to an end - but not the end goal.

There needs to be an abstraction layer between the application and the physical implementation of the database (tables and columns). Some will call for using web services or a microservices...

When evaluating various cloud database platforms, it's not just about SQL features or who can offer the best deal on hosting. Some of these platforms offer amazing scalability.

I was evaluating...

When creating DML scripts for deployment, I sometimes implement assertion based logic like in the two examples below.

The use of RAISERROR with severity level 20 causes SQL Server to terminate...

Just yesterday, I had to troubleshoot an issue where CPU was pegged at 99%, and I determined the bottleneck to be a high volume query executed by the eCommerce application...

I watched all iterations of the Star Trek through the one in early 2000s where Scott Bakula is captain. I even watched the more obscure stuff like Lexx and Farscape....

One Youtube channel is the CMU Database Group from Carnegie Mellon University.  My brother went to CMU and one of his sons goes there now.  Their earlier series...

I'll listen to a vendor specific tech talk, so long as it's one of their engineers or solutions architects doing the talking. It's interesting when they present a tool in...

A specific legacy version of SQL Server (ie: 2012) is good enough, if it supports that legacy application for which you havn't changed since 2014. But if you work in...

Of course, if the SQL Server team actually implemented any of these suggestions, they would be making T-SQL even more proprietary. Maybe we should be directing to these requests to...

It's true that Microsoft's T-SQL and Oracle's PL-SQL are very different, but those are procedural languages extensions that wrap around the SQL language which is fairly consistent.

Here is something that rubs me on a daily basis:

I hate sprinkling my code with RAISERROR just for the sake of printing status messages, because it's ugly and confusing to...

If the incorporation of AI into healthcare results in higher quality outcomes AND lower cost for the patient, then I'm all for it.

However, here in the US - I have...

Yes, implementing ethical rules into an AI system is a tricky subject, especially when society in general can't objectively define what is ethical or  even abide by existing codified ethics...