|
|
| |
| Agenda
& Session Details |
| |
| 02:00
pm - 03:45 pm |
SQL
Server 2005 - What's New and How to Use It
Vineet Gupta
(Level 300)
Session Abstract
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.
In this session we will look at some of the new features included
in SQL Server™ 2005 for database administrators.
We start by looking at the new administration tools in SQL Server
2005, including SQL Management Studio, and SQLCMD, the new command-line
utility. We then explore the various security enhancements and
improvements made to improve service availability and replication
of data. Finally we cover some of the maintenance and performance
tools included with SQL Server 2005, including maintenance plans,
SQL Profiler, and SQL Server Agent.
The session has very few slides and we will spend most of the
time exploring the product itself. If you wanted to know what
Microsoft is shipping in the new version of SQL Server, this
is THE session to attend!
Demos in the Session:
- SQL Server 2005 Management Studio
- Object Explorer and Solution Explorer
- SQLCMD
- Cryptography
- User Schema Separation
- Table Partitioning
- Peer-to-Peer Replication
- Database Maintenance Workflow
- Monitoring Tools
- Diagnostic Tools
- Tuning Tools
- SQL Server Profiler |
|
| |
|
