Facebook Icon Image Google Plus Icon Image Twitter Icon Image Logo Image

Expert SQL Server in-Memory OLTP

Expert SQL Server in-Memory OLTP Image

Book details:

Categories: Apress , Expert
Posted:Jun 30 2016
Book format:PDF
Book size:8.18 MB

Book Description:

Expert SQL Server In-Memory OLTP is a short but deep dive into one of the most significant feature sets to come to SQL Server in many years -- support for in-memory online transaction processing. Dmitri Korotkevitch is the five-star author of Pro SQL Server Internals, and now brings his same combination of clear thinking and deep expertise to the question of how to think about and best use memory-optimized tables and the natively-compiled stored procedures and other objects that were introduced as part of Microsoft's in-memory OLTP technology (code named "Hekaton") in SQL Server 2014. In-memory OLTP presents many opportunities for faster transaction throughput and taking better advantage of modern and powerful hardware in a demanding age in which systems handle hundreds of thousands of transactions per second and support millions of customers. But first there are questions to be answered: How to recognize opportunities and know when in-memory OLTP is beneficial? How to design systems to use in-memory OLTP? How to choose which tables are in-memory and which remain on disk? Expert SQL Server In-Memory OLTP addresses all these questions and more. Learn the architecture and the internals in order to recognize when in-memory OLTP can make a difference. Learn useful scenarios for thoughtfully incorporating in-memory support into existing applications. Recognize opportunities for in-memory OLTP in new development. Don't be without Dmitri Korotkevitch and the deep expertise he imparts in Expert SQL Server In-Memory OLTP as you move forward in using SQL Server's new and important in-memory OLTP feature set. Covers in-memory OLTP and architecture, including data storage, indexing, multi-version concurrency control, transaction logging, and recoveryIllustrates in-memory OLTP programmability and the process of native compilationGuides in recognizing opportunities to use in-memory OLTP in new development, and to speed up existing applications

Download Link:

Related Books:

Pro SQL Database for Windows Azure 2nd Edition Image

Pro SQL Database for Windows Azure 2nd Edition

Jun 30 2016 Pro SQL Database for Windows Azure, 2nd Edition shows how to create enterprise-level database deployments without the usual investment in datacenter and other infrastructure. Take advantage instead of Microsoft's worldwide backbone for cloud computing that delivers all the power of SQL Server in the form of the cloud-based SQL Database for Windows Azure. You can create and deploy a database in mere minutes that is accessible worldwide and takes advantage of SQL Database's high-availability features to protect your data while ensuring 99.9% uptime.SQL Azure is ideally suited for startups, who c...

Expert T-SQL Window Functions in SQL Server Image

Expert T-SQL Window Functions in SQL Server

Jun 30 2016 Expert T-SQL Window Functions in SQL Server takes you from any level of knowledge of windowing functions and turns you into an expert who can use these powerful functions to solve many T-SQL queries. Replace slow cursors and self-joins with queries that are easy to write and fantastically better performing, all through the magic of window functions. First introduced in SQL Server 2005, window functions came into full blossom with SQL Server 2012. They truly are one of the most notable developments in SQL in a decade, and every developer and DBA can benefit from their expressive power in solvin...

Expert Cube Development with Microsoft SQL Server 2008 Analysis Services Image

Expert Cube Development with Microsoft SQL Server 2008 Analysis Services

Jun 30 2016 Design and implement fast, scalable and maintainable cubes A real-world guide to designing cubes with Analysis Services 2008Model dimensions and measure groups in BI Development StudioImplement security, drill-through, and MDX calculationsLearn how to deploy, monitor, and performance-tune your cubeFilled with best practices and useful hints and tips In Detail Microsoft's SQL Server Analysis Services 2008 is an OLAP server that allows users to analyze business data quickly and easily. However, designing cubes in Analysis Services can be a complex task: it's all too easy to make mistakes early ...

Microsoft SQL Server Reporting Services Recipes Image

Microsoft SQL Server Reporting Services Recipes

Jun 30 2016 Learn to design more effective and sophisticated business reportsWhile most users of SQL Server Reporting Services are now comfortable designing and building simple reports, business today demands increasingly complex reporting. In this book, top Reporting Services design experts have contributed step-by-step recipes for creating various types of reports.Written by well-known SQL Server Reporting Services experts, this book gives you the tools to meet your clients' needs...