"..I'm especially surprised how many have performed lift-and-shift migrations to IaaS services after a mandate by management. I'm also not surprised that many customers find they're spending too much, and...

".. However, using data to try and improve your efficiency has a downside. It can lead you to a very narrow focus in your approach .."

A good example of this...

I think folks are learning that 99.999 uptime is expensive, and even if you pay for it, there are operational reasons why the database will be offline on occasion anyhow.

I've used INSERT.. DELETE.. OUTPUT.. in the past to implement archival of log tables. A daily scheduled job simply deletes where datetime < X days, and the deleted rows are...

I remember back when LINQ and Entity Framework were going to write all our queries for us, but it didn't pan out that way.

It's sort like saying that self serve...

At this point, ChatGPT answers a broad range of questions based on the vast public domain of information and consensus of opinion that exists in the internet. It is impressive,...

I didn't realize this is President's Day until you mentioned it - it's not a holiday I typically get off from work. Actually this week will probably be more busy...

So, the cloud is like a super buffet where every type of food imaginable is right there for the taking at a price point that's less than you would spend...

We used to use magnetic tape for arhiving data and avoided needing to delete it OR to pay ongoing costs for online storage.

...

And another thought about this, we...

A useful feature would be declaration of user defined global constants at the server or database level.

For example:

DECLARE CONST @@PI NUMERIC(12,10) = 3.1415926535;
DECLARE CONST @@StatusInProcess TINYINT =...

Really, going forward companies should minimize the amount of PII data that they collect about their customers. There comes a point of diminishing return where the usefulness of data in...

Well, you can't just sit down and ask a handful of software engineers or DBAs.

A few years back, I worked on a team implementing a CCPA compliance project - or...

I developed and maintain a 'DBA Dashboard' application for internal use in our organization. It allows anyone in IT to view a SPID activity report, disk space and backup history,...

As a bit of a sidebar, I just watched the day 3 presentation that Kimberly Tripp gave.  It seems that really old technology still prevails and that technology is...

• This reply was modified 1 year, 10 months ago by  Eric M Russell.

When ranking programming languages, it's important to consider that some languages like SQL and HTML are domain specific. While certainly not the most robust in terms of functionality or "sex...