1.0Denny Cherry & Associates Consultinghttps://www.dcac.comDenny Cherryhttps://www.dcac.com/author/admin/TDE, Azure SQL MI, and Failover Groups – Denny Cherry & Associates Consultingrich600338<blockquote class="wp-embedded-content" data-secret="cfWjUq38Ls"><a href="https://www.dcac.com/2021/03/09/tde-azure-sql-mi-and-failover-groups/">TDE, Azure SQL MI, and Failover Groups</a></blockquote><iframe sandbox="allow-scripts" security="restricted" src="https://www.dcac.com/2021/03/09/tde-azure-sql-mi-and-failover-groups/embed/#?secret=cfWjUq38Ls" width="600" height="338" title="“TDE, Azure SQL MI, and Failover Groups” — Denny Cherry & Associates Consulting" data-secret="cfWjUq38Ls" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" class="wp-embedded-content"></iframe><script> /*! This file is auto-generated */ !function(d,l){"use strict";l.querySelector&&d.addEventListener&&"undefined"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!/[^a-zA-Z0-9]/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret="'+t.secret+'"]'),o=l.querySelectorAll('blockquote[data-secret="'+t.secret+'"]'),c=new RegExp("^https?:$","i"),i=0;i<o.length;i++)o[i].style.display="none";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute("style"),"height"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):"link"===t.message&&(r=new URL(s.getAttribute("src")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener("message",d.wp.receiveEmbedMessage,!1),l.addEventListener("DOMContentLoaded",function(){for(var e,t,s=l.querySelectorAll("iframe.wp-embedded-content"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute("data-secret"))||(t=Math.random().toString(36).substring(2,12),e.src+="#?secret="+t,e.setAttribute("data-secret",t)),e.contentWindow.postMessage({message:"ready",secret:t},"*")},!1)))}(window,document); </script> Transparent Data Encryption (TDE) with a Customer Provided Key, Azure SQL Managed Instance (MI), and Failover Groups should all be easy to setup. Azure SQL MI with either of the other two is pretty straightforward to setup. All three of them at the same time require a little doing in order to get them all […]https://www.dcac.com/wp-content/uploads/2020/12/caspar-camille-rubin-fPkvU7RDmCo-unsplash-1024x683.jpg