SQL Server 2005 is next generation of SQL Server database and represents a massive leap forward for SQL Server developers in terms of programming options, productivity, database management and analysis. This book will take a deep look at the full range of SQL Server enhancements that will give meani
Pro SQL Server 2005
โ Scribed by Thomas Rizzo, Adam Machanic, Julian Skinner, Louis Davidson, Robin Dewson, Jan Narkiewicz, Joseph Sack, Rob Walters (auth.)
- Publisher
- Apress
- Year
- 2006
- Tongue
- English
- Leaves
- 687
- Edition
- 1
- Category
- Library
No coin nor oath required. For personal study only.
โฆ Synopsis
SQL Server 2005 is a dramatically expanded and enhanced version of SQL Server 2000 that not only makes SQL Server a true enterprise-level RDBMS, but also changes how SQL Server professionals design databases and develop database applications.
Pro SQL Server 2005 provides in-depth coverage of new SQL Server features and enhancements. It focuses on what experienced SQL Server database administrators, developers, and business intelligence practitioners need to know to get up to speed with SQL Server 2005 as quickly as possible. It carefully presents each new feature and precisely illustrates the feature with examples that show you how to use it effectively.
The authors provide practical, in-depth coverage of the core topics that they specialize inall supported by realistic examples, so you'll be able to design and implement your own SQL Server 2005 solutions quickly and painlessly. This book is a roadmap for exploring and exploiting SQL Server 2005. So fasten your seatbelts, start your computers, and race to mastery of SQL Server 2005!
โฆ Table of Contents
Front Matter....Pages i-xxvii
SQL Server Overview and Installation....Pages 1-23
SQL Server Management Technologies....Pages 25-52
T-SQL Enhancements for Developers....Pages 53-101
T-SQL Enhancements for DBAs....Pages 103-133
.NET Integration....Pages 135-159
Programming Assemblies....Pages 161-206
SQL Server and XML....Pages 207-245
SQL Server 2005 XML and XQuery Support....Pages 247-286
SQL Server 2005 Reporting Services....Pages 287-346
Analysis Services....Pages 347-385
Security....Pages 387-417
Service Broker....Pages 419-457
Automation and Monitoring....Pages 459-505
Integration Services....Pages 507-565
Database Mirroring....Pages 567-607
Notification Services....Pages 609-643
Back Matter....Pages 645-674
โฆ Subjects
Programming Languages, Compilers, Interpreters; Information Storage and Retrieval
๐ SIMILAR VOLUMES
SQL Server 2005 is the next generation of SQL Server database and represents a massive leap forward in terms of programming options, productivity, database management, and analysis. This book takes a deep look at the full range of SQL Server enhancements, and includes meaningful and relevant example
Pro SQL Server 2005 Assemblies provides a detailed and example-driven tutorial on how to build and use .NET assemblies. The authors focus on building assemblies in C#, but also provide the equivalent VB .NET code in the supplied code download.Assemblies are not a complete replacement for T-SQL store