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.

Where I work, we have a polling process that runs daily and sends email notifications about databases that havn't been used for X days. The same goes for SQL and...

2021 was the year I was tired all the time - perhaps it was recovery from 2020.

In regards to SQL Server, auditing and compliance was front and center. I developed...

Does anyone here remember FoxPro for DOS and Clipper?

Old timers in the IT outback will occasionally see these things still living in the wild.