Skip to main content Microsoft Intelligent Data Platform Azure Arc Azure databases Power BI SQL Server 2025 SQL Server BI SQL Server 2022 SQL Server 2019 SQL Server 2017 SQL Server 2016 SQL Server 2005 - 2014 Downloads Community SQL End of Support Data Security - SQL Server Encryption SQL Server blog SQL Server and Azure SQL workshops Browse Microsoft Solutions Hub SQL Server Tech Community Azure Databases Tech Community Azure Synapse Analytics Tech Community Developer Find a partner Become a partner Partner resources Try SQL Server 2025 Microsoft Security Azure Dynamics 365 Microsoft 365 Microsoft Teams Windows 365 Microsoft AI Azure Space Mixed reality Microsoft HoloLens Microsoft Viva Quantum computing Sustainability Education Automotive Financial services Government Healthcare Manufacturing Retail Find a partner Become a partner Partner Network Microsoft Marketplace Software companies Blog Microsoft Advertising Developer Center Documentation Events Licensing Microsoft Learn Microsoft Research View Sitemap

Microsoft SQL Server Blog

Published
•
3 min read

Limiting access to data using Row-Level Security 

To satisfy compliance standards, internal regulations or basic security principles, applications often need to limit a user’s access to only certain rows of data in

Published
•
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

Published
•
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,

Published
•
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. You can

Published
•
2 min read

JSON in SQL Server 2016: Part 1 of 4 

JSON is currently one of the most commonly used data exchange formats. Most modern services return information formatted as JSON text; web browsers use information

English (United States)
Your Privacy Choices Opt-Out Icon Your Privacy Choices
Consumer Health Privacy Sitemap Contact Microsoft Privacy Manage cookies Terms of use Trademarks Safety & eco Recycling About our ads