-
November 12, 2015 by Kenneth Fisher
This isn’t something you have to do frequently, but sometimes you don’t want the users to have access to certain …
Continue reading
Category: Microsoft SQL Server, Security, SQLServerPedia Syndication, T-SQL
|
Tags: microsoft sql server, object permissions, security
-
November 4, 2015 by Kenneth Fisher
I recently gave my SQL Server Security for Everyone session at Summit 2015. (I’m still in awe about that by …
Continue reading
Category: Microsoft SQL Server, Pass, Security, Speaking, SQLServerPedia Syndication
|
Tags: microsoft sql server, security, speaking
-
November 2, 2015 by Kenneth Fisher
If you’ve ever worked through an audit you have probably gotten a request that looks a lot like this: Please …
Continue reading
Category: Auditing, Microsoft SQL Server, Security, SQLServerPedia Syndication
|
Tags: database permissions, microsoft sql server, security, server permissions
-
October 5, 2015 by Kenneth Fisher
Well I’ve done it. I’ve spoken at an event. I’ll discuss how I felt about it and what I learned …
Continue reading
Category: Microsoft SQL Server, Security, Speaking, SQLServerPedia Syndication
-
September 21, 2015 by Kenneth Fisher
I spent something like 2 hours today trying to figure out how a particular user had access to one of …
Continue reading
Category: Microsoft SQL Server, Security, SQLServerPedia Syndication
|
Tags: database permissions, microsoft sql server, security, server permissions
-
July 27, 2015 by Kenneth Fisher
I’ve been doing a lot of research recently for my permissions session and for a project at work. During said …
Continue reading
Category: Documentation, Microsoft SQL Server, Security, SQLServerPedia Syndication
|
Tags: database permissions, Documentation, microsoft sql server, perm, security, server permissions
-
June 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
Category: Backups, Encryption, Microsoft SQL Server, Problem Resolution, Security, SQLServerPedia Syndication
|
Tags: backups, encryption, microsoft sql server, problem resolution, security
-
June 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
Category: Microsoft SQL Server, Security, SQLServerPedia Syndication, Upgrades
|
Tags: microsoft sql server, orphans, security, upgrades
-
May 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
Category: Microsoft SQL Server, Security, Settings
|
Tags: database settings, default settings, microsoft sql server, security
-
May 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
Category: Security, SQLServerPedia Syndication
|
Tags: command shell, security
