It's so nice learning both something new, and that your assumption was correct...

I'm going through (again) applying STIGs to servers (gee, a month ago you used the SQL2005 STIG for...

This is going to be a pretty much "me too" post, but still...

I see nothing against using Express in production (even though I'm not,) if the situation warrants it. ...

Sigh.

Looked like a great solution, except it generates the same OS error as trying to backup the key in the SSRS Config manager.

I really do think one of the things...

So I tried tweaking the method that Lowell provided for a one-off, without the SQL DB / Table holding the password for the file. Looks like either I'm typo'ing...

Remember to stay safe now, stay...

Lowell, thanks for the pointer. I hadn't even thought about seeing if there was a way to get the key out with something like Powershell, I'll be giving that...

I actually applied for a DBA position with a company in a field that I would really love to be a part of. Even got a call back, although...

EdVassie (2/13/2015)

---

If you have any SQL 2012 or above instances running on Windows 2012 or above then you really should look at using Group Managed Service Accounts, at https://technet.microsoft.com/en-gb/library/hh831782.aspx

gMSAs have...

Brandie Tarvin (2/12/2015)

---

jasona.work (2/12/2015)

---

Is it me, or is it at least once a week minimum someone posts a "How do I keep the DBA / Sysadmin from doing / viewing...

Is it me, or is it at least once a week minimum someone posts a "How do I keep the DBA / Sysadmin from doing / viewing certain things" type...

jayoub (2/11/2015)

---

STEP-1

Obtain the list of accounts that have direct access to the server-level permission 'View any definition' by running the following query:

Select * from sys.server_permissions where permission_name = 'View...

Been here, sort of done this.

First off, I wouldn't set things up to automatically run the fix query, only because quite a few of the STIGs, if not applied in...

Absolutely!

From Understanding Transparent Data Encryption (TDE) (the Considerations section) on Technet:

Encrypted data compresses significantly less than equivalent...

So, to follow up on this with what worked for anyone else who runs into something similar:

I went with option 2, and had no problems across the board. Switched...

Oh...