Programming Microsoft SQL Server 2008 - Brossura

Lobel, Leonard; Brust, Andrew J.; Forte, Stephen

Brossura

ISBN 10: 0735625999 ISBN 13: 9780735625990

Casa editrice: Microsoft Pr, 2008

Riassunto

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.

Su questo libro

L'autore

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.

Contenuti

AcknowledgmentsIntroductionPart I: Core Fundamentals

• Chapter 1: Overview
• Chapter 2: T-SQL Enhancements
• Chapter 3: Exploring SQL CLR
• Chapter 4: Server Management
• Chapter 5: Security in SQL Server 2008

Part II: Beyond Relational

• Chapter 6: XML and the Relational Database
• Chapter 7: Hierarchical Data and the Relational Database
• Chapter 8: Using FILESTREAM for Unstructured Data Storage
• Chapter 9: Geospatial Data Types

Part III: Reach Technologies

• Chapter 10: The Microsoft Data Access Machine
• Chapter 11: The Many Facets of .NET Data Binding
• Chapter 12: Transactions
• Chapter 13: Developing Occasionally Connected Systems

Part IV: Business Intelligence

• Chapter 14: Data Warehousing
• Chapter 15: Basic OLAP
• Chapter 16: Advanced OLAP
• Chapter 17: OLAP Queries, Tools, and Application Development
• Chapter 18: Expanding Your Business Intelligence with Data Mining
• Chapter 19: Reporting Services

About the AuthorsAdditional Resources for Developers from Microsoft PressMore Great Developer Resources

Dettagli dell?edizione

• Editore: Microsoft Pr
• Data di pubblicazione: 2008
• ISBN 10: 0735625999
• ISBN 13: 9780735625990
• Rilegatura: Copertina flessibile
• Lingua: Inglese
• Numero di pagine: 979