Shahid Roofi Khan

Microsoft Technologies Blog

SQL Always-On - Choose between Async vs Sync Replication mode.

SQL Always-ON is great technology. Often times architects and decision makes get stuck on a model of replication to decide in it. Confusion arises from the fact that it provides two flavors of replication: synchronous as well as asynchronous. Both approaches come with pros and cos.

Just to settle the confusion and reference for all decision makes and architects, I've documented the MS Article available at below MS Link:

Checkout my Microsoft Article Posting: https://social.technet.microsoft.com/wiki/contents/articles/52671.sql-alwayson-choosing-between-the-right-replication-model.aspx

Further Reading: Microsoft Article

 

Never Install SQL Ent or Standard edition. Always use developer edition. Here's why

SQL editions can give you tough times, especially when you have used enterprise edition and later you find you cannot downgrade it to standard edition. Often times this is core requirement from the customer once they renew their Microsoft licenses.

Only edition flexible enough to be downgraded as well as upgraded is the developer edition which works for six months without any issues.

Once this period elapses you have chance to either upgrade to enterprise edition or downgrade the solution.

It will save you lot of wasted deployment hours.

SQL Editions

 source: https://docs.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades-2017?view=sql-server-2017#-edition-upgrade