SQL Server Security Learning Guide

TABLE OF CONTENTS    Installing and configuring SQL Servers for security    Hardening access to SQL Servers    Encrypting SQL Server data    Finding and patching SQL Servers    Security enhancements in SQL Server 2005

Installing and Configuring SQL Servers

Return to Table of Contents

• Webcast: SQL Server Security School: Securing SQL Servers using Group Policy


• White paper: Microsoft SQL Server 2000 security


• White paper: Microsoft SQL Server 2000 SP3 security features and best practices


• White paper: An enterprise-class plan for securing Microsoft SQL Server databases


• Tip: Netlibs: Why is less more (secure)


• Expert advice: Resource for hardening SQL Server 2000


• Step-by-Step Guide: Ensuring data integrity in SQL Server

Hardening access to SQL Servers

Return to Table of Contents

• Webcast: SQL Server Security School: Minimizing SQL Server service, login and user accounts


• Tip: How SQL Server is hacked


• Tip: User rights and privileges


• Tip: Accessing, manipulating and backing up data


• Tip: Top four ways to secure SQL Server


• Checklist: SQL Server user security


• Expert advice: Secure way to share access to SQL Server running multiple databases


• Expert advice: Secure data from the DBA


• Expert advice: Permanently prevent Query Analyzer from accessing a particular database

Encrypting SQL Server data

Return to Table of Contents

• Tip: Encrypting data in SQL Server: Dos and don'ts


• Tip: How to improve SQL Server security


• Tip: jTDS: Open-source JDBC 3.0 middleware driver for SQL Server


• Expert advice: Permanently prevent Query Analyzer from accessing a particular database


• Expert advice: Hiding the source for a stored procedure


• Expert advice: Encrypting password fields

Finding and patching SQL Servers

Return to Table of Contents

• Webcast: SQL Server Security School: SQL Server discovery challenges and solutions


• Tip: How to improve SQL Server security


• Step-by-Step Guide: How to patch SQL Server, part 1


• Step-by-Step Guide: How to patch SQL Server, part 2

Security enhancements in SQL Server 2005

Return to Table of Contents

• Article: Security is a catch word for SQL Server's sequel


• Book excerpt: New security features in SQL Server 2005


• Book excerpt: Optional features are turned off by default


• Book excerpt: A quick review of SQL Server security concepts with enhancements


• Book excerpt: SQL Server password policies and credentials


• Book excerpt: Separation of users and schemas


• Book excerpt: Specifying execution context for procedural code


• Book excerpt: SQL Server permissions and new objects


• Book excerpt: Assembly permissions -- Who can catalog and use an assembly?


• Book excerpt: Permissions, visibility, UDTs and user-defined aggregates


• Book excerpt: What can .NET code do from within SQL Server: Safety levels
• Poll: Which new SQL Server 2005 security enhancement is most significant?
  

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT SQL Server Security Meet compliance requirements with improved database security practices Hardening the network and OS for SQL Server security Securing the server and database in SQL Server SQL Server security made simple and sensible Blog: Protect your databases from the internal threat Setting up SQL Server Service Broker for secure communication The keys to database backup protection for SQL Server Understanding transparent data encryption in SQL Server 2008 The fine line between not encrypting your databases and breach notification Securing SQL Server with access control, login monitoring and DDL triggers

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary data corruption  (SearchSQLServer.com) data hiding  (SearchSQLServer.com)

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary