Viewing 15 posts - 2,041 through 2,055 (of 2,783 total)
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...
February 12, 2015 at 11:02 am
jayoub (2/11/2015)
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...
February 12, 2015 at 5:50 am
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...
February 11, 2015 at 11:45 am
ramana3327 (2/11/2015)
Thank you.TDE enabled on that database.
Is TDE will effect the compression size?
Absolutely!
From Understanding Transparent Data Encryption (TDE) (the Considerations section) on Technet:
Encrypted data compresses significantly less than equivalent...
February 11, 2015 at 10:18 am
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...
February 6, 2015 at 1:03 pm
Brandie Tarvin (2/5/2015)
So I just got a workplace reminder to wear red tomorrow because of National Red Day[/url].I didn't even know this was a thing, but it is. Wanna participate?
Oh...
February 5, 2015 at 1:19 pm
Lynn Pettis (1/16/2015)
jasona.work (1/16/2015)
Well, not good for the wallet, but good overall, which is the important thing...
I'm going to get my...
January 17, 2015 at 6:31 am
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...
January 16, 2015 at 5:02 pm
Brandie Tarvin (1/13/2015)
Jason,Is this production or a non-prod environment?
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...
January 13, 2015 at 9:03 am
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...
December 23, 2014 at 6:27 am
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...
December 22, 2014 at 12:32 pm
Steve Jones - SSC Editor (12/19/2014)
SQLRNNR (12/19/2014)
Steve Jones - SSC Editor (12/19/2014)
Merry Christmas and Happy Holidays, everyone.I'll be gone after tomorrow, heading away for a week. Everyone behave.
Yay -...
December 22, 2014 at 8:57 am
Stefan Krzywicki (12/19/2014)
jasona.work (12/19/2014)
Brandie Tarvin (12/19/2014)
So basically instead of creating multiple physical processors like memory makers create sticks of RAM, some...
December 19, 2014 at 6:25 am
Brandie Tarvin (12/19/2014)
So basically instead of creating multiple physical processors like memory makers create sticks of RAM, some bright soul thought...
December 19, 2014 at 6:08 am
Brandie Tarvin (12/19/2014)
GilaMonster (12/19/2014)
Per core is SQL 2012 and later licensing. Two quad...
December 19, 2014 at 5:35 am
Viewing 15 posts - 2,041 through 2,055 (of 2,783 total)