Programming Microsoft SQL Server 2012

978-0-7356-5822-6

Cena Brutto: 252.00

Cena netto: 240.00

Ilość:

Wersja:	Drukowana
Autor	Leonard Lobel, Andrew Brust
Liczba_stron	816
Wydawnictwo	Microsoft Press
Oprawa	miękka
Data_Wydania	2012-08-01
Poziom	All Levels

Programming Microsoft

SQL Server 2012

Książka z grupy:

SQL Server podręcznik

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

Książka dostępna w polskiej wersji językowej.

Core SQL Server Development
1. Chapter 1 Introducing SQL Server Data Tools
  1. Introducing SSDT
  2. Working with SSDT
  3. Summary
2. Chapter 2 T-SQL Enhancements
  1. Table-Valued Parameters
  2. Date and Time Data Types
  3. The MERGE Statement
  4. The INSERT OVER DML Syntax
  5. The GROUPING SETS Operator
  6. Windowing (OVER Clause) Enhancements
  7. New T-SQL Functions in SQL Server 2012
  8. The THROW Statement
  9. Server-Side Paging
  10. The SEQUENCE Object
  11. Metadata Discovery
  12. Summary
3. Chapter 3 Exploring SQL CLR
  1. Getting Started: Enabling CLR Integration
  2. Visual Studio/SQL Server Integration
  3. Your First SQL CLR Stored Procedure
  4. CLR Stored Procedures and Server-Side Data Access
  5. Deployment
  6. CLR Functions
  7. CLR Triggers
  8. CLR Aggregates
  9. SQL CLR Types
  10. Security
  11. Examining and Managing CLR Types in a Database
  12. Best Practices for SQL CLR Usage
  13. Summary
4. Chapter 4 Working with Transactions
  1. What Is a Transaction?
  2. Local Transaction Support in SQL Server
  3. Isolation Levels
  4. Distributed Transactions
  5. Transactions in SQL CLR (CLR Integration)
  6. Putting It All Together
  7. Summary
5. Chapter 5 SQL Server Security
  1. Four Themes of the Security Framework
  2. SQL Server Security Overview
  3. Authentication and Authorization
  4. Encryption Support
  5. SQL Server Audit
  6. Partially Contained Databases
  7. How Hackers Attack SQL Server
  8. Summary
Going Beyond Relational
1. Chapter 6 XML and the Relational Database
  1. Character Data as XML
  2. The xml Data Type
  3. FOR XML Commands
  4. Additional FOR XML Features
  5. Shredding XML Using OPENXML
  6. Querying XML Data Using XQuery
  7. Summary
2. Chapter 7 Hierarchical Data and the Relational Database
  1. The hierarchyid Data Type
  2. Creating a Hierarchical Table
  3. Populating the Hierarchy
  4. Hierarchical Table Indexing Strategies
  5. Querying Hierarchical Tables
  6. Reordering Nodes within the Hierarchy
  7. More hierarchyid Methods
  8. Summary
3. Chapter 8 Native File Streaming
  1. Traditional BLOB Strategies
  2. Introducing FILESTREAM
  3. Enabling FILESTREAM
  4. Creating a FILESTREAM-Enabled Database
  5. Storing and Retrieving FILESTREAM Data
  6. Deleting FILESTREAM Data
  7. Direct Streaming in .NET with SqlFileStream
  8. FILESTREAM Limitations and Considerations
  9. Introducing FileTable
  10. Searching Documents
  11. Summary
4. Chapter 9 Geospatial Support
  1. SQL Server Spaces Out
  2. Spatial Models
  3. Spatial Data Standards
  4. Spatial Data Types
  5. Spatial Enhancements in SQL Server 2012
  6. Integrating with Microsoft Bing Maps
  7. Summary
Applied SQL
1. Chapter 10 The Microsoft Data Access Juggernaut
  1. .NET Data Access Evolution
  2. Preparing the Sample Database
  3. Monitoring Database Activity with SQL Server Profiler
  4. Conventional ADO.NET
  5. Language-Integrated Query (LINQ)
  6. Object Relational Modeling (ORM) Comes to .NET
  7. Summary
2. Chapter 11 WCF Data Access Technologies
  1. Defining Services
  2. WCF Data Access Options
  3. WCF Data Services
  4. WCF RIA Services
  5. Making the Right WCF Data Access Choice
  6. Summary
3. Chapter 12 Moving to the Cloud with SQL Azure
  1. History
  2. But What Is SQL Azure?
  3. Getting Set Up
  4. Managing Your Database
  5. Migrating and Syncing Between Earth and Cloud
  6. SQL Azure Federations
  7. SQL Azure Reporting
  8. Summary
4. Chapter 13 SQL Azure Data Sync and Windows Phone 7 Development
  1. Characteristics of an Occasionally Connected System
  2. Getting to Know SQL Azure Data Sync
  3. Creating an Occasionally Connected System
  4. Prerequisites
  5. Configuring SQL Azure Data Sync
  6. Hosting WCF Data Services in Windows Azure
  7. Consuming OData on Windows Phone
  8. Summary
5. Chapter 14 Pervasive Insight
  1. The Microsoft BI Stack: What’s It All About?
  2. Master Data Services
  3. Data Quality Services
  4. Integration Services
  5. SQL Server RDBMS, Fast Track DW, and SQL Server PDW
  6. Analysis Services
  7. Power View
  8. Reporting Services
  9. Excel and Excel Services
  10. PerformancePoint Services
  11. StreamInsight
  12. SQL Server Editions and SharePoint Version Requirements
  13. Summary
6. Chapter 15 xVelocity In-Memory Technologies
  1. Column Store Databases
  2. xVelocity in the RDBMS: Columnstore Indexes
  3. xVelocity for Analysis: PowerPivot and SSAS Tabular Models
  4. Welcome Back to VertiPaq
  5. Summary