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 […]

    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 […]

With SQL Server 2017 GA announcement for October-2 2017, Microsoft is introducing changes to the servicing model through GDRs, CUs and SPs.   Excerpt from article published:   —————————————–   The Modern Servicing Model   Starting with SQL Server 2017, we are adopting a simplified, predictable mainstream servicing lifecycle: SPs will no longer be made available. Only CUs, and GDRs when needed. CUs will now accommodate localized content, allowing new feature completeness and supportability enhancements […]

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 […]