Regarding the ATM hack cited, it seems to me that the vulnerability has more to do with a machine design that allows someone to patch in a laptop, and also...

We typically implement mixed authentication, having an 'SA' account that is never used except in an unusual situation, like when there is an issue with the domain controller or the...

Are the certificate backup files encrypted with a private key?
If so, that would prevent inspecting them externally with something like a text viewer.

One thing you could...

Regarding dynamic sql versus paramaterized sql, probably the example you've provided has been simplified for illustration purposes, and this is really an attempt to get a more general answer intended...

Rather than analyzing by database, I'd suggest focusing on what sql batches or execution plans are causing the spikes. Try selecting top 10 from query stats order descending by (total_physical_reads...

If I were to list three self identifying traits on my personal profile or resume, Adaptability would be one of them. It's good to have.

Identify jobs and other processes that are obsolete and tombstone them. That's especially common in large enterprise IT shops with scores of production database servers and 100s or 1000s of...

As a side note, if what you really need to do is store a collection of JSON documents and work with the data natively as a JSON objects, arrays, properties,...

Where I work, we use both SentryOne and SolarWinds. Honestly, I could spend more time familiarizing myself with the tools. Getting an alert every time an event falls outside a...

Even if the server and database are "up", the system as a whole isn't entirely "available" within the context of every process or case usage. I mean, you can have...

If the MS Access developer really knows what they are doing, they can reference linked tables in a way that doesn't hit your server hard. Then again, what percentage of...