Skip to main content

Event Review: SQL Server 2005 Security (Session ITPROSQL-05)

Welcome to the material supporting page for this session. The materials on this page have been selected as the best matches to the content covered in the live event session.

Session Outline

In this session we will see how SQL Server 2005 breaks security down into a number of distinct areas. Throughout the session we will be introducing the security concepts that are new to SQL Server 2005, such as user-schema separation. We will also be see how SQL Server 2005 implements current security concepts like encryption in ways that are new to this release. The session will look at security from the perspective of the server, the database, and database objects, and some of the different options you can use at each level to help secure your data. The session will also take a look at how you can monitor the security of your SQL server.

Session Agenda

  • New security concepts
  • Database and object security
  • Monitoring data security

Related Links

Use the following resources to learn more about topics covered in this briefing.

    Microsoft Press Books

    Third-Party Books

    • Microsoft SQL Server 2005 A Beginner's Guide

      Summary: This bestselling beginner's guide gets users up and running on SQL Server 2005. The book covers database concepts, and discusses key topics for new users including the SQL Server Workbench, T-SQL, automated administration tasks, security, and analysis.

    • Microsoft SQL Server 2005 The Complete Reference

      Summary: Filled with practical solutions and real-world examples, this resource includes full details on: Enterprise data management capabilities, including security and clustering Powerful developer tools -- T-SQL, .NET CLR, XML, ADO.NET 2.0 Business Intelligence features, such as Integration Services, data warehousing, and reports.

    • Microsoft SQL Server 2005 Reporting Services 2005

      Summary: With coverage of everything from installation to administration, the book demonstrates how to use this powerful server-based reporting solution to improve business decision-making and facilitate company-wide -- even worldwide -- communication.

    • SQL Server 2005 Distilled

      Summary: SQL Server 2005 Distilled offers realistic insight into every significant aspect of SQL Server 2005: its new features, architecture, administrative tools, security model, data management capabilities, development environment, and much more.