SQL - Microsoft SQL Server Blog

Best Practices January 8, 2016 2 min read

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.

Best Practices January 7, 2016 3 min read

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.

Best Practices January 6, 2016 4 min read

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.

Best Practices January 5, 2016 2 min read

JSON in SQL Server 2016: Part 1 of 4

JSON is currently one of the most commonly used data exchange formats.

Updates December 17, 2015 3 min read

SQL Server 2016 CTP 3.2: Introducing end-to-end mobile BI

The SQL Server 2016 Community Technology Preview (CTP) 3.

Best Practices December 15, 2015 8 min read

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.

Best Practices December 10, 2015 5 min read

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.

Best Practices December 9, 2015 3 min read

Real-Time Operational Analytics Using In-Memory Technology

Operational workloads refer to the business transactions that are critical to running a business.

Best Practices December 8, 2015 3 min read

Speeding up Business Analytics Using In-Memory Technology

New challenges Businesses have always used data and analytics for improved business decisions.

Best Practices December 3, 2015 2 min read

SQL Server 2016: Advanced Capabilities without Expensive Add-Ons

What does the industry leading SQL Server 2016 have in common with spaghetti sauce? Just the fact that if you need something, “it’s in there.

Best Practices December 1, 2015 2 min read

Get the most out of SQL Server 2016

Blog post series to highlight new features and enhancements available with SQL Server 2016.

Best Practices December 1, 2015 2 min read

Always Encrypted Data Security and Competitive Advantage

As data becomes the center of digital business, your organization’s ability to secure data is crucial for compliance and confidentiality.

Explore SQL Server 2025