Developing a database, getting the database to work with your applications, and getting it to production is just the beginning, but can often be where the story ends. This course examines other SQL Server 2005 essential application, support, and maintenance topics—features you can use for high-availability, stability, reliability, and scalability of databases, plus enhancements for processing large amounts of data, handling complex data structures, implementing asynchronous messaging, and working with XML.
Course includes 48+ hours of total training time...
Developing a database, getting the database to work with your applications, and getting it to production is just the beginning, but can often be where the story ends. This course examines other SQL Server 2005 essential application, support, and maintenance topics—features you can use for high-availability, stability, reliability, and scalability of databases, plus enhancements for processing large amounts of data, handling complex data structures, implementing asynchronous messaging, and working with XML.
In this course you will learn...
Learn about disaster recovery options
Understand high availability concepts
See how to implement SQL Server high-availability features: failover clustering, database mirroring, log shipping, and peer-to-peer replication
Explore new techniques for monitoring and troubleshooting SQL Server
Learn how to implement asynchronous messaging with the new Service Broker
Discover partitioning with SQL Server
Examine new RANKing functions, Common Table Expressions, and learn techniques for dealing with complex queries
Explore advanced techniques for working with complex data structures
Learn how to use source control with SQL Server Management Studio
Discover new XML capabilities in SQL Server 2005
Prerequisites:
This course assumes that students have a basic understanding of Windows operating systems, security, networking technologies, SQL Server, T-SQL, Visual Studio.NET, and XML.
Disaster Recovery
Planning a Backup Strategy
Backing Up Databases
Scheduling Your Backups
Verifying Backup Media
Restoring Databases
Using Database Snapshots
Failover Clustering
High Availability Overview
SQL Server 2005 Failover Cluster
Preparing a Server Cluster
Creating a New Cluster
Installing SQL Server 2005 Failover
Adding Additional SQL Server Nodes
Database Mirroring
Understanding Mirroring
Setting Up Database Mirroring
Monitoring Database Mirroring
Log Shipping
Overview
Configuring Log Shipping
Monitoring Log Shipping Jobs
Using Transact-SQL
Peer-to-Peer Replication
Overview
Configuring the Distributor
Creating the Publisher
Configuring Peer-to-Peer Subscribers
Configuring Peer-to-Peer Topology
Monitoring & Troubleshooting
Diagnosing and Resolving Database Server Errors
Set Up Alerts Using SQL Server Agent
Monitoring SQL Server Agent Job History
Gathering Performance Data and Optimization using DMV
Joshua Gins and Frank Tillinghast are both Senior Consultants with MTOW Software Solutions. They are both Microsoft Certified Solution Developers and have been developing applications together for almost fifteen years. Most of their time is spent consulting for companies nationwide. When they are not developing software or mentoring clients, Frank and Joshua are teaching other developers. They have taught over 3,500 application developers to create business solutions with Visual Studio.NET, VB.NET, ASP.NET, C#, and SQL Server.
