A long time ago, in early days of the Azure SQL Database in 2015, I wrote this article in which I tried to compare the SQL Server and Azure SQL Database in terms of versions and compatibility levels. Over the years, that article has attracted many readers and comments through search engines and referrals andContinue reading “Azure SQL Database Compatibility with SQL Server”
Tag Archives: azure
Dynamic Data Masking
Here’s a new feature that I like very much: Limiting exposure of sensitive data like user emails, phone numbers, addresses, credit card numbers and so on. This feature has been available in the Azure SQL Database for a while and now it is included in the new SQL Server 2016 . So let’s see it in action…
Row-Level Security part 2 – Controlling Write Access
My previous post was focused on controlling read operations. With the latest enhancements to the row-level security, it is now possible to restrict write operations as well. This feature is currently available as a preview now generally available in Azure SQL Database V12. Let’s see how that works.
Row-Level Security in SQL Server and Azure
Row-Level Security (RLS) is a new feature of SQL Server 2016 and Azure SQL Database that enables data access control based on the users executing those queries: if a user isn’t authorized to access certain rows in a table then those rows are automatically filtered out by the database engine. This feature promises to simplify design and coding ofContinue reading “Row-Level Security in SQL Server and Azure”
Azure SQL Database – Version and Compatibility Level
Attention readers: this article is over 5 years old and outdated. Please read the new article with up-to-date information. In the on-premises world, when we install a SQL Server on our own servers, we decide on SQL Version (2012, 2014….), Edition (Standard, Enterprise, Express…) and we set the database Compatibility Levels according to our applications’ specs. But what isContinue reading “Azure SQL Database – Version and Compatibility Level”
SQL Server in Azure
There are two flavors of SQL Server in Azure: one is the traditional SQL Server platform hosted in Azure virtual machines, also described as Infrastructure as a Service (IaaS). The other is called Azure SQL Database, database-as-a-service or Platform as a Service (PaaS). there are several important differences in functionality and features, so let’s look at them: