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.
About the Author
Leonard Lobel is Chief Technology Officer and cofounder of Sleek Technologies Inc., a New York based development firm specializing in Microsoft-based solutions. He is also a principal consultant at twentysix New York, a Microsoft Gold Certified Partner.
Andrew J. Brust, MVP, is Chief, New Technology at twentysix New York. Brust serves as Microsoft Regional Director for New York and New Jersey, is an MVP for Visual Basic, and is a member of Microsoft’s Business Intelligence Partner Advisory Council.
Stephen Forte, MVP, is the Chief Strategy Officer of Telerik, a Microsoft Gold Certified partner. Forte is the founder of the NYC .NET Developer User Group, and has written several books on application and database development.
Table of Contents: Core Fundamentals
· Overview
· T-SQL Enhancements
· Exploring SQL CLR
· Server Management
· Security in SQL Server 2008
Beyond Relational
· XML and the Relational Database
· Hierarchical Data and the Relational Database
· Using FILESTREAM for Unstructured Data Storage
· Geospatial Data Types
Reach Technologies
· The Microsoft Data Access Machine
· The Many Facets of .NET Data Binding
· Transactions
· Developing Occasionally Connected Systems
Business Intelligence
· Data Warehousing
· Basic OLAP
· Advanced OLAP
· OLAP Queries, Tools, and Application Development
· Expanding Your Business Intelligence with Data Mining
· Reporting Services
