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

Lynn Pettis (1/16/2015)

---

jasona.work (1/16/2015)

---

So, something good is finally going to happen on Monday.

Well, not good for the wallet, but good overall, which is the important thing...

I'm going to get my...

So, something good is finally going to happen on Monday.

Well, not good for the wallet, but good overall, which is the important thing...

I'm going to get my home lab back!

A...

The server in question is a QA, so if it drops off the network it's not going to cause a crisis.

Plus, it's...

Aanndd here comes the spam again...

Including some with titles that look like they might be "real" posts, until you hover and get the first couple lines...

Stefan Krzywicki (12/22/2014)

---

Steve Thompson-454462 (12/22/2014)

---

Stefan Krzywicki (12/22/2014)

---

Steve Thompson-454462 (12/22/2014)

---

---

Brandie Tarvin (12/16/2014)

---

But still... To my mind, since I'm already fixing one part of the package, why shouldn't I proactively fix the...

Steve Jones - SSC Editor (12/19/2014)

---

SQLRNNR (12/19/2014)

---

Yay -...