Stairway to SQL Security

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQLServerCentral.com » Suggestions » Stairway to SQL Security

Stairway to SQL Security

Rate Topic

Display Mode

Topic Options

Author

Message

Rich Weissler

Posted Monday, August 22, 2011 10:55 AM

SSCommitted

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 9:15 AM
Points: 1,564, Visits: 768

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

Steve Jones - SSC Editor

Posted Monday, August 22, 2011 3:16 PM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 1:47 PM
Points: 31,406, Visits: 13,722

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 »

Permissions