<body><script type="text/javascript"> function setAttributeOnload(object, attribute, val) { if(window.addEventListener) { window.addEventListener('load', function(){ object[attribute] = val; }, false); } else { window.attachEvent('onload', function(){ object[attribute] = val; }); } } </script> <div id="navbar-iframe-container"></div> <script type="text/javascript" src="https://apis.google.com/js/plusone.js"></script> <script type="text/javascript"> gapi.load("gapi.iframes:gapi.iframes.style.bubble", function() { if (gapi.iframes && gapi.iframes.getContext) { gapi.iframes.getContext().openChild({ url: 'https://www.blogger.com/navbar.g?targetBlogID\x3d8211560\x26blogName\x3dTech+Tips,+Tricks+%26+Trivia\x26publishMode\x3dPUBLISH_MODE_BLOGSPOT\x26navbarType\x3dBLUE\x26layoutType\x3dCLASSIC\x26searchRoot\x3dhttps://mvark.blogspot.com/search\x26blogLocale\x3den\x26v\x3d2\x26homepageUrl\x3dhttp://mvark.blogspot.com/\x26vt\x3d601588505461698440', where: document.getElementById("navbar-iframe-container"), id: "navbar-iframe" }); } }); </script>

Tech Tips, Tricks & Trivia

by 'Anil' Radhakrishna
An architect's notes, experiments, discoveries and annotated bookmarks.

Search from over a hundred HOW TO articles, Tips and Tricks

OLTP options in Azure

OLTP systems are designed to efficiently process and store transactions, as well as query transactional data.

The following table summarizes the key differences in capabilities between OLTP options in Azure:

Azure SQL Database SQL Server in an Azure virtual machine Azure Database for MySQL Azure Database for PostgreSQL
Is Managed Service Yes No Yes Yes
Runs on Platform N/A Windows, Linux, Docker N/A N/A
Programmability T-SQL, .NET, R T-SQL, .NET, R, Python T-SQL, .NET, R, Python SQL
Maximum database instance size 4 TB 256 TB 1 TB 1 TB
Supports capacity pools Yes Yes No No
Supports clusters scale out No Yes No No
Dynamic scalability (scale up) Yes No Yes Yes
Temporal tables Yes Yes No No
In-memory (memory-optimized) tables Yes Yes No No
Columnstore support Yes Yes No No
Adaptive query processing Yes Yes No No
Readable secondaries Yes Yes No No
Geographic replication Yes Yes No No
Automatic failover to secondary Yes No No No
Point-in-time restore Yes Yes Yes Yes
Row level security Yes Yes Yes Yes
Data masking Yes Yes No No
Transparent data encryption Yes Yes Yes Yes
Restrict access to specific IP addresses Yes Yes Yes Yes
Restrict access to allow VNET access only Yes Yes No No
Azure Active Directory authentication Yes Yes No No
Active Directory authentication No Yes No No
Multi-factor authentication Yes Yes No No
Supports Always Encrypted Yes Yes Yes No
Private IP No Yes Yes No

Labels: ,

Tweet this | Google+ it | Share on FB

« Home | Next »
| Next »
| Next »
| Next »
| Next »
| Next »
| Next »
| Next »
| Next »
| Next »


Post a Comment