Azure SQL database

External Article

Azure SQL Database - Dynamic Data Masking

  • Article

A number of security-related features are built into Azure SQL Database, including Transparent Data Encryption, Row-Level Security, and Azure SQL Database Auditing. Their availability reflects the consistent effort by Microsoft to provide functional parity between Azure SQL Database and SQL Server instances running in Azure virtual machines as well as in your on-premises environment. Another example of this trend is support for Dynamic Data Masking, covered in this article.

2017-05-30

2,632 reads

External Article

SQL Database: How to Configure Active Geo-Replication

  • Article

Active Geo-location is powerful magic for ensuring the high availability of a Azure SQL database, and for disaster-recovery. In choosing the best options, you need to accurately understand the value that the business places on the service you're running, long it will take for a secondary replica to be in synch with the primary replica, the importance of spreading the location of replicas widely, and the maximum tolerable unscheduled downtime. Just clicking all the options could prove to be expensive.

2016-10-27

3,361 reads

External Article

Azure SQL Database - Azure AD Authentication

  • Article

One of the challenges when considering migrating your on-premises SQL Server databases to Azure SQL Database is its lack of support for Active Directory-integrated authentication. With the advent of Azure SQL Database V12, the authentication capabilities have been expanded, allowing for more flexibility that leverages Azure Active Directory. In this article, Marcin Policht provides an overview of this functionality.

2016-10-10

3,995 reads

Blogs

Focus on Core Skills

By

Core skills depends on the position, but the point is that ensuring you have...

A New Word: Zverism

By

zverism – n.  the wish that people could suspend their civility and indulge in...

SQL Server Source Control on a $0 Budget

By

The Source Control Dilemma Every DBA has been there. Trying to keep track of...

Read the latest Blogs

Forums

Is GenAI Coming Faster Than You Think?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is GenAI Coming Faster Than...

Local Storage Options

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Local Storage Options

DeepSeek: What is new with this AI technology?

By Daniel Calbimonte

Comments posted to this topic are about the item DeepSeek: What is new with...

Visit the forum

Question of the Day

Local Storage Options

I'm setting up a SQL Server 2019 instance and we are planning on using SMB storage for our database files. However, the file share isn't ready, so the idea is to use the \127.0.0.1dbfile as the location to start and then move these files to the remote server. Can I do this?

See possible answers