Skip to content
SQL Server Blog

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

A Look Back at PASS Summit 2013 

PASS Summit 2013 has been over for a little more than a week and we are already looking forward to what’s next in 2014. PASS Summit is the world’s largest and most-intensive conference for Microsoft SQL Server and BI professionals and it just keeps growing!  We are pleased to have had over 5,000 registrations for...Read more

Backup and Restore Enhancements in SQL Server 2014 CTP2 

SQL Server 2014 CTP2 includes three SQL Server Backup and Restore enhancements.  These enhancements enable using Windows Azure for backups, providing options to ease and automate backup management, and improved security for backups through encryption.  In addition, to enable backup to Windows Azure from previous versions of SQL Server, a stand-alone tool is now available.  A...Read more

Smart, Secure, Cost-Effective: SQL Server Back Up to Windows Azure 

Microsoft recently announced several new ways to back up and recover SQL Server databases with Windows Azure.  These features, now available in SQL Server 2014 CTP2 and as a standalone tool for prior versions, provide an easy path to cloud backup and disaster recovery for on-premises SQL Server databases.  The capabilities for backing up to...Read more

Cloud Data Warehousing – The Fastest Time To Value 

In the past, deploying a data warehouse has been a costly affair.  IT departments required expertise to procure and build state-of-the-art hardware servers (that are optimally balanced from a CPU, storage and I/O perspective) as well as install software that is tuned for optimal performance.  Prior to even loading data into the system, you could...Read more

SQL Server 2014 CTP 2 Now Available 

Microsoft SQL Server 2014 CTP2 was announced by Quentin Clark during the Microsoft SQL PASS 2013 keynote.  This second public CTP is essentially feature complete and enables you to try and test all of the capabilities of the full SQL Server 2014 release. Below you will find an overview of SQL Server 2014 as well...Read more

SQL Server 2014: Pushing the Boundaries of In-Memory Performance 

This morning, during my keynote at the Professional Association of SQL Server (PASS) Summit 2013, I discussed how customers are pushing the boundaries of what’s possible for businesses today using the advanced technologies in our data platform. It was my pleasure to announce the second Community Technology Preview (CTP2) of SQL Server 2014 which features...Read more