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

You also have to take into consideration the amount of wasted time that would result if the automated schedule was calculated incorrectly resulting in duplicated effort - or even worse,...

That could be, but when management dictates to developers how to code a for() loop, then it's time to polish up the resume and move on.

I don't know what logic was executed inside the loop. If it was querying the database for each iteration (bad design pattern to start with), then I can somewhat understand...

SQL Server has been very very good to me.

".. I wonder how many businesses have started to see new trends and needed to abandon some amount of historical data from their charts and graphs. If that's the case,...

The other day, I loaded up Leisure Suit Larry from a 3.5" floppy I purchased in 1990. Still good.