Aug 052016

04th August was a great day for many people who were waiting for this amazing feature since long. Microsoft announced (General Availability) GA Azure Active Directory authentication for SQL Database and SQL Data Warehouse. You can use Azure Active Directory (Azure AD) authentication to manage the identities of database users and other Microsoft services in one [Read More]

Jul 272016

Active Geo Replication is a new feature and not many of you are aware about the internals, it’s not that hard to configure it using Azure portal or to initiate the failover however, there are quite a few things which you must be aware of before using this for your most critical databases. Lack of [Read More]

Jul 202016

Import Export of Column Master Key is a very critical step if your application is not hosted on the same database server. If not done properly the purpose of configuring Always Encrypted might get defeated. You must plan to keep your Column Master Key away from Database Server. This blog is for those who choose [Read More]

Jul 172016

If you are also amazed at How Always Encrypted works for existing table then this blog may help you find some more details as to what really happens under the hood when we configure always encrypted for a table which has already got some data and how to get Always Encrypted Wizard Log Report. It looks like [Read More]

Jul 132016

In the First blog post, we understood the basic concept of Always Encrypted, different keys and the available Encryption types and then in the second post we saw different limitations and not supported column types in Always Encrypted. Now in this blog post let’s see how the actual implementation to see how to configure Always Encrypted [Read More]

Jul 112016

In the last blog post, we understood the basic concept of Always Encrypted, different keys and the available Encryption types. In this blog post we’ll see different Limitations of Always Encrypted feature, in-case you want to move to actual Implementation steps click here to know how to configure Always Encrypted on existing table with data.   Tool Limitations SQL Server [Read More]

Jul 082016

Hi Friends, We are coming up with a new series on Azure & Cloud Computing. This time Aman Dhally (Powershell MVP)  will join me in these sessions. Register:   Topics of the day will be: Session 1: Getting started with SQL Azure databases by Sarabpreet Singh Anand (MVP) Abstract: This session will introduce you [Read More]

Jul 082016

Always Encrypted is a new features introduced in Azure SQL Database and SQL Server 2016. Encryption is not new to SQL Server, it was introduced in SQL Server 2005 but this feature provides by far the best possible security for all those data owners who have outsourced the work to manage their servers to a [Read More]

error: Content is protected !!