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.
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). Examples of such data include sensitive
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
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
Data security, SQL Server 2016, and your business
Security is unquestionably a major priority for Microsoft. A recent news story reported that the company “is spending $1 billion a year to make 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
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 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,
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
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
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
SQL Server 2016 CTP 3.2: Introducing end-to-end mobile BI
The SQL Server 2016 Community Technology Preview (CTP) 3.2 is now available for download! In SQL Server 2016 CTP 3.2, part of our new rapid