Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Stairway to SQL Security Expand / Collapse
Posted Monday, August 22, 2011 10:55 AM


Group: General Forum Members
Last Login: Tuesday, October 4, 2016 1:47 PM
Points: 1,967, Visits: 953
First I'll say that the Stairway series of articles are one of the most useful set of resources I've seen on-line for SQL. I'm one of those 'Accidental DBAs' who is trying to make good. I'm actually a little surprised there isn't already a Stairway series for SQL Security, but might suggest it as a viable topic.
Possible topics (off the top of my head as a neophyte) might include:

Logins, Users, Schema, and Roles
Building Custom Roles
Using Schemas, Views, and protecting data
Procedure scope
Certificates in SQL - creation, use, and gotchas
Backups, Restores, and Storage - (More than just backing up the database... what to store, and what not to keep together.)
Encryption - TDE, encrypting pwds/credit card numbers, etc.

And I'm sure there are books worth of other advanced topics that I don't even know to reference yet...
Post #1163486
Posted Monday, August 22, 2011 3:16 PM



Group: Administrators
Last Login: Today @ 3:36 PM
Points: 34,362, Visits: 18,572
Good ideas. We have a stairway in mind, just need to get it moving.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1163643
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse