Programming Microsoft SQL Server 2008 [NOOK Book]

( 2 )

Overview

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 ...
See more details below
Programming Microsoft SQL Server 2008

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$27.49
BN.com price
(Save 42%)$47.99 List Price

More About This Book

Overview

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.

Read More Show Less

Product Details

  • ISBN-13: 9780735638198
  • Publisher: Pearson Education
  • Publication date: 11/12/2008
  • Series: Developer Reference
  • Sold by: Barnes & Noble
  • Format: eBook
  • Edition number: 1
  • Pages: 1024
  • File size: 16 MB
  • Note: This product may take a few minutes to download.

Meet 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.
Read More Show Less

Table of Contents


Pt. I Core Fundamentals
1 Overview 3
2 T-SQL Enhancements 13
3 Exploring SQL CLR 111
4 Server Management 161
5 Security in SQL Server 2008 189 Pt. II Beyond Relational
6 XML and the Relational Database 231
7 Hierarchical Data and the Relational Database 281
8 Using FILESTREAM for Unstructured Data Storage 307
9 Geospatial Data Types 341 Pt. III Reach Technologies
10 The Microsoft Data Access Machine 377
11 The Many Facets of NET Data Binding 419
12 Transactions 449
13 Developing Occasionally Connected Systems 491 Pt. IV Business Intelligence
14 Data Warehousing 563
15 Basic OLAP 611
16 Advanced OLAP 639
17 OLAP Queries, Tools, and Application Development 717
18 Expanding Your Business Intelligence with Data Mining 793
19 Reporting Services 879 Index 953
Read More Show Less

Customer Reviews

Average Rating 3
( 2 )
Rating Distribution

5 Star

(0)

4 Star

(1)

3 Star

(0)

2 Star

(1)

1 Star

(0)
Sort by: Showing all of 2 Customer Reviews

  • Anonymous

    Posted Wed Dec 12 00:00:00 EST 2012

    No text was provided for this review.

  • Anonymous

    Posted Fri Apr 29 00:00:00 EDT 2011

    No text was provided for this review.

Sort by: Showing all of 2 Customer Reviews
If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)