Katerine459 (3/11/2015)

---

Thanks, all, for the recommendations... I'll be sure to check those out when I have a chance.

If a stairway ever does get created, I just wanted to give a...

SqlSanctum (3/10/2015)

---

jasona.work (3/10/2015)

---

SqlSanctum (3/9/2015)

---

jasona.work (3/9/2015)

---

SQLRNNR (3/9/2015)

---

jasona.work (3/7/2015)

---

Turns out, Public by default does not have CONNECT SQL. So I was thinking I could grant the privilege to Public, then revoke...

SqlSanctum (3/9/2015)

---

jasona.work (3/9/2015)

---

SQLRNNR (3/9/2015)

---

jasona.work (3/7/2015)

---

Turns out, Public by default does not have CONNECT SQL. So I was thinking I could grant the privilege to Public, then revoke it from...

The answer to that is a bit trickier.

You need to find out which one has the table / indexes you're planning to compress and go from there. One way...

SQLRNNR (3/9/2015)

---

jasona.work (3/7/2015)

---

Turns out, Public by default does not have CONNECT SQL. So I was thinking I could grant the privilege to Public, then revoke it from the individual...

1. Yes, you can compress...

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...