Creating a Kubernetes Application for Azure SQL Database

Data Architecture Blog > Creating a Kubernetes Application for Azure SQL Database https://techcommunity.microsoft.com/t5/data-architecture-blog/creating-a-kubernetes-application-for-azure-sql-database/ba-p/3945641 Creating a Kubernetes Application for Azure SQL Database   Buck Woody, Principal Applied Data Scientist, Microsoft   Modern application development has several challenges. From selecting a "stack" of front-end through data storage and processing from several competing standards, through ensuring the highest …

The Well-Architected Framework for Oracle is NOW LIVE!

Data Architecture Blog > The Well-Architected Framework for Oracle is NOW LIVE! https://techcommunity.microsoft.com/t5/data-architecture-blog/the-well-architected-framework-for-oracle-is-now-live/ba-p/3721552 The Well-Architected Framework for Oracle has been published! Oracle workloads - Microsoft Azure Well-Architected Framework | Microsoft Learn   This invaluable framework provides clear guidance on the recommended practices to assess, architect and migrate Oracle workloads to the Azure cloud.  This should …

IOPs is Overrated

Data Architecture Blog > IOPs is Overrated https://techcommunity.microsoft.com/t5/data-architecture-blog/iops-is-overrated/ba-p/3710783 IOPs is Overrated, yeah, I said it.   How many compute, storage area networks, hard drive vendors and storage services have posted their IOPs capabilities in marketing and didn’t include the throughput (MBPs)?  Why when someone sends me IOPs for an Oracle database do I thank them …

IOPs is Overrated

Data Architecture Blog > IOPs is Overrated https://techcommunity.microsoft.com/t5/data-architecture-blog/iops-is-overrated/ba-p/3710783 IOPs is Overrated, yeah, I said it.   How many compute, storage area networks, hard drive vendors and storage services have posted their IOPs capabilities in marketing and didn’t include the throughput (MPBs)?  Why when someone sends me IOPs for an Oracle database do I thank them …

Migrating your workloads to Azure Database for MySQL

Data Architecture Blog > Migrating your workloads to Azure Database for MySQL https://techcommunity.microsoft.com/t5/data-architecture-blog/migrating-your-workloads-to-azure-database-for-mysql/ba-p/3681888 Migrating your workloads to Azure Database for MySQL Microsoft has a long history of trying to make software development and administration of IT infrastructure easier overtime. Additionally, Microsoft in the last 10 years has embraced open source broadly.   Microsoft Azure supports virtual machines, platform services, containers, serverless, and …

Addressing Oracle Redo Latency with Ultra Disk

Data Architecture Blog > Addressing Oracle Redo Latency with Ultra Disk https://techcommunity.microsoft.com/t5/data-architecture-blog/addressing-oracle-redo-latency-with-ultra-disk/ba-p/3614263 An enterprise cloud, like Azure, handles an incredible variety of workloads and to be successful running Oracle in Azure means you need to know what you’re doing and where the sweet spot is for a relational workload. I don’t want to get too …

Recommendations for Oracle 19c Patches in Azure

Data Architecture Blog > Recommendations for Oracle 19c Patches in Azure https://techcommunity.microsoft.com/t5/data-architecture-blog/recommendations-for-oracle-19c-patches-in-azure/ba-p/3563907 Oracle 19c is the terminal release for Oracle 12c.  If you aren’t familiar with that term, a terminal release is the last point release of the product.  There were terminal releases for previous Oracle versions (10.2.0.4, 11.2.0.7.0) and after 19c, the next terminal …

Recommendations for Oracle 19c Patches in Azure

Data Architecture Blog > Recommendations for Oracle 19c Patches in Azure https://techcommunity.microsoft.com/t5/data-architecture-blog/recommendations-for-oracle-19c-patches-in-azure/ba-p/3563907 Oracle 19c is the terminal release for Oracle 12c.  If you aren’t familiar with that term, a terminal release is the last point release of the product.  There were terminal releases for previous Oracle versions (10.2.0.4, 11.2.0.7.0) and after 19c, the next terminal …

Cross Subscription Prod Refresh on SQL Managed Instance using TDE and Azure Key Vault

Data Architecture Blog > Cross Subscription Prod Refresh on SQL Managed Instance using TDE and Azure Key Vault https://techcommunity.microsoft.com/t5/data-architecture-blog/cross-subscription-prod-refresh-on-sql-managed-instance-using/ba-p/3516266 Hello Dear Reader!  I was working with some friends lately and we needed to set up a process to refresh their Development Environment databases from Production.  Additionally, the databases are encrypted using Transparent Data Encryption, The …

The Importance of Proximity Placement Groups for Oracle multi-tier systems in Azure

Data Architecture Blog > The Importance of Proximity Placement Groups for Oracle multi-tier systems in Azure https://techcommunity.microsoft.com/t5/data-architecture-blog/the-importance-of-proximity-placement-groups-for-oracle-multi/ba-p/3513587 Oracle is a unique, high IO, workload beast, but it's important to recognize it's more often an ecosystem made up of an Oracle database, applications and often other databases that all must connect, feed and push data to …

Bring Vision to Life with Three Horizons, Data Mesh, Data Lakehouse, and Azure Cloud Scale Analytics

Data Architecture Blog > Bring Vision to Life with Three Horizons, Data Mesh, Data Lakehouse, and Azure Cloud Scale Analytics https://techcommunity.microsoft.com/t5/data-architecture-blog/bring-vision-to-life-with-three-horizons-data-mesh-data/ba-p/3390414 Introduction:   Many of you may have been focused on analytics for years and have shown audacity, acumen, and determination in improving your decision-making and the decisions of those around you.  You have personified …

Using Oracle AWR and Infra Info to Give Customers Complete Solutions to Performance Problems

Data Architecture Blog > Using Oracle AWR and Infra Info to Give Customers Complete Solutions to Performance Problems https://techcommunity.microsoft.com/t5/data-architecture-blog/using-oracle-awr-and-infra-info-to-give-customers-complete/ba-p/3361648 One of the best allocations of an Oracle SME specialist at Microsoft is when there is a complex data/infra issue for one of our customers.  We have a unique set of skills, understanding relational workloads along …

Oracle Licensing in Azure for Virtual Machines- Sales vs. Reality

Data Architecture Blog > Oracle Licensing in Azure for Virtual Machines- Sales vs. Reality https://techcommunity.microsoft.com/t5/data-architecture-blog/oracle-licensing-in-azure-for-virtual-machines-sales-vs-reality/ba-p/3282222 This post will address an ongoing licensing myth that has just enough complexity around it, that it really trips up customers and account teams alike. As part of this post we’ll reference my vCPU licensing post, which I’d hoped would …

New White Paper- Recommended Practices for Oracle on Azure IaaS

Data Architecture Blog > New White Paper- Recommended Practices for Oracle on Azure IaaS https://techcommunity.microsoft.com/t5/data-architecture-blog/new-white-paper-recommended-practices-for-oracle-on-azure-iaas/ba-p/3247796 I know this is a long-awaited white paper and I would like to get this out into the hands of the public to help those who simply want to know the recommended practices for successfully assessing, sizing, architecting and migrating …

Oracle RAC on Azure

Data Architecture Blog > Oracle RAC on Azure https://techcommunity.microsoft.com/t5/data-architecture-blog/oracle-rac-on-azure/ba-p/1185410 *Updated 03/10/2022 This is a consistent question I receive often and although RAC isn't supported in any third-party cloud by Oracle, it's an important topic as more workloads lift and shift to Azure and there is absolutely a reason to have or not to have Real …

New White Paper- Recommended Practices for Oracle on Azure IaaS

Data Architecture Blog > New White Paper- Recommended Practices for Oracle on Azure IaaS https://techcommunity.microsoft.com/t5/data-architecture-blog/new-white-paper-recommended-practices-for-oracle-on-azure-iaas/ba-p/3247796 I know this is a long-awaited white paper and I would like to get this out into the hands of the public to help those who simply want to know the recommended practices for successfully assessing, sizing, architecting and migrating …

Understanding AWR Data for Exadata to Azure IaaS Migrations, Part I

Data Architecture Blog > Understanding AWR Data for Exadata to Azure IaaS Migrations, Part I https://techcommunity.microsoft.com/t5/data-architecture-blog/understanding-awr-data-for-exadata-to-azure-iaas-migrations-part/ba-p/3067771 High IO workloads in Azure are a topic of common interest and of those workloads, Oracle Exadata tops the list. I’m going to begin to post about how the Oracle on Azure SMEs in the Cloud Architecture and Engineering …

Understanding AWR Data for Exadata to Azure IaaS Migrations, Part I

Data Architecture Blog > Understanding AWR Data for Exadata to Azure IaaS Migrations, Part I https://techcommunity.microsoft.com/t5/data-architecture-blog/understanding-awr-data-for-exadata-to-azure-iaas-migrations-part/ba-p/3067771 High IO workloads in Azure are a topic of common interest and of those workloads, Oracle Exadata tops the list. I’m going to begin to post about how the Oracle on Azure SMEs in the Cloud Architecture and Engineering …

Constrained vCPU and Oracle Licensing in Azure

Data Architecture Blog > Constrained vCPU and Oracle Licensing in Azure https://techcommunity.microsoft.com/t5/data-architecture-blog/constrained-vcpu-and-oracle-licensing-in-azure/ba-p/3041537 Numerous times I’ve experienced misunderstanding on licensing around constrained vCPU VMs.  Sometimes the confusion is on the term, “constrained”, (I would have named this VM type, “Same CPU, bigger chassis”.) We’ll go over how we can confirm how many vCPU is on the …

A Data Science Process, Documentation, and Project Template You Can Use in Your Solutions

Data Architecture Blog > A Data Science Process, Documentation, and Project Template You Can Use in Your Solutions https://techcommunity.microsoft.com/t5/data-architecture-blog/a-data-science-process-documentation-and-project-template-you/ba-p/3038051 In most of the Data Science and AI articles, blogs and papers I read, the focus is on a particular algorithm or math angle to solving a puzzle. And that's awesome - we need LOTS of …