Microsoft SQL Server Blog
Featured Posts
SQL Server on Azure Local is now generally available
With SQL Server on Azure Local, customers can modernize where their data resides while maintaining control over infrastructure, connectivity, and data placement.
What’s next for SQL? Performance, scale, AI, and developer productivity at the European SQL Community Conference
Join Microsoft Fabric and SQL Community Conference 2026 in Barcelona to explore SQL Server 2025, Azure SQL Database Hyperscale, developer productivity tools, and the future of AI-powered data platforms.
-
Improved Application Availability During Online Operations in SQL Server 2014
SQL Server 2014 introduces enhancements to two common database maintenance operations namely Partition Switching and Online Index Rebuild which greatly increases enterprise application availability by reducing maintenance downtime impact. -
Watch Now – Faster Business Insights for All. Big Data. Small Data. All Data.
At Microsoft we believe that data, big and small, goes through a process or lifecycle called the Data Science Process, and is as relevant today as it was hundreds of years ago. -
SQL Server 2014 In-Memory OLTP: App Migration Scenario Leveraging the Integrated Approach
As we emphasized in the previous blogs, with other in-memory technologies in the market today you have to migrate the entire database to memory or it’s a separate database product that deals with in-memory, which means learning new APIs and dealing with application compatibility issues. -
AlwaysOn Availability Groups Fully Supported on Windows Azure Infrastructure Services
We’re excited to announce that AlwaysOn Availability Groups are now fully supported on Windows Azure Infrastructure Services. -
How Memory-Optimized Database Technology is Integrated into SQL Server 2014
SQL Server 2014 takes an integrated approach to in-memory database technology. -
Hardware Considerations for In-Memory OLTP in SQL Server 2014
In-Memory OLTP uses memory and disk in different ways than traditional disk-based tables. -
SQL Server 2014 In-Memory OLTP – bwin Migration and Production Experience
As part of our SQL Server 2014 In-Memory OLTP blog series we asked early adopter Rick Kutschera from bwin. -
Buffer Pool Extension to SSDs in SQL Server 2014
How many of you have been looking into ways of cost effectively improving the performance of your OLTP workloads, without having to buy new more expensive hardware? Most of you know already that memory is one of the key assets available for the SQL Server and especially buffer pool memory, which plays key role in […] -
Premium Preview for Windows Azure SQL Database Now Live!
On July 8, 2013, at the Worldwide Partner Conference (WPC) in Houston, Texas, Satya Nadella, Server and Tools President announced a new Premium service for Windows Azure SQL Database that delivers more predictable performance for business-critical applications. -
Architectural Overview of SQL Server 2014’s In-Memory OLTP Technology
At the SQL PASS conference last November, we announced the In-memory OLTP database technology (code-named “Hekaton”) for a future SQL Server release. -
What’s New for Columnstore Indexes in SQL Server 2014
In SQL Server 2012, we introduced the memory optimized columnstore index. -
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.
