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 Can I encrypt and restore a database backup in SQL Server 2005? FAQ: How to troubleshoot and grant SQL Server permissions Secure SQL Server from SQL injection attacks How insiders hack SQL databases with free tools and a little luck Sarbanes-Oxley compliance checklist: IT security and SQL audits SQL Server source code analysis and management adds database security Ten common SQL Server security vulnerabilities you may be overlooking SQL Server 2008 security and compliance features reduce security risks Get your SQL Server security goals in order How secure is your SQL Server network design? SQL Server installation SQL Server consolidation: Why it's an optimization technique SSIS error message due to installation problem on SQL Server 2005 Get SQL Server log shipping functionality without Enterprise Edition How to create a SQL Server linked server to DB2 Tuning SQL Server performance via disk arrays and disk partitioning Virtual database storage for SQL Server: Friend or foe? Tutorial: Migrating to SANs from local SQL Server disk storage How to restore SQL Server database to transition server during upgrade Storage area network (SAN) basics every SQL Server DBA must know Tips for moving from SQL Server local disk storage to SANs SQL Server installation Research SQL Server overview Storing and searching for image files in SQL Server Can you shrink your SQL Server database to death? Physical data storage in SQL Server 2005 and 2008 SQL Server 2008 data types: Datetime, string, user-defined and more SQL Server and data manipulation in T-SQL Supertype and subtype tables in SQL Server Enforcing data integrity in a SQL Server database SQL Server database design disasters: What not to do Using SQL Server datetime functions GETDATE, DATENAME and DATEPART Tuning SQL Server performance via memory and CPU processing SQL Server overview Research

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