Stairway to SQL Security

  • Rich Weissler

    Hall of Fame

    Points: 3235

    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...

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 720089

    Good ideas. We have a stairway in mind, just need to get it moving.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply