Programming Microsoft® SQL Server® 2008 (PRO-Developer)

Книга Programming Microsoft SQL Server 2008 Programming Microsoft SQL Server 2008Книги SQL / MySQL Автор: Leonard Lobel, Andrew J. Brust Год издания: 2008 Формат: chm Издат.:Microsoft Press Страниц: 976 Размер: 16.98 Мб ISBN: 0-7356-2599-9, 978-0-7356-2599-0 Язык: Английский0 (голосов: 0) Оценка:Product DescriptionWritten by industry professionals who have been working with SQL Server 2008 since the earliest code, this reference expertly covers the programming fundamentals for SQL Server 2008 with crucial real-world context and extensive code samples.Get the hands-on programming instruction, practical examples, and best practices you need to master the core programmability features in SQL Server 2008. Led by three experts in database design and business intelligence solutions, you ll learn the essential tools and techniques for developing robust applications. Discover how to:-Program views, stored applications, triggers, and functions using T-SQL-Work with the new data types, LINQ, and the ADO.NET Entity Framework-Automate common administration and maintenance tasks-Debug databases, reports, and objects using Microsoft Visual Studio® 2008-Write transactional code and implement local and distributed transactions-Use business intelligence tools, such as SQL Server Reporting Services, SQL Server Analysis Services, and SQL Server Integration ServicesMany of the book s examples, exercises, and code samples are available for download from the companion Web site.

Extend your programming skills with a comprehensive study of the key features of SQL Server 2008. Delve into the new core capabilities, get practical guidance from expert developers, and put their code samples to work. This is a must-read for Microsoft .NET and SQL Server developers who work with data access—at the database, business logic, or presentation levels.

Discover how to:

• Query complex data with powerful Transact-SQL enhancements
• Use new, non-relational features: hierarchical tables, native file streaming, and geospatial capabilities
• Exploit XML inside the database to design XML-aware applications
• Consume and deliver your data using Microsoft LINQ, Entity Framework, and data binding
• Implement database-level encryption and server auditing
• Build and maintain data warehouses
• Use Microsoft Excel to build front ends for OLAP cubes, and MDX to query them
• Integrate data mining into applications quickly and effectively

Get code samples on the Web.

Provides programming instructions and code examples for Microsoft SQL Server 2008.