System Databases in Azure SQL Database

Azure SQL Database and GDPR Compliance

In recent years, technology landscape has undergone dramatic changes, driven primarily by cloud computing and a continuously increasing level of attention dedicated to security, privacy, and compliance. One of the more significant initiatives that attempts to address these challenges is General Data Protection Regulation (GDPR. In this article, we will explore how Azure SQL Database could help with addressing the GDPR requirements.

Azure Defaults

Automatic Automatic Tuning

Calculating DTU's for Azure SQL Database

This calculator will help you determine the number of DTUs for your existing SQL Server database(s) as well as a recommendation of the minimum performance level and service tier that you need before you migrate to Azure SQL Database.

New Azure SQL Database Standard Tier Sizes

Tim Radney of SQLskills talks about the various Standard tiers available in Azure SQL Database – what they get you, and how much they cost.

How to use Azure SQL Database features and settings

Vitor Montalvao explains how to work with the basic configuration settings for a SQL Azure database from the Microsoft Azure portal itself.

Azure SQL Database Virtual Network Service Endpoints and Rules

One of the most commonly requested Azure SQL Database features has been support for more granular control of server-level firewall settings. A recently announced public preview of Azure SQL Database and Data Warehouse VNET service endpoints and rules promises to address this limitation.

Dynamic Data Masking on Azure SQL Database

Azure SQL Database’s Dynamic Data Masking (DDM) feature limits the exposure of sensitive information to non-privileged users. DDM can mask either the full value or partial value in a column. This method can also mask Social Security and Credit Card Numbers without making any changes to the application. Read on to learn more.

Azure SQL Database Long-Term Backup Retention

Azure SQL Database provides a number of benefits that leverage resiliency and redundancy built into the underlying cloud infrastructure. In addition to Point-in-Time Restore as well as Geo-Restore and Active Geo-Replication, you have the option of implementing long-term backup retention of Azure SQL Database.