Browse by Tags

Tagged Content List
  • Blog Post: Explore In-Memory Technologies at Ignite

    You've probably already heard why you should use the in-memory tech built into Microsoft SQL Server: 30 times faster transaction speed, 100 times the query speed, and millions of rows of data analyzed every second. If you want to learn more about the how , check out the Microsoft Ignite session with...
  • Blog Post: Five Things to Know About SQL Server’s In-Memory Technology

    Last week was an exciting week for the SQL Server team, as one of our favorite events happened – PASS Summit . If you attended PASS, you probably heard a ton about the latest version of SQL Server 2014. One of the key drivers of SQL 2014’s design was the in-memory technology that is built...
  • Blog Post: In-Memory Technology in SQL Server 2014 Provides Samsung ElectroMechanics with Huge Performance Gains

    We’ve been talking a lot lately about our in-memory technology in SQL Server. If you attended the PASS Summit last week you likely heard a fair share. So, why all the fuss? Simply put, SQL Server 2014’s in-memory delivers serious business impact. According to CMS Wire “Microsoft SQL...
  • Blog Post: SQL Server 2014 In-Memory Gives Dell the Boost it Needed to Turn Time into Money

    There’s an old adage: time is money. Technology and the internet have changed the value of time and created a very speed-oriented culture. The pace at which you as a business deliver information, react to customers, enable online purchases, etc. directly correlates with your revenue. For example...
  • Blog Post: Are you harnessing all that in-memory can do for your business?

    Faster transactions, faster queries and faster analytics. Sounds like nirvana right? Just imagine it… your customers can find what they want from your large product catalog more quickly and purchase without huge lags. Your business divisions can perform timely analytics highlighting product, web...
  • Blog Post: Announcing the PASS 24 HOP Challenge

    Calling all data junkies! How smart are you? Want to get smarter? Play along with #pass24hop Challenge on Twitter starting at 5:00 AM PT Tuesday, September 9, 2014 to win a free Microsoft Exam Voucher ! Simply watch 24 Hours of PASS and be the first to answer the question correctly. At the beginning...
  • 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...
  • 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...
  • 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...