Introducing Microsoft SQL Server 2005 for Developers (Paperback)

Description:

Get a head start evaluating integrated database development and debugging tools in SQL Server 2005.

Get a first look at the programming enhancements in SQL Server 2005 that deliver new levels of application scalability and interoperability with less complexity. Database expert Peter DeBetta takes you inside the technology—demonstrating how you can work seamlessly with Microsoft Visual Studio tools and the Microsoft .NET common language runtime from within SQL Server. You’ll also explore Transact-SQL (T-SQL) language advances, native XML support, a new security model, and other features—with advice on how to balance new capabilities with performance considerations. With DeBetta’s prerelease insights and T-SQL and C# code examples, you get everything you need to get productive right away.

Discover how to:
•Exploit native support for relational and XML data, including the new XQuery feature
•Work with Visual Studio tools and the common language runtime to create managed procedures and types
•Use Microsoft ADO.NET 2.0 for new data access capabilities, including asynchronous commands
•Improve scalability and simplify scripting with SQL Server Management Objects
•Use schemas and other new security features to help control permissions and access
•Deliver fully functional Web services with HTTP Endpoints—and related security services
•Accelerate development of enterprise data-management solutions with SQL Server Data Transformation Services, Reporting Services, and Notification Services