It sounds like this server will be a temporary hub or perhaps even a permanent datamart for confidential data. Therefore, I'd suggest implementing TDE on the database. Also, remember that...

I assume we're talking about the need for the developers to create technical and operational documentation here, since the business should be exclusively providing the requirements documentation, at least collaborating...

One suggestion that would greatly improve the usefulness of the data, so as to accommodate for the relative sparsity of the data, is to limit industry to a selection of...

So, our Russian and Irish brothers are at the top of the chart in terms of median salary, even after standardizing to USD equivalent?
Next time you guys are...

Samsung Smart TV Owner Learning About Majority Of Features From Leaked CIA Documents
http://www.theonion.com/article/samsung-smart-tv-owner-learning-about-majority-fea-55493
:laugh:

Also, if you have an application or user who insists on connecting as "SA", then one option is to rename the account and then recreate it with lesser privileges.

When connecting using a SQL Server authenticated account, you won't have the user's domain username, but you can still determine their host name, client ip address, and some other useful...

Does anyone know of a SQL Server schema comparison tool that will script out server level settings, permissions, and objects? From what I've seen, RedGate SQL Compare or Microsoft SQL...