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.
-
It’s time! Registration is now open for Microsoft Ignite
It’s time — Register now for Microsoft Ignite and mark your calendar for September 26–30. -
Webcast: Upgrading and migrating SQL Server 2005 BI features to SQL Server 2014 and 2016
Please join us on February 3, at 10:00 am PST for a webinar on upgrading and migrating from SQL Server 2005 BI features to SQL Server 2014 and 2016 with guest speaker Paul Turley, SolidQ Mentor and MVP. -
Use Dynamic Data Masking to obfuscate your sensitive data
Data privacy is a major concern today for any organization that manages sensitive data or personally identifiable information (PII). -
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 a database. -
Microsoft Business Intelligence PASS keynote: Five minutes to sign up; five minutes to WOW!
See how you can get real-time interactive visualizations of customer data, as Microsoft Corporate Vice President James Phillips demonstrates exciting new capabilities available with Power BI and Microsoft’s powerful data platform, including SQL Server, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Datazen, and Azure SQL Database. -
Data security, SQL Server 2016, and your business
Security is unquestionably a major priority for Microsoft. -
Preview the newest ODBC SQL Server Driver for Windows and Linux
We are pleased to announce the community technology preview of Microsoft ODBC Driver 13 for SQL Server on Windows and Linux, supporting Ubuntu, RedHat and SUSE distributions! The updated driver provides robust data access to Microsoft SQL Server and Microsoft Azure SQL Database via ODBC on Windows and Linux platforms. -
Effortlessly Analyze Data History Using Temporal Tables
Real data sources are never static; critical business information changes over time and important decisions often rely on insights that analysts get from evolving data. -
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.
