Edgenet Exec Q&A 

2 min read

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 built on SQL Server 2014, which has helped it continue to innovate and Read more

Dell Doubles Application Speeds, Processes Transactions 9X Faster with In-Memory OLTP 

2 min read

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 time. During peak online shopping periods, the Read more

2 Comments

In-Memory OLTP Sample for SQL Server 2014 RTM 

1 min read

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 2014 we created a sample around Read more

1 Comment

SQL Server 2014 and the DBA: Building Bridges 

3 min read

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 PASS Women in Read more

1 Comment

Progressive Insurance data performance grows by factor of four, fueling business growth online experience 

1 min read

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 performance for applications in throughput and latency. One of the early Read more

3 Comments

Customers using Microsoft technologies to accelerate their insights 

2 min read

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 into action. Many companies, and many of our customers, are already Read more

1 Comment

Tune in tomorrow and accelerate your insights 

1 min read

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 on Facebook Who should watch? Join us tomorrow morning at Read more

Using Natively Compiled Stored Procedures in SQL Server 2014 

6 min read

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. This means that applications which suffer from a lot Read more

1 Comment

Database Backup with Memory-Optimized Tables 

7 min read

The memory-optimized tables are backed up as part of regular database backups so you don’t need to do anything special to manage backups on databases with memory-optimized tables. Like for disk-based tables, the CHECKSUM of data/delta files is validated as part of database backup to proactively detect any storage corruption. However, as described in the Read more

In-Memory OLTP Index Troubleshooting, Part II 

6 min read

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 point-of-view. The main difference being that memory-optimized indexes are always covering (i.e. all columns are Read more

4 Comments

Merge Operation in Memory-Optimized Tables 

6 min read

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 CFPs The metadata of all Checkpoint File Pairs (i.e. CFP) that Read more

2 Comments