Category Archives: Security
-
Copying a TDE database from one instance to another
12June 22, 2015 by Kenneth Fisher
I got my first real world experience with a TDE (transparent data encryption) database recently. For those who don’t know …
Continue reading -
Clean up all (most) of the orphans on an instance
3June 3, 2015 by Kenneth Fisher
Recently we have been doing a number of instance moves as part of a large upgrade project. And as anyone …
Continue reading -
Multiple Windows Groups with different default databases
2May 28, 2015 by Kenneth Fisher
A question came up at work the other day, mostly as a mind game, but you never know it might …
Continue reading -
Adding new users & groups in windows
4May 20, 2015 by Kenneth Fisher
I do a lot of testing with security in SQL Server. And of course to do a thorough job of …
Continue reading -
The hidden security of msdb
3April 20, 2015 by Kenneth Fisher
To be fair it’s not actually hidden, just not so well known. Have you ever wondered how to grant permissions …
Continue reading -
0 to Speaker
14March 23, 2015 by Kenneth Fisher
Recently the last day to submit a session for the 2015 Pass Summit rolled around. I mention this because I …
Continue reading -
TSQL Tuesday #63 – How do you manage security: Rollup
2February 12, 2015 by Kenneth Fisher
When I decided on security as my topic for February’s T-SQL Tuesday blog party my thought was that security was …
Continue reading -
TSQL Tuesday #63 – How do you manage security?
26February 3, 2015 by Kenneth Fisher
Come on down! You’re the next contestant on T-SQL Tuesday! I’m your host Kenneth Fisher and this month I’d thought …
Continue reading
SQL Studies 