Platforms like Azure have removed the barrier of entry for companies that want to perform analytics, but we still need to consider whether it makes sense for most organizations to...

The sysadmin charged with guarding the gate doesn't necessarily need the key to every door inside the castle. For databases containing sensitive data, there should be something like column level...

RDMS are typically SQL based, but a RDMS can also use some other query language besides SQL, and a non-RDMS (or NoSQL) database can also use SQL. It seems to...

For this to work against SQL Server, it assumes that:

- The user's accounts is not domain authenticated
https://social.technet.microsoft.com/wiki/contents/articles/32490.active-directory-bad-passwords-and-account-lockout.aspx

- The sysadmin doesn't have 'enforce password...

Allowing customers to use the system while it's in the process of being migrated, I guess that's one way to meet the technical requirements of your department's 99.9% SLA. That...

Actually, [SQL Server] is a NoSQL database engine. It naively supports reading and writing data contained in row, columnular, xml, flat text, or blob format. It supports queries using: SQL,...

If babies die because an IT staff member happened to be on vacation, then there is something very wrong about the organization's functional dependency on information technology.

I appreciate my career; it allows me to earn a good living while doing something I actually enjoy and excel at. However, the cumulative impact of technology on society and...

Code reviews are great, but depending on the volume and velocity of development, it's usually not possible. The larger the organization, the more developers and applications, and the size of...

If you work in an organization where a DBA has an the opportunity, time, and political clout to perform manual code reviews, then good for you. However, the good thing...