One consistent SQL: The launchpad from legacy to innovation
One consistent SQL delivers the agility and consistency needed to modernize data systems and unlock new innovation opportunities.
Microsoft SQL Server Blog
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.
Innovation spotlight: How 3 customers are driving change with migration to Azure SQL
Learn how Microsoft Azure SQL Managed Instance helps organizations move from legacy constraints to a scalable and secure AI-ready foundation.
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
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
New Data Science – What’s Next?
While every organization is different, their “big data” is often very similar. It typically comprises massive amounts of data across sources such as social media,
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
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. In this blog, we will
Merge Operation in Memory-Optimized Tables
In the Storage Allocation and Management for Memory-Optimized Tables, we had briefly touched upon the Merge operation. This blog describes Merge operation in detail. We
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%
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
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
SQL Server 2014 Hybrid Cloud Scenarios: Migrating On-Premises SQL Server to Windows Azure Virtual Machines
Those of you who have tried the new version of SQL Server Management Studio might have noticed already that it has a couple of new
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