Technical Overview: SQL Server 2016 Release Candidate 0
The SQL Server engineering team is pleased to announce the availability of SQL Server 2016 Release Candidate 0.
Data platform
Best Practices
Content that tells readers recommended methods for tackling a problem, implementing a product, or doing anything related to SQL Server, database management, etc.
-
-
Are you running SQL Server 2005 Express? (Are you sure?)
Only a few weeks remain before extended support for SQL Server 2005 ends. -
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. -
Data security, SQL Server 2016, and your business
Security is unquestionably a major priority for Microsoft. -
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. -
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.
Explore SQL Server 2025
Accelerate your AI application’s time to market by harnessing the power of your data and the built-in AI capabilities of SQL Server 2025, the enterprise database with best-in-class security, performance, and availability.
Connect with us on social