Microsoft has detailed a couple of improvements to the way Azure SQL Database handles failovers in case of an outage. It works with individual databases, elastic pools, or a combination of both.

Microsoft introduced transparent data encryption (TDE) when it released SQL Server 2008, adding full database encryption rather than the limited cell-based encryption that debuted in SQL Server 2005.

Today we are extending our look at user accounts by creating database users and then adding them to specific roles for to provide the proper level of access to a database. First thing is first: we ...