Content type: Best Practices

Published 
3 min read

New: ASP.NET Session State Provider for SQL Server In-Memory OLTP 

Microsoft SQL Server 2014 brings new performance and scalability gains by introducing In-Memory OLTP.  In-Memory OLTP contains tables and indexes optimized for in memory. Transactions execute under lock-free algorithms to provide linear scalability and Transact-SQL stored procedures can be compiled in native machine code for maximum efficiency in processing.
Published 
4 min read

Driving Ground Breaking BI with APS 

This blog post will detail how APS gives users the ability to: Leverage Power Query, Power Pivot, and Power Map at massive scale Iteratively query APS, adding BI on the fly Combine data seamlessly from PDW, HDI, and Azure using PolyBase The Microsoft Analytics Platform System (APS) is a powerful scale out data warehouse solution for aggregating data across a variety of platforms.
Published 
2 min read

Why SQL Server runs best on Microsoft Azure 

Microsoft Azure Infrastructure Services offers many ways to optimize your on-premises data and data platform projects from development and test of new SQL Server applications to migrating existing on-premises SQL Server instances on the latest images of SQL Server to cost effective hybrid scenarios such as database backup and extended business continuity.
Published 
1 min read

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 2014 we created a sample around sales order processing based on the AdventureWorks sample database.
Published 
3 min read

“Modernizing” Your Data Warehouse with Microsoft 

Data warehousing technology began as a framework to better manage, understand, and capitalize on data generated by the business, and it worked extremely well for many years. This is a space that Microsoft knows well with warehousing capabilities since 1995 with SQL Server. However, there are several forces working to stretch the traditional data warehouse. Data volume is expanding tenfold every five years.
Published 
4 min read

Differential Database Backup with Memory-Optimized Tables 

This blog describes how differential database backup is taken on database with one or more memory-optimized tables. For full database backups, please refer to Database Backup with Memory-Optimized Tables. For disk-based tables, the differential database backup includes only the pages that have changed since the last full database backup.  SQL Server 2014 supports differential backup on databases with memory-optimized tables.
Published 
4 min read

Getting Trained on Microsoft’s Expanding Data Platform 

With data volumes exploding, having the right technology to find insights from your data is critical to long term success.  Leading organizations are adjusting their strategies to focus on data management and analytics, and we are seeing a consistent increase in organizations adopting the Microsoft data platform to address their growing needs around data.
Published 
7 min read

Database Backup with Memory-Optimized Tables 

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.