Microsoft SQL Server Blog
FabCon and SQLCon 2026: Unifying databases and Fabric on a single data platform
Welcome to the third annual FabCon and our first ever SQLCon here in Atlanta, Georgia.
How the Microsoft SQL team is investing in SQL tools and experiences
Microsoft is modernizing SQL tools with AI, SSMS, Visual Studio Code, and DevOps features to boost productivity and future-proof development.
-
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. -
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. -
Microsoft to Join the Big Data Conversation as an Elite Sponsor at Strata, Santa Clara, CA
On February 11-13, Microsoft will join 2,700 of the world’s leading big data scientists, CIOs and executives at the Strata conference in Santa Clara, CA. -
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. -
What Drives Microsoft’s Data Platform Vision?
FEATURED POST BY:   Quentin Clark, Corporate Vice President, The Data Platform Group, Microsoft Corporation If you follow Microsoft’s data platform work, you have probably observed some changes over the last year or so in our product approach and in how we talk about our products. -
New Data Science – What’s Next?
While every organization is different, their “big data” is often very similar. -
Join the 2014 24 Hours of PASS Business Analytics Challenge and You Could Win a Free Ticket!
Calling all data junkies and business analysts! Play along with @SQLServer on Twitter, February 5th during the 24 Hours of PASS, Business Analytics Edition for your chance to win a cool Microsoft T-shirt and a ticket to the 2014 PASS Business Analytics Conference in San Jose, CA! Beginning at 8 am PT on February 5th, […] -
State Transition of Checkpoint Files in Databases with Memory-Optimized Tables
In the previous blog Merge Operations, we described that how a CFP transitions across various stages in its life cycle. -
Merge Operation in Memory-Optimized Tables
In the Storage Allocation and Management for Memory-Optimized Tables, we had briefly touched upon the Merge operation. -
Hortonworks Makes HDP 2.0 for Windows Server Generally Available
Today, Hortonworks announced the general availability of the Hortonworks Data Platform (HDP) 2. -
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. -
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.