Programming Microsoft SQL Server 2012

( 2 )

Overview

Your essential guide to key programming features in Microsoft® SQL Server® 2012

Take your database programming skills to a new level—and build customized applications using the developer tools introduced with SQL Server 2012. This hands-on reference shows you how to design, test, and deploy SQL Server databases through tutorials, practical examples, and code samples. If you’re an experienced SQL Server ...

See more details below
Paperback
$37.50
BN.com price
(Save 37%)$59.99 List Price

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (13) from $18.99   
  • New (8) from $34.94   
  • Used (5) from $18.99   
Programming Microsoft SQL Server 2012

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK 7.0
  • Samsung Galaxy Tab 4 NOOK 10.1
  • NOOK HD Tablet
  • NOOK HD+ Tablet
  • NOOK eReaders
  • 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

Overview

Your essential guide to key programming features in Microsoft® SQL Server® 2012

Take your database programming skills to a new level—and build customized applications using the developer tools introduced with SQL Server 2012. This hands-on reference shows you how to design, test, and deploy SQL Server databases through tutorials, practical examples, and code samples. If you’re an experienced SQL Server developer, this book is a must-read for learning how to design and build effective SQL Server 2012 applications.

Discover how to:

  • Build and deploy databases using the SQL Server Data Tools IDE
  • Query and manipulate complex data with powerful Transact-SQL enhancements
  • Integrate non-relational features, including native file streaming and geospatial data types
  • Consume data with Microsoft ADO.NET, LINQ, and Entity Framework
  • Deliver data using Windows® Communication Foundation (WCF) Data Services and WCF RIA Services
  • Move your database to the cloud with Windows Azure™ SQL Database
  • Develop Windows Phone cloud applications using SQL Data Sync
  • Use SQL Server BI components, including xVelocity in-memory technologies
Read More Show Less

Product Details

  • ISBN-13: 9780735658226
  • Publisher: Microsoft Press
  • Publication date: 8/1/2012
  • Series: Developer Reference Series
  • Pages: 816
  • Sales rank: 476,417
  • Product dimensions: 7.20 (w) x 9.00 (h) x 1.50 (d)

Meet the Author

Leonard Lobel is a principal consultant at Tallan, a Microsoft Gold Certified Partner.

Read More Show Less

Table of Contents

Introduction;
How Significant Is the SQL Server 2012 Release?;
Who Should Read This Book;
Who Should Not Read This Book;
Organization of This Book;
Conventions and Features in This Book;
System Requirements;
Installing SQL Server Data Tools;
Using the Book’s Companion Website;
Errata & Book Support;
We Want to Hear from You;
Stay in Touch;
Acknowledgements;
Part I: Core SQL Server Development;
Chapter 1: Introducing SQL Server Data Tools;
1.1 Introducing SSDT;
1.2 Working with SSDT;
1.3 Summary;
Chapter 2: T-SQL Enhancements;
2.1 Table-Valued Parameters;
2.2 Date and Time Data Types;
2.3 The MERGE Statement;
2.4 The INSERT OVER DML Syntax;
2.5 The GROUPING SETS Operator;
2.6 Windowing (OVER Clause) Enhancements;
2.7 New T-SQL Functions in SQL Server 2012;
2.8 The THROW Statement;
2.9 Server-Side Paging;
2.10 The SEQUENCE Object;
2.11 Metadata Discovery;
2.12 Summary;
Chapter 3: Exploring SQL CLR;
3.1 Getting Started: Enabling CLR Integration;
3.2 Visual Studio/SQL Server Integration;
3.3 Your First SQL CLR Stored Procedure;
3.4 CLR Stored Procedures and Server-Side Data Access;
3.5 Deployment;
3.6 CLR Functions;
3.7 CLR Triggers;
3.8 CLR Aggregates;
3.9 SQL CLR Types;
3.10 Security;
3.11 Examining and Managing CLR Types in a Database;
3.12 Best Practices for SQL CLR Usage;
3.13 Summary;
Chapter 4: Working with Transactions;
4.1 What Is a Transaction?;
4.2 Local Transaction Support in SQL Server;
4.3 Isolation Levels;
4.4 Distributed Transactions;
4.5 Transactions in SQL CLR (CLR Integration);
4.6 Putting It All Together;
4.7 Summary;
Chapter 5: SQL Server Security;
5.1 Four Themes of the Security Framework;
5.2 SQL Server Security Overview;
5.3 Authentication and Authorization;
5.4 Encryption Support;
5.5 SQL Server Audit;
5.6 Partially Contained Databases;
5.7 How Hackers Attack SQL Server;
5.8 Summary;
Part II: Going Beyond Relational;
Chapter 6: XML and the Relational Database;
6.1 Character Data as XML;
6.2 The xml Data Type;
6.3 FOR XML Commands;
6.4 Additional FOR XML Features;
6.5 Shredding XML Using OPENXML;
6.6 Querying XML Data Using XQuery;
6.7 Summary;
Chapter 7: Hierarchical Data and the Relational Database;
7.1 The hierarchyid Data Type;
7.2 Creating a Hierarchical Table;
7.3 Populating the Hierarchy;
7.4 Hierarchical Table Indexing Strategies;
7.5 Querying Hierarchical Tables;
7.6 Reordering Nodes within the Hierarchy;
7.7 More hierarchyid Methods;
7.8 Summary;
Chapter 8: Native File Streaming;
8.1 Traditional BLOB Strategies;
8.2 Introducing FILESTREAM;
8.3 Enabling FILESTREAM;
8.4 Creating a FILESTREAM-Enabled Database;
8.5 Storing and Retrieving FILESTREAM Data;
8.6 Deleting FILESTREAM Data;
8.7 Direct Streaming in .NET with SqlFileStream;
8.8 FILESTREAM Limitations and Considerations;
8.9 Introducing FileTable;
8.10 Searching Documents;
8.11 Summary;
Chapter 9: Geospatial Support;
9.1 SQL Server Spaces Out;
9.2 Spatial Models;
9.3 Spatial Data Standards;
9.4 Spatial Data Types;
9.5 Spatial Enhancements in SQL Server 2012;
9.6 Integrating with Microsoft Bing Maps;
9.7 Summary;
Part III: Applied SQL;
Chapter 10: The Microsoft Data Access Juggernaut;
10.1 .NET Data Access Evolution;
10.2 Preparing the Sample Database;
10.3 Monitoring Database Activity with SQL Server Profiler;
10.4 Conventional ADO.NET;
10.5 Language-Integrated Query (LINQ);
10.6 Object Relational Modeling (ORM) Comes to .NET;
10.7 Summary;
Chapter 11: WCF Data Access Technologies;
11.1 Defining Services;
11.2 WCF Data Access Options;
11.3 WCF Data Services;
11.4 WCF RIA Services;
11.5 Making the Right WCF Data Access Choice;
11.6 Summary;
Chapter 12: Moving to the Cloud with SQL Azure;
12.1 History;
12.2 But What Is SQL Azure?;
12.3 Getting Set Up;
12.4 Managing Your Database;
12.5 Migrating and Syncing Between Earth and Cloud;
12.6 SQL Azure Federations;
12.7 SQL Azure Reporting;
12.8 Summary;
Chapter 13: SQL Azure Data Sync and Windows Phone 7 Development;
13.1 Characteristics of an Occasionally Connected System;
13.2 Getting to Know SQL Azure Data Sync;
13.3 Creating an Occasionally Connected System;
13.4 Prerequisites;
13.5 Configuring SQL Azure Data Sync;
13.6 Hosting WCF Data Services in Windows Azure;
13.7 Consuming OData on Windows Phone;
13.8 Summary;
Chapter 14: Pervasive Insight;
14.1 The Microsoft BI Stack: What’s It All About?;
14.2 Master Data Services;
14.3 Data Quality Services;
14.4 Integration Services;
14.5 SQL Server RDBMS, Fast Track DW, and SQL Server PDW;
14.6 Analysis Services;
14.7 Power View;
14.8 Reporting Services;
14.9 Excel and Excel Services;
14.10 PerformancePoint Services;
14.11 StreamInsight;
14.12 SQL Server Editions and SharePoint Version Requirements;
14.13 Summary;
Chapter 15: xVelocity In-Memory Technologies;
15.1 Column Store Databases;
15.2 xVelocity in the RDBMS: Columnstore Indexes;
15.3 xVelocity for Analysis: PowerPivot and SSAS Tabular Models;
15.4 Welcome Back to VertiPaq;
15.5 Summary;
About the Authors;

Read More Show Less

Customer Reviews

Average Rating 3.5
( 2 )
Rating Distribution

5 Star

(0)

4 Star

(1)

3 Star

(1)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 – 1 of 2 Customer Reviews
  • Posted September 18, 2012

    more from this reviewer

    Take your database programming skills to a new level and build c

    Take your database programming skills to a new level and build customized applications using the developer tools introduced with SQL Server 2012. This hands-on reference shows you how to design, test, and deploy SQL Server databases through tutorials, practical examples, and code samples. If you’re an experienced SQL Server developer, this book is a must-read for learning how to design and build effective SQL Server 2012 applications. This book is intended for developers who have a basic knowledge of relational database terms and principles. This is a book about Microsoft SQL Server 2012 written for the developer. Whether you are programming against SQL Server directly at the database level or further up the stack using Microsoft >NET, this books shows you the way. The latest release of Microsoft’s flagship database product delivers an unprecedented, highly scalable data platform capable of handling the most demanding tasks and workloads. As with every release, SQL Server 2012 adds many new features and enhancements for developers, administrators, and end users.

    1 out of 1 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 – 1 of 2 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)