Beginning
Microsoft
®
SQL Server
®
2008 Administration
Professional Microsoft SQL Server 2008 Integration
Services
978-0-470-24795-2
This book shows developers how to master the 2008 release of SSIS, covering topics
including data warehousing with SSIS, new methods of managing the SSIS platform,
and improved techniques for ETL operations.
Professional SQL Server 2008 Reporting Services
978-0-470-24201-8
This book teaches solutions architects, designers, and developers how to use
Microsoft’s reporting platform to create reporting and business intelligence solutions.
Professional Microsoft SQL Server 2008 Analysis Services
978-0-470-24798-3
This shows readers how to build data warehouses and multidimensional databases,
query databases, and how to use Analysis Services and other components of SQL
Server to provide end-to-end solutions.
Professional Microsoft SQL Server 2008 Programming
978-0-470-25702-9
This updated new edition of Wrox’s best-selling SQL Server book has been expanded
to include coverage of SQL Server 2008’s new datatypes, new indexing structures,
manageability features, and advanced time-zone handling.
Professional Microsoft SQL Server 2008 Administration
978-0-470-24796-9
A how-to guide for experienced database administrators, this book is loaded with
unique tips, tricks, and workarounds for handling the most difficult SQL Server
administration issues. The authors discuss data capture, performance studio, Query
Governor, and new techniques for monitoring and policy management.
Beginning Microsoft SQL Server 2008 Programming
978-0-470-25701-2
This comprehensive introduction to SQL Server covers the fundamentals and moves on to discuss how to create and change tables, manage
keys, write scripts, work with stored procedures, and much more.
Beginning Microsoft SQL Server 2008 Administration
978-0-470-44091-9
This book teaches both novice and experienced database administrators how to leverage all of the features of SQL Server to deliver solid,
reliable performance. All features and techniques are illustrated with real-world examples and step-by-step instructions. With this book, you’ll
develop the skills required to successfully administer a SQL Server 2008 database, regardless of your experience level.
Beginning Database Design Solutions
978-0-470-38549-4
This introduces IT professionals—both DBAs and database developers—to database design. It explains what databases are, their goals,
and why proper design is necessary to achieve those goals. It tells how to decide what should be in a database to meet the application’s
requirements. It tells how to structure the database so the database performs well while minimizing the chance for error.
Enhance Your Knowledge
Advance Your Career
Get more out of
WROX.com
Programmer to Programmer
™
Interact
Take an active role online by participating in
our P2P forums
Wrox Online Library
Hundreds of our books are available online
through Books24x7.com
Wrox Blox
Download short informational pieces and
code to keep you up to date and out of
trouble!
Chapters on Demand
Purchase individual book chapters in pdf
format
Join the Community
Sign up for our free monthly newsletter at
newsletter.wrox.com
Browse
Ready for more Wrox? We have books and
e-books available on .NET, SQL Server, Java,
XML, Visual Basic, C#/ C++, and much more!
Contact Us.
We always like to get feedback from our readers. Have a book idea?
Need community support? Let us know by e-mailing wrox-partnerwithus@wrox.com
spine=1.632"
Leiter ffirs.tex V2 - 03/25/2009 1:24pm Page i
Beginning Microsoft
®
SQL Server
®
2008 Administration
Introduction .....................................................................xxvii
Chapter 1: Introducing SQL Server 2008
...............................................1
Chapter 2: Installing SQL Server 2008
............................................... 25
Chapter 3: SQL Server 2008 Tools
................................................... 51
Chapter 4: SQL Server 2008 Storage Architecture
.................................... 111
Chapter 5: SQL Server 2008 Databases
............................................. 129
Chapter 6: SQL Server 2008 Security
............................................... 201
Chapter 7: Configuring SQL Server Network Communication
........................... 261
Chapter 8: Automating Administrative Tasks
........................................ 285
Chapter 9: Disaster Prevention and Recovery
........................................ 363
Chapter 10: Monitoring SQL Server
................................................. 401
Chapter 11: Optimizing SQL Server
................................................. 473
Chapter 12: SQL Server High Availability
............................................ 553
Chapter 13: Introduction to Replication
............................................. 589
Chapter 14: Introduction to the Common Language R untime
.......................... 607
Chapter 15: An Administrator’s Guide to Business Intelligence
........................ 639
Chapter 16: Introduction to SQL Server Integration Services
.......................... 645
Chapter 17: Introduction to SQL Server Analysis Services
............................. 677
Chapter 18: Introduction to SQL Server Reporting Services
............................ 707
Chapter 19: Introduction to Service Broker
.......................................... 733
Index
........................................................................... 755
Leiter ffirs.tex V2 - 03/25/2009 1:24pm Page ii
Leiter ffirs.tex V2 - 03/25/2009 1:24pm Page iii
Beginning
Microsoft
®
SQL Server
®
2008 Administration