Home ◊ Books ◊ Training Seminars ◊ Registration
Seminars/Locations ◊ Seminars/Daily Schedule ◊
Who's Teaching ◊ Course Materials ◊ Parking/Misc. ◊ Cancellations/Refunds
Onsite Seminar/Training ◊ Group Discounts
Sign up Now -- 5-day training seminar
-- plenty of hands-on!
Seating is limited. Reserve now to guarantee your seat.
This class provides the essential core knowledge of SQL Server 2008 needed to be a successful administrator. It covers everything from selecting hardware to database configuration to database backups and recovery.
Want to know what people have said about my work and training courses? Read the testimonials...
Why take my training courses? Read about my effective training techniques and guarantees...
This training seminar is not meant as an examine prep but does cover most of the same skills tested on the Microsoft exams.
|Installing, Configuring, and Administering Microsoft SQL Server 2008|
|Skills measured by exam|
|Installing and Configuring SQL Server 2008|
|Install SQL Server 2008. Considerations include clustering, default collation, file locations, number of instances, and service accounts.|
|Upgrade to SQL Server 2008.|
|Create a linked server.|
|Configure SQL Mail and SQLAgentMail.|
|Configure network libraries.|
|Troubleshoot failed installations.|
|Creating SQL Server 2008 Databases|
|Configure database options for performance. Considerations include capacity, network connectivity, physical drive configurations, and storage locations.|
|Attach and detach databases.|
|Create and alter databases.
|Create and manage objects. Objects include constraints, indexes, stored procedures, triggers, and views.|
|Managing, Monitoring, and Troubleshooting SQL Server 2008 Databases|
|Optimize database performance. Considerations include indexing, locking, and recompiling.|
|Optimize data storage.
|Modify the database schema.|
|Perform disaster recovery
|Perform integrity checks. Methods include configuring the Database Maintenance Plan Wizard and using the Database Consistency Checker (DBCC).|
|Troubleshoot transactions and locking by using SQL Profiler, SQL Server Enterprise Manager, or Transact-SQL.|
|Extracting and Transforming Data with SQL Server 2008|
|Set up IIS virtual directories to support XML.|
|Import and export data. Methods include the Bulk Insert task, the bulk copy program, Data Transformation Services (DTS), and heterogeneous queries.|
|Develop and manage DTS packages.|
|Manage linked servers.
|Convert data types.|
|Configure, maintain, and troubleshoot replication services.|
|Managing and Monitoring SQL Server 2008 Security|
|Configure mixed security modes or Windows Authentication. Considerations include client connectivity, client operating system, and security infrastructure.|
|Create and manage log ons.|
|Create and manage database users.|
|Create and manage security roles.
Roles include application, database, and server.
|Enforce and manage security by using stored procedures, triggers, views, and user-defined functions.|
|Set permissions in a database. Considerations include object permissions, object ownership, and statement permissions.|
|Manage security auditing. Methods include SQL Profiler and C2 auditing.|
|Managing, Monitoring, and Troubleshooting SQL Server 2008|
|Create, manage, and troubleshoot SQL Server Agent jobs.|
|Configure alerts and operators by using SQL Server Agent.|
|Optimize hardware resource usage.
Resources include CPU, disk I/O, and memory.
|Optimize and troubleshoot SQL
Server system activity. Activities include cache hits, connections,
locks, memory allocation, recompilation, and transactional
Instruction by one of the world's leading experts:
William R. Stanek -- no substitutes, no second-stringers.
I teach all classes. There will never be a substitute. Here's the bio blurb if you need to know more:
William R. Stanek (firstname.lastname@example.org) has over 20 years of hands-on experience with advanced programming and development. He is a leading technology expert and an award-winning author. Over the years, his practical advice has helped millions of programmers, developers and network engineers all over the world. He has written over 50 computer books, which are sold all over the world and there are more than 3 million copies of his books in print. Current or forthcoming books include Windows Server 2008 Inside Out, Windows Command-Line Administrator's Pocket Consultant, Windows Server 2003 Administrator's Pocket Consultant 2nd Edition, Windows Server 2008 Administrator's Pocket Consultant, Windows Vista Administrator's Pocket Consultant and IIS 7.0 Administrator's Pocket Consultant.
William has been involved in the commercial Internet community since 1991. His core business and technology experience comes from over 11 years of military service. He has substantial experience in developing server technology, encryption, and Internet solutions. He has written many technical white papers and training courses on a wide variety of topics. He is widely sought after as a subject matter expert.
William has an MS in Information Systems degree with distinction and a BS Computer Science degree magna cum laude. He is proud to have served in the Persian Gulf War as a combat crewmember on an electronic warfare aircraft. He flew on numerous combat missions into Iraq and was awarded nine medals for his wartime service, including one of the United States of America's highest flying honors, the Air Force Distinguished Flying Cross. Currently, he resides in the Pacific Northwest with his wife and children.
Speed and ease of reference are essential parts of this hands-on guide. The book has an expanded table of contents and an extensive index for finding answers to problems quickly. Many other quick reference features have been added to the book as well. These features include quick step-by-steps, lists, tables with fast facts, and cross-references. The book is broken down into both parts and chapters. The parts contain a part-opener paragraph or two about the chapters grouped in that part.
Part I, “Microsoft SQL Server 2008 Administration Fundamentals,” covers the fundamental tasks you need for SQL Server administration. Chapter 1 provides an overview of SQL Server administration tools, techniques, and concepts. Chapter 2 discusses deploying SQL Server. Chapter 3 shows you how to configure SQL Server’s services, components and networking capabilities. Chapter examines the structures available for configuring and tuning SQL Server. The chapter looks at SQL Server 2008’s system catalog then continues with a discussion of catalog queries and stored procedures.
In Part II, “Microsoft SQL Server 2008 Administration,” you’ll find the essential tasks for administering SQL Server. Chapter 5 details management techniques for server groups and servers. Chapter 6 explores configuring and tuning SQL Server using SQL Server Management Studio. You’ll learn about optimizing memory usage, parallel processing, authentication, auditing, and more. The core administration tasks for creating and managing databases are covered in Chapter7 with a logical follow-up Chapter 8 on SQL Server security. To manage server security, you’ll create user logins, configure login permissions, and assign roles. The permissions and roles you assign determine the actions users can perform as well as what types of data they can access.
SQL Server data administration is the subject of Part III. Chapter 9 covers techniques for creating, managing, and optimizing schemas, tables, indexes, and views. In Chapter 10, you’ll find tasks for importing and exporting data as well as the old standby bulk copy program (BCP). Chapter 11 focuses on integrating SQL Server databases with other SQL Server databases and with other data sources. You’ll find detailed discussions on distributed queries, distributed transactions, Microsoft Distributed Transaction Coordinator (MS DTC), and linked servers. Chapter 12 explores data replication. You’ll learn all about the latest replication techniques, including merge replication and immediate-updating subscribers.
Part IV, “Performance, Optimization, and Maintenance,” covers administration tasks you’ll use to enhance and maintain SQL Server. Chapter 13 provides the essentials for working with server logs, monitoring SQL Server performance, and solving performance problems. Chapter 14 starts by explaining how to create a backup and recovery plan. Afterward, the chapter dives into common tasks for creating and restoring backups. Chapter 15 explores database automation and maintenance, showing how to create alerts, schedule jobs, handle operator notifications, and more. You’ll also learn how to create maintenance plans and resolve database consistency problems.
This book is available everywhere Microsoft books are sold. I hope you'll order the book from your favorite bookstore. All on-line bookstores carry the book as well. Here's the direct link to order the book at these bookstores:
The obligatory copyright statement:
©William R. Stanek 2004-2008. All Rights Reserved.