I think of CosmosDB as like a fusion restaurant at an international airport where you can order from the menu of your choice (table, document, key store, graph, etc.) using...

Here is my take on IoT devices:

IoT has revolutionized industries like: manufacturing, transportation, healthcare, and science. Since this article was originally posted in 2017, I have since installed a Ring...

Yes, at a minimum developers should set "Encrypt=true" property in client connection string, and even better the DBA should install a proper SSL certificate in SQL Server and set option...

Thanks to AirTags and similar tracking technology, thieves have to be more careful about swiping stuff left lying around in the open. I've thought about taking an old...

Thanks to AirTags and similar tracking technology, thieves have to be more careful about swiping stuff left lying around in the open. I've thought about taking an old phone or...

As of 2014, FaceBook recognizes 58 variations of...

I'll use CHAR(1) on occasion for internal status codes where I also have control over the domain of allowable values (ie: RunStatus = 'P').

".. Snowflake is something that a company can run on AWS, Amazon, or GCP .."

Maybe you meant to say Azure instead of "Amazon", but Snowflake can be hosted in Azure...

I suspect that most resignations are people switching jobs, and the primary motivation is the opportunity of remote work. Historically, and this applies especially to IT, there are those who...

The business should define outcomes. For example: build a dashboard providing A, B, C that conforms with our established Agile / DevOps process, and deliver it within our X budget...

Not only useful, but JavaScript is is just plain fun to learn.

Query Store is a good tool for baselining a query over time and also identifying if it's execution plan has regressed in a way that contributes to it's performance. Too...

All PCs connected to our network must have a client tool installed called 'Admin By Request' by FaskTrack Software. It intercepts any attempt by an executable to run as local...

The most significant threat to any organization is the DBA who downloads from GitHub an executable containing a remote desktop trojan. The trojan is running on a PC behind the...

Our DBA team has an ASP.NET application called DBADashboard where we consolidate various operational reports for our own consumption and other reports that provide visibility to other IT teams. It's...