Ross Mistry & Stacia Misner
In this book, we explain how SQL Server 2014 incorporates in-memory technology to boost performance in online transactional processing (OLTP), data-warehouse solutions and lots more.
This book is for anyone who has an interest in SQL Server 2014 and wants to under- stand its capabilities. Many new improvements have been made to SQL Server 2014, but in a book of this size we cannot cover every improvement in its entirety-or cover every feature that distinguishes SQL Server from other databases or SQL Server 2014 from previous versions. Consequently, we assume that you have some familiarity with SQL Server already. You might be a database administrator (DBA), an application de- veloper, a business intelligence solution architect, a power user, or a technical decision maker. Regardless of your role, we hope that you can use this book to discover the features in SQL Server 2014 that are most beneficial to you.
PART I DATABASE ADMINISTRATION
Chapter 1 SQL Server 2014 editions and engine enhancements • SQL Server 2014 enhancements for database administrators
• SQL Server 2014 editions
• SQL Server 2014 licensing overview• Hardware and software requirements • Installation, upgrade, and migration strategies
Chapter 2 In-Memory OLTP investments • In-Memory OLTP overview.• In-Memory OLTP fundamentals and architecture
• In-Memory OLTP integration and application migration
• Using In-Memory OLTP
Chapter 3 High-availability, hybrid-cloud, and backup enhancements• SQL Server high-availability and disaster-recovery enhancements
• Platform for hybrid cloud
• Backup and restore enhancements
SQL Server backup to a URL
PART II BUSINESS INTELLIGENCE DEVELOPMENT
Chapter 4 Exploring self-service BI in Microsoft Excel 2013 • Excel Data Model and Power Pivot
• Power Query
• Power View
• Power Map
Chapter 5 Introducing Power BI for Office 365
• Power BI sites
• Shared queries
• Power BI Q&A• Power BI for Mobile
• Power BI administrationChapter 6 Big data solutions
• Big data
Unlock unlimited ebook downloads.
Share it on your social profile.