Browse by Tags

Tagged Content List
  • Blog Post: Dell Doubles Application Speeds, Processes Transactions 9X Faster with In-Memory OLTP

    As a global IT leader, Dell manufactures some of the world’s most innovative hardware and software solutions. It also manages one of the most successful e-commerce sites. In 2013, the company facilitated billions in online sales. On a typical day, 10,000 people are browsing Dell.com at the same...
  • Blog Post: Edgenet Exec Q&A

    Edgenet provides optimized product data for suppliers, retailers and search engines. Used online and in stores, Edgenet solutions ensure that businesses and consumers can make purchasing and inventory decisions based on accurate product information. Last year, it implemented an In-Memory OLTP solution...
  • Blog Post: In-Memory OLTP Sample for SQL Server 2014 RTM

    SQL Server 2014 introduces the new In-Memory OLTP feature to boost performance of OLTP workloads. In an earlier blog post , Quentin Clark described how In-Memory OLTP has helped customers achieve performance gains up to 30X. To help you get started with the new In-Memory OLTP feature in SQL Server...
  • Blog Post: SQL Server 2014 and the DBA: Building Bridges

    Guest blog post by : SQL Server MVP Denise McInerney – Vice President of Marketing for PASS and a Data Engineer at Intuit – began her career as a SQL Server DBA in 1998 and now applies her deep understanding of data to enable analytic solutions to business problems. She is founder of the...
  • Blog Post: Progressive Insurance data performance grows by factor of four, fueling business growth online experience

    At the Accelerate your Insights event last week, Quentin Clark described how SQL Server 2014 was now part of a platform that had in-built in-memory technology across all data workloads. In particular with this release Microsoft has added in-memory Online Transaction Processing delivering breakthrough...
  • Blog Post: Customers using Microsoft technologies to accelerate their insights

    At yesterday’s Accelerate your insights event in San Francisco, we heard from CEO Satya Nadella, COO Kevin Turner and CVP Quentin Clark about how building a data culture in your company is critical to success. By combining data-driven DNA with the right analytics tools, anyone can transform data...
  • Blog Post: Tune in tomorrow and accelerate your insights

    Tomorrow’s the day! Tune in to hear from Microsoft CEO Satya Nadella, COO Kevin Turner, and Data Platform Group CVP Quentin Clark about Microsoft’s approach to data, and how the latest advancements in technology can help you transform data into action. Mark your calendar RSVP...
  • Blog Post: Using Natively Compiled Stored Procedures in SQL Server 2014

    The new In-Memory OLTP feature in SQL Server 2014 greatly optimizes the performance of certain OLTP applications. By using the new memory-optimized tables you can speed up data access, in particular in concurrency situations, due to the lock- and latch-free architecture of the In-Memory OLTP Engine....
  • Blog Post: In-Memory OLTP Index Troubleshooting, Part II

    With the In-Memory OLTP feature in SQL Server 2014 we introduce two new types of indexes for memory-optimized tables: the memory-optimized NONCLUSTERED indexes, and the memory-optimized HASH indexes. Memory-optimized NONCLUSTERED indexes behave similar to traditional NONCLUSTERED indexes from an application...
  • Blog Post: State Transition of Checkpoint Files in Databases with Memory-Optimized Tables

    In the previous blog Merge Operations , we described that how a CFP transitions across various stages in its life cycle. In this blog, we will walk through an actual example to show the state transition. Note, some of the states shown for CFPs are only visible in RTM bits (not in CTP2) but internally...
  • Blog Post: Merge Operation in Memory-Optimized Tables

    In the Storage Allocation and Management for Memory-Optimized Tables , we had briefly touched upon the Merge operation. This blog describes Merge operation in detail. We also recommend you to refer to implementing durability for memory-optimized tables for a good understanding of data/delta files and...
  • Blog Post: Storage Allocation and Management for Memory-Optimized Tables

    As described in implementing durability for memory optimized tables , the storage requirements and its management for memory optimized tables is very different compared to the disk-based tables. If you are migrating a subset of your disk-based tables to memory-optimized tables or are just developing...
  • Blog Post: In-Memory OLTP: High Availability for Databases with Memory-Optimized Tables

    Starting with SQL Server 2012, the new offering of AlwaysOn Availability Groups and AlwaysOn Failover Cluster Instances (FCI) suite of features have enabled Tier-1 customers with mission critical applications to achieve their availability goals with SQL Server with an easy to deploy and manage solution...
  • Blog Post: New AMR Tool: Simplifying the Migration to In-Memory OLTP

    As we have addressed in previous blog articles, the transition into SQL Server In-Memory OLTP is not as simple as flipping a switch. One of the design principles of In-Memory OLTP is that you would only need to make surgically precise migrations for your app to reap the most benefit from In-Memory OLTP...
  • Blog Post: Concurrency Control in the In-Memory OLTP Engine

    We believe that the In-Memory OLTP engine advances the industry state of the art with respect to concurrency control. The main reason for this advancement is due to the combination of lock free algorithms and the row-versioned architecture of the engine. This post examines what we precisely mean when...
  • Blog Post: In-Memory OLTP Q & A: Myths and Realities

    Since SQL Server In-Memory OLTP (formerly known as project code-named “Hekaton”) was unveiled at PASS last November, there has been a lot of conversation and buzz about it. Some of the discussion was well informed and accurate, and some… not so much. With this series, and with online...
  • Blog Post: SQL Server 2014 In-Memory Technologies: Blog Series Introduction

    At the SQL PASS conference last November, we announced the In-memory OLTP (project code-named Hekaton) database technology built into the next release of SQL Server. Microsoft’s technical fellow Dave Campbell’s blog provides a broad overview of the motivation and design principles behind...
  • Blog Post: Oracle Surprised by the Present

    I’d like to clear up some confusion from a recent Oracle-sponsored blog. It seems we hit a nerve by announcing our planned In-Memory OLTP technology, aka Project ‘Hekaton’, to be shipped as part of the next major release of SQL Server. We’ve noticed the market has also been calling out Oracle on its...
  • Blog Post: SQL Server 2014 In-Memory OLTP – bwin Migration and Production Experience

    As part of our SQL Server 2014 In-Memory OLTP blog series we asked early adopter Rick Kutschera from bwin.party, to blog about his solution experience with SQL Server 2014 In-Memory OLTP. Read on below to hear more the experience from Rick. You can also learn more about bwin’s experience...
  • Blog Post: SQL Server 2014 In-Memory OLTP: Memory Management for Memory-Optimized Tables

    Memory-optimized tables must fully reside in memory and can’t be paged out. Unlike disk-based tables where insufficient memory can slowdown an application, the impact to memory-optimized tables upon encountering out-of-memory can be severe, causing DML (i.e. delete, insert or update) operations...
  • Blog Post: SQL Server 2014 In-Memory OLTP: Nonclustered Indexes for Memory-Optimized Tables

    SQL Server 2014 CTP1 introduced hash indexes for memory-optimized tables. Hash indexes are very efficient for point lookups, when you know exactly the value you are looking for. However, they do not perform well if you need a range of value, for example a date range, or if you need to retrieve the rows...
  • Blog Post: Troubleshooting Common Performance Problems with Memory-Optimized Hash Indexes

    In-Memory OLTP introduces a new type of index for memory-optimized tables in SQL Server 2014: the hash index. This new index type is optimized for index seek operations, i.e. finding the rows corresponding to a given set of equality predicates; for example, ‘o_id=8 AND od_id=4’. The underlying...
  • Blog Post: Boosting Transaction Performance in Windows Azure Virtual Machines with In-Memory OLTP

    With the release of SQL Server 2014 CTP2 , you can now significantly boost the performance of your OLTP workloads in Windows Azure Virtual Machines. By creating a new VM with our preloaded image of SQL Server 2014 CTP2 on Windows Server 2012 R2 , or installing SQL Server 2014 CTP2 on your VM, In-Memory...
  • Blog Post: The SQL Server Community Looks to Emerging Trends in BI and Database Technologies

    At PASS Summit this year Ted Kummert outlined his views on accelerating insights in the new world of data.  He mentioned in his blog post , that this is an incredible time for the industry, and that data has emerged as the new currency of business. Given that it’s such an exciting time to be in...
  • Blog Post: How Memory-Optimized Database Technology is Integrated into SQL Server 2014

    SQL Server 2014 takes an integrated approach to in-memory database technology. In-Memory OLTP, which optimizes performance of OLTP workloads, is fully integrated in the core SQL Server relational database management system. Now, what do we mean by “fully integrated”? In this post we highlight...