SQL Server Team articles

Avatar photo
SQL Server Team
Published 
1 min read

Hortonworks Makes HDP 2.0 for Windows Server Generally Available 

Today, Hortonworks announced the general availability of the Hortonworks Data Platform (HDP) 2.0 for Windows.  This is the next release of the industry’s only 100% Apache Hadoop-based distribution for Windows. With Windows Server leading all operating system  in usage share (two out of every three servers run Windows Server), HDP 2.0 for Windows dramatically broadens the accessibility of Hadoop.
Published 
6 min read

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 a new application with memory-optimized tables, you will notice these differences.
Published 
4 min read

SQL Server 2014 In Memory OLTP: Memory-Optimized Table Types and Table Variables 

SQL Server 2014 In-Memory OLTP introduces two new widely advertised kinds of database objects: memory-optimized tables for efficient data access, and natively compiled stored procedures for efficient query processing and business logic execution. However, there is a third kind of object introduced by In-Memory OLTP: the memory-optimized table type.
Published 
4 min read

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 OLTP functionalities are immediately available to you.
Published 
1 min read

Two SQL Server Jump Starts, Live on December 3rd and 4th 

If you haven’t yet, be sure to check out the SQL Server 2014 CTP2?  Essentially feature complete, this second public community technical preview enables you to try and test all of the capabilities of the full SQL Server 2014 release. To help get you trained on the new capabilities, Microsoft Virtual Academy (MVA) has two lively, demo filled events planned.
Published 
1 min read

The Modern Data Warehouse 

In recent surveys by TDWI Research, roughly half of respondents report that they will replace their primary data warehouse (DW) platform and/or analytic tools within three years. Ripping out and replacing a DW or analytics platform is expensive for IT budgets and intrusive for business users. This raises the question: What circumstances would lead so many people down such a dramatic path?
Published 
5 min read

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 to fail. While this adds a new dimension to managing memory, the application failure due to resource errors is not something new.
Published 
3 min read

Microsoft SQL Server Data Tools Update 

With the release of SQL Server 2014 Community Technology Preview 2 (CTP2) and the commercial release of Visual Studio 2013, we are excited to announce new preview releases of SQL Server Data Tools to support both database and business intelligence projects.