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...

licensing is extra confusing in the cloud. Sometimes licensing is included in an Azure SQL, sometimes not. You could easily be double licensed as not licensed at...

This is probably not an availability issue, since cloud providers replicate images and data across regional data centers by default. But I'm thinking that unanticipated spikes in temperature could present...

Azure SQL...

I have a few ideas about how to mitigate the cloud compute shortage.

For example, when a customer provisions an IaaS VM, the option 'Azure Spot instance' offers a much discounted...

Regarding the input parameters @BookID and @StudentID, instead of supplying IDs in the form of a delimited string, consider using table-valued parameters instead. This would make referencing the parameters much...