What I'm talking about is a firewall on the PC that profiles executable for suspicious behaviour and then warns via a dialog - allowing user to whitelist or block the...

It seems that modern malware detection / prevention should be more AI. It's highly unusual for an executable to traverse through \My Documents and network folders encrypting files, and that...

The good news...

As a DBA in the cloud era, there are many more technologies that we need to familiarize ourselves with (PowerBI, ML, Document databases) but we don't necessarily need to know...

• This reply was modified 4 years, 6 months ago by  Eric M Russell.

With that, I have to ask, since MD5 returns a 16 Byte result and you convert that to BIGINT, which is an 8 Byte result (which is a whopping...

A recent database I created involves tables where the natural unique keys are several columns wide. Rather than using an IDENTITY or other incremental ID, for the surrogate key column...

I don't know for sure either, but reading the FAQ, it seems like this wasn't a 3rd party hack but perhaps two employees abusing their privileges. I can picture a...

Our company has a mobile app that allows customers to make payments, update contact info, look at purchase history, etc. We have an enterprise data warehouse that works great for...

When we provision a instance, we will set SQL Server max mem so that at least 4 - 8 GB memory is free for both Widows and SSMS. If I'm...

"Or maybe you've done it once or twice and forgotten about it."

Well, once you've deployed an Availability Group, it's impossible to just forget about about. It's an endless source of...

Extremely good advise, Steve. I'll add just one thing and that's if you find you need to look for another job, it might mean relocating, if the opportunities aren't...

Most of the organizations I've worked for were IT centric - where folks tend to be rational, competent, and focused on their job. The better employers will weed out individuals...

Any candidate who fails to get the joke doesn't get a 2nd interview. 🙂

Organizations that hoard data indiscriminately and fail to properly secure data should be seen as robber barons who cheat the system and put the public at risk. We should judge...

So do you want the government to have a searchable database of all the flights taken?

If the airlines have to keep it, and the government can draw from it...