Programming SQL Server 2005, O'Reilly
Microsoft .NET Framework, ASP.NET, Visual C# (CSharp, C Sharp, C-Sharp) Developer Training, Visual Studio
|
Contents |
C# Online.NET Book Review
This book covers all important aspects of SQL Server 2005 which is an entirely different animal than SQL Server 2000. However, in the cases of ADO.NET and Transact-SQL (T-SQL), only the latest enhancements and features are explained. And, the book does a great job with detailed coverage of Common Language Runtime (CLR) integration, SQL Server Management Objects (SMO), SQL Server Analysis Services (SSAS), and SQL Server Integration Services (SSIS).
The focus is on the new features and ways of doing things with virtually no reference to the differences between the old and the new SQL Server versions. So, this is not specifically an "upgrade" book.
The author writes in the clear, concise, but dry style familiar to—if not preferred by—most technical readers.In fact, it reads very much like a technical manual. In many ways, this is a prototypical O'Reilly book and will be familiar to O'Reilly fans.
As befits a book on programming, the book is chock full of source code examples; and, screen shots are used when helpful. Although there are several massive multipage examples, the examples tend to be small demonstration programs or snippets.
All of the source code examples are in the C# language; and, most use Visual Studio 2005.
Bottom line
Programming SQL Server 2005 is a thoroughly practical primer and reference for SQL Server developers.
Publisher's description
Ideal for IT professionals of all stripes, this authoritative guide introduces all facets of SQL Server 2005, Microsoft's next-generation data management and analysis solution. The book explains all of its new features, and shows you how they can help conquer a variety of data challenges. Learn how to reduce the complexity of building, deploying and managing database applications, and much more.
SQL Server 2005, Microsoft's next-generation data management and analysis solution, represents a huge leap forward. It comes with a myriad of changes that deliver increased security, scalability, and power--making it the complete data package. Used properly, SQL Server 2005 can help organizations of all sizes meet their data challenges head on.
Programming SQL Server 2005 from O'Reilly provides a practical look at this updated version of Microsoft's premier database product. It guides you through all the new features, explaining how they work and how to use them. The first half of the book examines the changes and new features of the SQL Server Engine itself. The second addresses the enhanced features and tools of the platform, including the new services blended into this popular version. Each chapter contains numerous code samples-written in C# and compiled using the Visual Studio 2005 development environment-that show you exactly how to program SQL Server 2005.
Programming SQL Server 2005 can help you:
- Build, deploy, and manage enterprise applications that are more secure, scalable, and reliable
- Maximize IT productivity by reducing the complexity of building, deploying, and managing database applications
- Share data across multiple platforms, applications, and devices to make it easier to connect internal and external systems
Because the goal of Programming SQL Server 2005 is to introduce all facets of Programming SQL Server 2005, it's beneficial to programmers of all levels. The book can be used as a primer by developers with little experience with SQL Server, as a ramp up to the new programming models for SQL Server 2005 for more experienced programmers, or as background and primer to specific concepts.
Any IT professional who wants to learn about SQL Server 2005's comprehensive feature set, interoperability with existing systems, and automation of routine tasks will find the answers in this authoritative guide.
About the author(s)
Bill Hamilton is the author of the highly praised ADO.NET Cookbook. He is an enterprise architect specializing in designing, developing and implementing enterprise applications using .NET and J2EE technologies. Over the last fifteen years, Bill has provided consulting services for B2B, B2C, B2E, enterprise application integration, portal initiatives, and custom application development for financial services, retail, professional services, and manufacturing clients. Bill is also the author of O'Reilly's NUnit Pocket Reference, the co-author of ADO.NET in a Nutshell, and also writes for Microsoft Developer Network.
Table of Contents (abbreviated)
- 1. Introduction
- 2. Tools and Utilities
- 3. T-SQL Enhancements
- 4. Introduction to Common Language Runtime (CLR) Integration
- 5. Programming SQL Server CLR Routines
- 6. .NET Client-Side Programming
- 7. XML Data
- 8. Native XML Web Services
- 9. SQL Server Management Objects (SMO)
- 10. SQL Server Management Objects (SMO) Instance Classes, Part 1
- 11. SQL Server Management Objects (SMO) Instance Classes, Part 2
- 12. SQL Server Management Objects (SMO) Utility Classes
- 13. Programming Windows Management Instrumentation (WMI)
- 14. SQL Server Reporting Services (SSRS)
- 15. SQL Server Integration Services (SSIS)
- 16. SQL Server Agent
- 17. Service Broker
- 18. Notification Services
- 19. Replication
- 20. SQL Server Analysis Services (SSAS)
- 21. SQL Server Mobile Edition
- Appendix: ADO.NET 2.0
