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.
-
JSON in SQL Server 2016: Part 4 of 4
Exporting Data as JSON – FOR JSON In this final post of our four-part JSON series, we showcase the ability to format query results as JSON text using the FOR JSON clause. -
JSON in SQL Server 2016: Part 3 of 4
Transform JSON Text to Relational Table – OPENJSON OPENJSON is a table-value function (TVF) that looks into JSON text, locates an array of JSON objects, iterates through the elements of the array, and for each element returns one row in the output result. -
JSON in SQL Server 2016: Part 2 of 4
Storing JSON Data in SQL Server Since external systems format information as JSON text, JSON is also stored in SQL Server as text. -
JSON in SQL Server 2016: Part 1 of 4
JSON is currently one of the most commonly used data exchange formats. -
Planning an efficient upgrade from SQL Server 2005: Step 3 of 3
Step 3: Identify your upgrade strategy As the end-of-support deadline for SQL Server 2005 draws near (April 12, 2016), you are probably starting to think about your upgrade strategy. -
SQL Server 2016 CTP 3.2: Introducing end-to-end mobile BI
The SQL Server 2016 Community Technology Preview (CTP) 3. -
Tuning Workload Performance with Query Store
As your database grows, it is not unusual to experience performance problems caused by queries that once performed well, but now perform poorly. -
Planning an efficient upgrade from SQL Server 2005: Step 2 of 3
Step 2: Target destinations for each application and workload As you know, the end of support deadline for SQL Server 2005 is on April 12, 2016. -
Enhanced Always On Availability Groups in SQL Server 2016
Always On Availability Groups Always On Availability Groups are a fundamental component of the availability story for SQL Server, and provide a robust disaster recovery solution as well. -
Watch the PASS Keynote Video: “Accelerating Your Business with a Modern Data Strategy”
The annual PASS Summit provides an opportunity for the SQL Server community to meet, share expertise, and gain firsthand insights into advances in the Microsoft data platform technology directly from Microsoft executives. -
Speeding up Transactions with In-Memory OLTP in SQL Server 2016 and Azure SQL Database
In-Memory OLTP, a performance feature in SQL Server since 2014, allows you to speed up transactional workloads up to 30X. -
Planning an efficient upgrade from SQL Server 2005: Step 1 of 3
Step 1: Discover what’s in your database environment Upgrading a database can seem daunting.
