Content type: Updates

Published 
2 min read

What’s New for Columnstore Indexes in SQL Server 2014 

In SQL Server 2012, we introduced the memory optimized columnstore index. This resulted in huge query performance improvements but columnstore indexes had one significant disadvantage – they couldn’t be updated directly but had to be rebuilt on a base table.
Published 
3 min read

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 documentation at http://technet.microsoft.com/en-us/library/dn133186(v=sql.120).
Published 
2 min read

A Closer Look at the Premium Offer for Windows Azure SQL Database 

As part of the main keynote yesterday at the Worldwide Partner Conference (WPC) in Houston, Texas, Satya Nadella, Server and Tools President, discussed partner and customer innovations around modern business applications built with the Windows Azure platform. As part of this cloud momentum, Satya announced a new Premium offer for Windows Azure SQL Database that delivers more predictable performance.
Published 
6 min read

Getting Started with SQL Server 2014 In-Memory OLTP 

SQL Server 2014 introduces memory-optimized database technology for optimizing the performance of OLTP workloads. In particular, it introduces memory-optimized tables for efficient, contention-free data access, and natively compiled stored procedures for efficient execution of business logic.
Published 
3 min read

SQL Server 2014 – Public CTP Now Available 

At TechEd North America we announced Microsoft SQL Server 2014 as part of a wave of updates to our key enterprise products. Today we are pleased to announce the availability of the first public Community Technology Preview (CTP) of SQL Server 2014. This public CTP enables you to try and test many of the capabilities of the SQL Server 2014 release.
Published 
3 min read

SQL Server 2014: Unlocking Real-Time Insights 

Today at TechEd North America we announced a wave of products and services that will help customers embrace the “enterprise cloud era.” The next version of our data platform – SQL Server 2014 – is a key part of the day’s news.
Published 
1 min read

Now Available: HDP for Windows from Hortonworks 

Today Hortonworks announced the general availability of Hortonworks Data Platform (HDP) for Windows, the industry’s first 100 percent Open Source Apache Hadoop-based distribution for Windows. The beta version of HDP for Windows was released two months ago at the Strata Conference in Santa Clara Hortonworks and was well received by industry press.
Published 
2 min read

Seamless insights on structured and unstructured data with SQL Server 2012 Parallel Data Warehouse 

In the fast evolving new world of Big Data, you are being asked to answer a new set of questions that require immediate responses on data that has changed in volume, variety, complexity and velocity. A modern data platform must be able to answer these new questions without costing IT millions of dollars to deploy complex and time consuming systems.