- Microsoft SQL Server 2005 Unleashed

- <>Microsoft SQL Server 2005 Unleashed offers comprehensive coverage of SQL Server 2005 that goes beyond the basic syntax and information you’ll find in the product manuals, providing in-depth information derived from the authors’ real-world experience to help you build upon your working knowledge of the product and take your experience and knowledge to a higher level. This book focuses primarily on the information needed by system and database administrators, as well as for users with overlapping duties as both DBA and developer. Included is extensive coverage of the new features and upgraded tools and capabilities of SQL Server 2005, including .NET Framework integration, Integration Services, Service Broker, Database Mirroring and Snapshots, and Reporting Services.
Detailed information on…
- Installing, upgrading, and administering SQL Server 2005
- Database maintenance, backup, and recovery
- Creating and managing tables, views, stored procedures, triggers, and user-defined functions
- Database and index design
- SQL Server query optimization, and performance monitoring and tuning
- Transactions, transaction management, and distributed transactions
- SQL Server Management Studio—NEW!
- SQL Server Notification Services; Integration Services—NEW!; Analysis Services; Reporting Services—NEW!; Web Services—NEW!
- SQL Server Service Broker—NEW!
- SQL Server and Microsoft .NET Framework integration, including CLR-based stored procedures, functions, and triggers—NEW!
- SQL Server high availability and SQL Server clustering and replication
- Database Mirroring—NEW!
- Database Snapshots—NEW!
- Using XML in SQL Server 2005
- SQL Server tools and utilities
CD-ROM includes
- 8 bonus chapters covering topics such as Notification Services, Service Broker, and Full-Text Search
- Code samples, scripts, and sample databases
- A PDF version of the entire book
Introduction
Part I Welcome to Microsoft SQL Server
1 SQL Server 2005 Overview
2 What’s New in SQL Server 2005
Part II SQL Server Tools and Utilities
3 SQL Server Management Studio
4 SQL Server Command-Line Utilities
5 SQL Server Profiler
Part III SQL Server Administration
6 SQL Server System and Database Administration
7 Installing SQL Server 2005
8 Upgrading to SQL Server 2005
9 Client Installation and Configuration
10 Security and User Administration
11 Database Backup and Restore
12 Database Mail
13 SQL Server Scheduling and Notification
14 SQL Server High Availability.
15 Replication
16 Database Mirroring
17 SQL Server Clustering
Part IV Database Administration
18 Creating and Managing Databases
19 Creating and Managing Tables
20 Creating and Managing Indexes
21 Implementing Data Integrity
22 Creating and Managing Views in SQL Server
23 Creating and Managing Stored Procedures
24 Creating and Managing User-Defined Functions
25 Creating and Managing Triggers
26 Transaction Management and the Transaction Log
27 Database Snapshots
28 Database Maintenance
Part V SQL Server Performance and Optimization
29 Indexes and Performance
30 Understanding Query Optimization
31 Query Analysis
32 Locking and Performance
33 Database Design and Performance
34 Monitoring SQL Server Performance
Part VI SQL Server Application Development
35 What’s New for Transact-SQL in SQL Server 2005
36 SQL Server and the .NET Framework
37 Using XML in SQL Server 2005
38 SQL Server Web Services
Part VII SQL Server Business Intelligence Features
39 SQL Server 2005 Analysis Services
40 SQL Server Integration Services
41 SQL Server 2005 Reporting Services
Bonus Chapters on the CD
42 Managing Linked and Remote Servers
43 Configuring, Tuning, and Optimizing SQL Server Options
44 Administering Very Large SQL Server Databases
45 SQL Server Disaster Recovery Planning
46 Transact-SQL Programming Guidelines, Tips, and Tricks
47 SQL Server Notification Services
48 SQL Server Service Broker
49 SQL Server Full-Text Search
Index
- Windows Server 2008 Inside Out

- Learn how to conquer Windows Server 2008 from the inside out! Designed for system administrators, this definitive resource features hundreds of timesaving solutions, expert insights, troubleshooting tips, and workarounds for administering Windows Server 2008 all in concise, fast-answer format. You will learn how to perform upgrades and migrations, automate deployments, implement security features, manage software updates and patches, administer users and accounts, manage Active Directory® directory services, and more. With INSIDE OUT, you ll discover the best and fastest ways to perform core administrative tasks, with an award-winning format that makes it easy to find exactly the tips, troubleshooting solutions, and workarounds you need. Plus, the companion CD comes packed with a fully searchable eBook and more than 100 timesaving tools and scripts. With INSIDE OUT, you get all muscle and no fluff!
Key Book Benefits
Drills into the features and functions in Microsoft Office Word, delivering comprehensive details but no fluff in a single volume
Includes a companion CD packed with tools, scripts, and a fully searchable eBook
- Microsoft SQL Server 2005 Reporting Services 2005

- Microsoft's Reporting Services product is a vital part of the SQL Server 2005 business intelligence platform, but it works with virtually any data source. This hands-on guide explains how to transform data into insightful and interactive Web-based reports using Microsoft SQL Server 2005 Reporting Services. 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.
- Windows Server 2008 Unleashed

Windows Server 2008 Unleashed covers the planning, design, prototype testing, implementation, migration, administration, and support of a Windows 2008 and Active Directory environment, based on more than three and a half years of early adopter experience in full production environments. This book addresses not only what is new with Windows 2008 compared to previous versions of the Windows Server product, but also what is different and how the similarities and differences affect an organization’s migration to Windows 2008. Chapters are dedicated to the migration process from Windows 2000/2003 to Windows 2008, how to properly use Group Policies in Windows 2008, and tips and tricks on managing and administering a Windows 2008 environment.
The authors cover the technologies new to Windows 2008, such as IPv6, Network Access Protection (NAP), Network Policy Server (NPS), Terminal Services Remote Programs, Windows Deployment Services (WDS), Hyper-V virtualization, and more! This book doesn’t just describe the features and functions included in Windows 2008--there are notes throughout the book explaining how organizations have successfully used the technologies to fulfill core business needs. Tips, tricks, and best practices share lessons learned from hundreds of implementations of Windows 2008 in real-world environments.
Detailed information on how to…
- Plan and migrate from Windows 2000/2003 to Windows 2008
- Leverage new tools and utilities that simplify system and network administration functions
- Enable the latest security technologies to improve secured enterprise computing
- Better manage a Windows 2008 Active Directory environment
- Optimize a Windows 2008 environment for better scalability and enhanced performance
- Implement Windows 2008 for better branch office and remote office integration
- Design a Windows 2008 environment to support the latest in clustering, stretched clusters, fault tolerance, and redundant systems technologies
- Take advantage of add-on technologies available for Windows 2008, including Windows SharePoint Services, Microsoft Hyper-V virtualization, Windows Media Services, and IIS 7 web server solutions
Rand, Michael, Ross, and Chris work for Convergent Computing, an IT consulting firm in the San Francisco Bay area that has three and a half years of early adopter experience with Windows 2008. In collaboration with co-author Omar Droubi, the authors helped organizations of all sizes plan, migrate, implement, and test Windows 2008 in production environments. The book was written from direct experiences where Windows 2008 was put into enterprise production environments focused to meet specific strategic business requirements.
Category: Windows Server
Covers: Windows Server 2008
User Level: Intermediate--Advanced
Introduction xlix
Part I: Windows Server 2008 Overview
1: Windows Server 2008 Technology Primer 3
2: Planning, Prototyping, Migrating, and Deploying Windows Server 2008 Best Practices 39
3: Installing Windows Server 2008 and Server Core 73
Part II: Windows Server 2008 Active Directory
4: Active Directory Domain Services Primer 105
5: Designing a Windows Server 2008 Active Directory 139
6: Designing Organizational Unit and Group Structure 165
7: Active Directory Infrastructure 185
8: Creating Federated Forests and Lightweight Directories 217
9: Integrating Active Directory in a UNIX Environment 235
Part III: Networking Services
10: Domain Name System and IPv6 251
11: DHCP/WINS/Domain Controllers 297
12: Internet Information Services 331
Part IV: Security
13: Server-Level Security 375
14: Transport-Level Security 399
15: Security Policies, Network Policy Server, and Network Access Protection 415
Part V: Migrating to Windows Server 2008
16: Migrating from Windows 2000/2003 to Windows Server 2008 439
17: Compatibility Testing for Windows Server 2008 473
Part VI: Windows Server 2008 Administration and Management
18: Windows Server 2008 Administration 499
19: Windows Server 2008 Group Policies and Policy Management 533
20: Windows Server 2008 Management and Maintenance Practices 581
21: Automating Tasks Using PowerShell Scripting 639
22: Documenting a Windows Server 2008 Environment 685
23: Integrating Systems Center Operations Manager 2007 with Windows Server 2008 715
Part VII: Remote and Mobile Technologies
24: Server-to-Client Remote and Mobile Access 737
25: Terminal Services 783
Part VIII: Desktop Administration
26: Windows Server Administration Tools for Desktops 839
27: Group Policy Management for Network Clients 865
Part IX: Fault Tolerance Technologies
28: File System Management and Fault Tolerance 935
29: System-Level Fault Tolerance (Clustering/Network Load Balancing) 993
30: Backing Up the Windows Server 2008 Environment 1043
31: Recovering from a Disaster 1077
Part X: Optimizing, Tuning, Debugging, and Problem Solving
32: Optimizing Windows Server 2008 for Branch Office Communications 1111
33: Logging and Debugging 1145
34: Capacity Analysis and Performance Optimization 1189
Part XI: Integrated Windows Application Services
35: Windows SharePoint Services 3.0 1233
36: Windows Media Services 1281
37: Deploying and Using Windows Virtualization 1313
Index 1339
- Windows Server® 2008 Resource Kit

- Get the essential reference for deploying, managing, automating, troubleshooting, and optimizing Windows Server 2008 with expert insights and best practices from Microsoft Most Valuable Professionals (MVPs) and the Windows Server team at Microsoft. This official Microsoft® RESOURCE KIT features six volumes of in-depth technical information that every Windows® administrator needs to understand to master Windows Server 2008 administration. You get detailed information about networking, network aspect projection, security features, Internet Information Services (IIS) 7.0, Active Directory®, and Windows PowerShellTM. You also get more than 200 time-saving tools, scripts for automation, job aids, eBook resources, plus a fully searchable eBook of each RESOURCE KIT volume on DVD.
Key Book Benefits:
Provides six volumes of in-depth technical information for administering, optimizing, troubleshooting, and automating Windows Server 2008
Delivers definitive product information with expert insights straight from the Windows Server team at Microsoft, Microsoft MVPs, and field consultants
Details information that every Windows administrator needs about Windows Server performance, troubleshooting, security services, group policy, Active Directory, IIS 7, and Windows PowerShell
Features a DVD with more than 200 essential tools and scripts, eBooks with additional technical information, tips, and best practices plus a fully searchable eBook of all six RESOURCE KIT volumes
- Microsoft Office SharePoint Server 2007 Best Practices

- Get field-tested best practices and proven techniques for designing, deploying, operating, and optimizing Microsoft Office SharePoint Server 2007 and Windows SharePoint Services 3.0. Part of the new Best Practices series for IT professionals from Microsoft Press®, this guide is written by leading SharePoint MVPs and Microsoft SharePoint team members who ve worked extensively with real-world deployments and customers. You ll find out how to deploy the software, design your environment, manage content, analyze and view data, perform disaster recovery, monitor performance, and more. You'll learn how to create SharePoint sites that help your organization collaborate, take advantage of business insights, and improve productivity with practical insights from the experts.
Key Book Benefits:
Delivers authoritative, field-tested best practices for working with Microsoft SharePoint solutions Covers the full IT lifecycle, from planning, design, and deployment through operations and support Includes a CD with job aids, utilities, and a fully searchable eBook
- Beginning SQL Server 2005 Administration

- For the first time, SQL Server 2005 provides features that can support large-scale enterprise databases. With this powerful new release, you may find yourself being called upon to perform duties that are no longer strictly "administrative," duties that have become much more complicated and difficult. With that in mind, a team of experienced Microsoft Certified Professionals provides you with the necessary information to be a more competent and successful database developer or administrator.
Beginning with a foundation that features detailed coverage of typical administrative duties, the authors proceed to explain how to build complex data transformations for data import, build distributed data solutions, and maintain the security and integrity of the database. You will be able to apply what you learn to real-world scenarios, and smoothly navigate the vastly changed landscape of SQL Server 2005 administration.
What you will learn from this book
- How to install, maintain, and manage an SQL Server 2005 installation, including high availability and security considerations
- Various features such as the Common Language Runtime, SQL Server Integration Services, Notification Service, and the Service Broker
- How to use the tools that are necessary to manage configuration, backups, restores, security, availability, performance, and monitoring
- A sampling of some of the more advanced areas and complex jobs of the broadening role of a database administrator in the enterprise
Who this book is for
This book is for both developers and administrators who are responsible for the management and maintenance of an SQL Server 2005 database. Familiarity with relational database concepts and SQL is assumed.
Wrox Beginning guides are crafted to make learning programming languages and technologies easier than you think, providing a structured, tutorial format that will guide you through all the techniques involved.
Enhance Your Knowledge Advance Your Career
- Microsoft SQL Server(TM) 2005 Administrator's Companion (Pro - Administrator's Companion)

- 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. Discover how to: Perform an installation or upgrade, and configure it on the network Plan and configure the I/O subsystem and model system capacity Create and maintain databases, tables, views, and indexes Administer transactions, deadlocks, and isolation levels Manage users with logins, user IDs, schemas, permissions, and roles Implement failover clustering, log shipping, and database mirroring for high availability Manage and tune snapshot, transactional, and merge replication Administer SQL Server Analysis Services and Reporting Services Monitor, troubleshoot, and fine-tune performance Includes a CD with a fully searchable eBook.
- SQL Server 2008 Transact-SQL Recipes: A Problem-Solution Approach (Recipes: a Problem-Solution Approach)

SQL Server 2008 Transact–SQL Recipes: A Problem–Solution Approach is an example–based guide to the Transact–SQL language that is at the core of SQL Server 2008. Learn to create databases, insert and update data, generate reports, secure your data, and more. Author Joseph Sack takes common Transact–SQL tasks and breaks them down into a problem/solution format that is quick and easy to read so that you can get the job done fast when the pressure is on.
- Focused on solutions: Look up what you need to do. Learn how to do it. Do it.
- Current: Newly updated for SQL Server 2008.
- Comprehensive: Covers 30 different Transact–SQL problem domains.
What you’ll learn
- Create databases, tables, and indexes.
- Query and manipulate data.
- Store and manage XML inside the database.
- Move business logic into the database.
- Encrypt data and capture changes for compliance purposes.
- Implement Full–Text Search.
- Interface with Service Broker.
- And more!
Who is this book for?
Developers who use Microsoft SQL Server 2008 as their back–end database. Database administrators who create, manage, and secure those databases.
- Professional Microsoft SQL Server 2008 Administration (Wrox Programmer to Programmer)

- Loaded with unique tips, tricks and workarounds for handling the most difficult SQL Server admin issues, Professional Microsoft SQL Server 2008 Administration is a how-to guide for experienced DBAs. Understand how to manage and monitor the SQL Server, automated administration, security, change management, performance tuning, scaling and replication, clustering, and backup and recovery. This updated edition includes new information about Change Data Capture, Performance Studio, Query Governor, and new techniques for monitoring and policy management so that you can have the latest and most comprehensive information at your fingertips.