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 accessaat 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.The Management Studio MDX query window with our sample cube loaded and its KPI displayed on the Metadata tab You ... Usinga combination of manual typing and draganddrop from the Metadata tab, enter the MDX code in Example 163anbsp;...
|Title||:||Programming Microsoft SQL Server 2008|
|Author||:||Andrew Brust, Leonard G. Lobel, Stephen Forte|
|Publisher||:||Microsoft Press - 2008-10-29|