Programming Microsoft SQL Server 2008
Search in google:
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.
Pt. I Core Fundamentals1 Overview 32 T-SQL Enhancements 133 Exploring SQL CLR 1114 Server Management 1615 Security in SQL Server 2008 189 Pt. II Beyond Relational6 XML and the Relational Database 2317 Hierarchical Data and the Relational Database 2818 Using FILESTREAM for Unstructured Data Storage 3079 Geospatial Data Types 341 Pt. III Reach Technologies10 The Microsoft Data Access Machine 37711 The Many Facets of NET Data Binding 41912 Transactions 44913 Developing Occasionally Connected Systems 491 Pt. IV Business Intelligence14 Data Warehousing 56315 Basic OLAP 61116 Advanced OLAP 63917 OLAP Queries, Tools, and Application Development 71718 Expanding Your Business Intelligence with Data Mining 79319 Reporting Services 879 Index 953
![SQL Queries for Mere Mortals: A Hands-on Guide to Data Manipulation in SQL [For Mere Mortals Series]](/application/data/covers/44/31/9780321444431.jpg "SQL Queries for Mere Mortals: A Hands-on Guide to Data Manipulation in SQL [For Mere Mortals Series]")
