-
-
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. For example: An oil and gas exploration application might restrict an analyst’s access to well production data based on the analyst’s region and role. A healthcare application might -
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. In this video of Phillips’ PASS -
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 products more secure.” The Microsoft data platform, including SQL Server and Azure SQL Database, is at the top of the list of products investing in security. But, be aware that -
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. Always Encrypted for Windows 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. Users who track data history aim to answer fundamental questions: How did data look in a specific point in time in the past (yesterday, a month ago, a year ago, -
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. If you are familiar with the FOR XML clause, you will easily understand FOR JSON. When you add the FOR JSON clause at -
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. In the example above, we can specify where to locate the JSON -
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 use standard NVARCHAR columns to store JSON data. A simple table where some information stored as JSON is shown in the following example: CREATE TABLE Person (Â Id int IDENTITY PRIMARY -
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 formatted as JSON. JSON is the common format when semi-structured information needs to be stored, such as in files. Because a lot of data is formatted as JSON, it is