Event Review: SQL Server 2005 Technical Overview (Session ITPROSQL-01)
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
Microsoft SQL Server 2005 is the next version of the successful SQL Server product family. This new edition offers a number of enhancements to provide a product for today's environment. This session looks at the key areas that concern IT professionals. We look at various security enhancements, including the authentication changes and the granularity of permissions that the product allows. We look at availability and the changes to improve service availability and replication of data. We also cover the improvements in the manageability of the product.
Session Media
This session consists of a Windows Media presentation and demonstrations:
| Download the full session
Download the full multimedia recording of this session. |
| Download all slides and transcripts
Download just the slides and transcripts of this session. |
| Demo: Using SQL Server Management Studio
In this demonstration, we will show how to view and manage SQL Server using SQL Server Management Studio and Object Explorer.
Download |
| Demo: SQL Scripting Features
In this demonstration, we will show some of the new SQL Server scripting capabilities. We will look at the SQL query interface in SQL Server Management Studio, generate scripts from database objects, and look managing scripts and connections with Solution Explorer.
Download |
| Demo: Surface Area Configuration
In this demonstration, we will show the Surface Area Configuration security tool and the SAC.EXE command line utility that can be used to manage SQL Server network and feature configurations.
Download |
| Demo: User-Schema Separation
In this demonstration, we will show how separation of user-schema separation in SQL Server 2005 works to help increase security by providing greater control over database objects.
Download |
| Demo: SQL Agent Proxies
In this demonstration, we will show how to create credentials and SQL Agent proxy accounts that allow users to run SQL Agent jobs they need, while providing enhanced security for SQL Server 2005.
Download |
| Demo: Database Mail
In this demonstration, we will configure a Database Mail profile and account. We will also use the sp_send_dbmail stored procedure to send an e-mail message and then use Outlook Express to verify that the e-mail message was sent and received.
Download |
| Demo: Mirrored Backups
In this demonstration, we will show how to use the new mirrored backups feature in SQL Server 2005. We will create mirrored backup media sets, perform a mirrored backup, and then restore a database from a mirror set.
Download |
| Demo: SQL Profiler
In this demonstration, we will how to analyze deadlock issues with SQL Profiler.
Download |
Related Links
Use the following resources to learn more about topics covered in this briefing.
Microsoft Press Books
- Microsoft SQL Server 2005 Administrator's Pocket Consultant
Summary: Portable and precise, this pocket-sized guide delivers immediate answers for the day-to-day administration of SQL Server 2005.
- Microsoft SQL Server 2005 Administrator's Companion
Summary: Your one-volume guide to planning, deployment, administration, and support. Get your mission-critical databases up and running quickly with this essential, single-volume guide. This comprehensive administrator's reference details features and capabilities of SQL Server 2005, including how to implement business intelligence applications. It delivers the easy-to-follow procedures, practical workarounds, and key troubleshooting tactics you need for on-the-job-results.
- MCITP Self-Paced Training Kit (Exam 70-444): Optimizing and Maintaining a Database Administration Solution Using Microsoft SQL Server 2005
Summary: Your 2-in-1 Self-Paced Training Kit. Ace your preparation for the skills measured by MCTS Exam 70-444 and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce what you've learned by applying your knowledge to real-world case scenarios and practice exercises.
- MCITP Self-Paced Training Kit (Exam 70-443): Designing a Database Server Infrastructure Using Microsoft SQL Server 2005
Summary: Your 2-in-1 Self-Paced Training Kit. Ace your preparation for the skills measured by MCITP Exam 70-443 and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce what you've learned by applying your knowledge to real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time.
- Microsoft SQL Server 2005: Database Essentials Step by Step
Summary: Your hands-on, step-by-step guide to learning the fundamentals of SQL Server 2005 programming. Get the guidance you need to start designing databases-one step at a time. With this practical tutorial, you'll teach yourself the core skills for building and managing databases with the next generation of SQL Server.
Third-Party Books
- 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.
- 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.
Sample Chapter
- 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.
Sample Chapter