Azure SQL Database Archives - SQLChamp

Azure Data Platform SQLAzure SQLServer SQLServer on Azure VM

Always Encrypted Wizard Log Report

July 17, 2016 Sarabpreet Singh Anand Always Encrypted, always encrypted wizard log report, Azure SQL Database, BACPAC, how to find Always Encrypted Wizard Log Report, internal, log report, SQL Database, SQL Server 2016

If you are also amazed at How Always Encrypted works for existing table then this blog may help you find some more

Azure Data Platform SQLAzure SQLServer SQLServer on Azure VM

Always Encrypted an Intro

July 8, 2016 Sarabpreet Singh Anand Always Encrypted, Azure SQL Database, Deterministic Encryption, intro, introduction, Randomized Encryption, SQL Database, SQL Server 2016

Always Encrypted is a new features introduced in Azure SQL Database and SQL Server 2016. Encryption is not new to

Azure Data Platform SQLAzure

Recover deleted Azure SQL Database

June 25, 2016 Sarabpreet Singh Anand azure, azure portal, Azure SQL Database, delete, deleted, deleted database, dropped, dropped database, recover, recover database, Recover deleted Azure SQL Database, restore, restore database, SQL Azure

Yes, it’s true. You can indeed recover deleted Azure SQL database during the retention period for the SQL Database

Azure Data Platform SQLAzure

Copy Azure SQL Database Deep-dive

June 23, 2016 Sarabpreet Singh Anand AS COPY OF, azure, azure portal, Azure SQL Database, cancel copy, Copy, copy azure sql database, COPY AZURE SQL DB, CREATE DATABASE, DB, Migrate, monitor copy, SQL Azure, SQL Database, SUSPECT, sys.databases, sys.dm_database_copies, t-sql

If you are supporting Azure you might have to copy Azure SQL Database, In-fact sometimes this becomes a daily task

Azure Data Platform SQLAzure

Automated SQL Database backup – Azure

June 22, 2016 Sarabpreet Singh Anand automated, automated sql database backup, Automated SQL Database backup - Azure, azure, azure portal, Azure SQL Database, backup, cost, frequency, price, RA-GRS, Read-access Geo-redundant storage account, retention, service tiers, SQL, SQL Database, Storage account, storage limit

Hi Friends Azure has a new functionality called Automated SQL Database backup, since its new you all must be having

SQLAzure SQLServer SQLServer on Azure VM

New Database scoped Configurations

June 7, 2016 Sarabpreet Singh Anand ALTER DATABASE SCOPED CONFIGURATION, azure, Azure SQL Database, CLEAR PROCEDURE_CACHE, compatibility level, DATABASE SCOPED CONFIGURATION, FOR SECONDARY, LEGACY_CARDINALITY_ESTIMATION, MAXDOP, new features, PARAMETER_SNIFFING, QUERY_OPTIMIZER_HOTFIXES, SQL Server 2016

MS introduced new Database scoped configurations in SQL Azure (V12) and SQL Server 2016; Need for new Database Scoped Configurations

Azure Data Platform SQLAzure SQLServer SQLServer on Azure VM

Must know facts before configuring Dynamic Data Masking

May 13, 2016 Sarabpreet Singh Anand Azure SQL Database, DDM, Down level Client, Dynamic Data Masking, limitations, Must know facts before configuring Dynamic Data Masking, not supported, security, sql server, SQL Server 2016, SQLAzure, TDS 7.3 and below, UNMASK

Dynamic data masking is yet another feature of Microsoft to ease your life and provide you out of the box capabilities

Azure Data Platform SQLAzure SQLServer SQLServer on Azure VM

Configure Dynamic Data Masking using T-SQL

May 3, 2016 Sarabpreet Singh Anand azure portal, Azure SQL Database, configure, Configure Dynamic Data Masking, CREATE TABLE, Credit card, Custom String, Data Masking Rules, DDM, default, DOB, Dynamic Data Masking, Email, Full Masking, Implement, IMplement Data Masking Rule, MASKED WITH (FUNCTION, Masking Fucntions, Modify Rules, Random, SQL, SQL Database, sql server, step-by-step, using T-SQL

In last few blogs about Dynamic Data Masking we got the basic understanding of the topic & how to configure

Azure Data Platform SQLAzure

Configure Dynamic Data Masking using Azure SQL Database portal

April 28, 2016 Sarabpreet Singh Anand azure portal, Azure SQL Database, configure, Configure Dynamic Data Masking, Credit card, Data Masking Rules, DDM, DOB, Dynamic Data Masking, Implement, IMplement Data Masking Rule, Modify Rules, SQL, SQL Database, sql server, step-by-step

In the last blog we got a basic introduction of Dynamic Data Masking feature in this blog post we’ll see

Azure Data Platform SQLAzure SQLServer SQLServer on Azure VM

Dynamic Data Masking Intro

April 15, 2016 Sarabpreet Singh Anand azure, Azure SQL Database, DDM, Dynamic Data Masking, SQL Database, sql server, SQL Server 2016, SQLAzure

Dynamic Data Masking is a great new feature introduced in Azure SQL Database and SQL Server 2016 to mask the