Microsoft SQL Server 2005 Unleashed provides extensive coverage of SQL Server 2005, offering insights that extend beyond basic syntax found in manuals. The authors draw from real-world experience to elevate your understanding and practical skills. Targeted primarily at system and database administrators, as well as those who fulfill both DBA and developer roles, the book covers new features and enhancements in SQL Server 2005, including .NET Framework integration, Integration Services, Service Broker, Database Mirroring, Snapshots, and Reporting Services. The content is organized into several parts: 1. An overview of SQL Server 2005 and its new features. 2. Tools and utilities like SQL Server Management Studio and Profiler. 3. Administration topics including installation, upgrading, security, backup and restore, and high availability. 4. Database administration covering the creation and management of databases, tables, indexes, views, stored procedures, and triggers. 5. Performance and optimization strategies, including query optimization and database design. 6. Application development with updates for Transact-SQL, XML usage, and web services. 7. Business intelligence features, including Analysis Services and Reporting Services. Bonus chapters on the accompanying CD delve into advanced topics such as disaster recovery planning and managing large databases, providing a comprehensive resource for both beginners and experien
Chris Gallelli Pořadí knih (chronologicky)
