Browsing articles in "SQL Server 2014"
Nov
15
2017

Setting up Always ON Availability Group in Multi Subnet Cluster – Recommendations

While planning to configure always on availability group for first time on a multi subnet cluster found following use articles, it provides clear picture in terms of design and architecture, our requirement was to build SQL 2012 cluster on DC1 along with a reporting standalone SQL instance in same DC1, along with it, we want to have DR solution in DC2 where two standalone SQL instances are present on their respective server, to achieve this […]

Nov
9
2017

Configuring Replication with Always ON Availability Group

    For setting up replication on AlwaysOn availability group in SQL Server 2012 and above, following need to be taken care to ensure replication will work irrespective of the AAG placement.   The following sections build the environment described above:   Configure a remote distributor Configure the Publisher at the original Publisher Configure Remote distribution on possible publishers Configure the Secondary Replica Hosts as Replication Publishers Redirect the Original Publisher to the AG Listener […]

Oct
3
2017

SQL Server End to End Encryption – Always Encrypt, SSL

As we know the solution for SQL Server Data at rest encryption is TDE (Transparent Data Encryption) but what if application need End to End data encryption for PII fields, the solution is Always Encrypt columns in SQL 2016 Ent. Ed., from support DBA perspective it’s more of setting it up and supporting it but major liability lies with application developer, they need to validate and implement solution in first place; certainly there are few […]

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 34 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

December 2017
M T W T F S S
« Nov    
 123
45678910
11121314151617
18192021222324
25262728293031

View Post by Categories

%d bloggers like this: