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

Brust, Andrew; Lobel, Leonard; Forte, Stephen

Softcover

ISBN 10: 0735625999 ISBN 13: 9780735625990

Publisher: Microsoft Press US, 2008

Synopsis

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.

About this title

Synopsis

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: *Leverage the latest T-SQL programming enhancements, using table-valued parameters, MERGE, GROUPING SETS, and new date/time and time-zone capabilities *Work with semistructured and unstructured data using XML, and the new "beyond relational" features, such as native file streaming, hierarchical tables, and spatial data types *Automate common administration and maintenance tasks *Work with the new data types, LINQ, the ADO.NET Entity Framework, WPF, and Silverlight Data binding *Write transactional code and implement local and distributed transactions *Use business intelligence tools, such as SQL Server Reporting Services and SQL Server Analysis Services

About the Author

Leonard Lobel is a principal consultant at Tallan, a Microsoft Gold Certified Partner.

Stephen Forte is the cofounder and CTO of Corzen, Inc. He is also a Microsoft Regional Director for New York and a Microsoft MVP.

Edition details

• Publisher: Microsoft Press US
• Publication date: 2008
• ISBN 10: 0735625999
• ISBN 13: 9780735625990
• Binding: Paperback
• Language: English
• Number of pages: 1024