*Previously posted on the Data Architecture Blog in the Microsoft Tech Community. 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 be the first place for answers to success for Oracle on Azure! A special thanks to my teammate, Jessica Haessler for working so hard to help me get this to the finish line, as I would have never been able to get this done on my own!
-
-
*Previously posted on the Microsoft Data Architecture Blog for the Tech Community 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 team handle those. Exadata is a unique beast- it’s not an appliance or a single database, but an engineered system. It is a collection of hardware and software intelligence designed to run Oracle workloads, especially those with high IO, efficiently. I’ve built out a high level Exadata architecture and added…
-
There are only a few Oracle on Azure SMEs out there. OK, let’s be honest, the majority of the brain power is living in one floating home in Portland, Oregon and that’s not a good thing in many ways. It’s always difficult to specialize in a non-native solution at any company, but Microsoft is such an awesome place to be employed and our work is so critical to the overall success to Azure migrations that I’m very happy to do what I do. To help scale, I blog whenever I can on the questions that I most commonly end up…
-
First things first- The following opinions expressed in this post are my own and in no way connected to my employer. I’m getting slaughtered with questions about the multiple news stories and releases on the announcement for the Oracle Database Service for Azure, which is a rebrand and updated OCI Interconnect with an Azure Portal overlay in OCI. It allows the customer to deploy and monitor an Oracle Autonomous database or ExaCC and then have the application tier in Azure. This is touted as a multi-cloud solution, and I’m going to write this post and point people to it with…
-
When migrating an Oracle database to another platform, there are the common indicators and discussion topics around PL/SQL conversions, data types, application rewrites, etc., as being roadblocks to refactoring, but being successful also has to do with the SIZE of the workload coming from Oracle. I find this is often dismissed, even though this is one of the quickest ways to identify if an ENTIRE Oracle database, (not even by schema or a subset of the Oracle database) can run on a Platform as a Service, (PaaS) solution. The following post involves limits for each Azure PaaS solution and how…
-
I just finished an interview with a friend for a blog post where he was surprised how differently I was viewed in the Oracle community, (a multi-platform DBA who wasn’t very loyal to Oracle like she should be) vs. the Microsoft community, (that odd Oracle girl.) The truth is, I’ve always enjoyed database technology and few know that my first database (MSSQL 6.5) as well as my first book was in Microsoft SQL Server (Pro SQL Server 2012 Practices). I’m not platform centric at all, work mostly in Oracle, SQL Server/Azure SQL and MySQL, but I’m just CUSTOMER centric. Azure…
-
Three years ago today, I walked into Microsoft HQ in Redmond, WA and started my journey with onboarding. After a flurry of directions, presentations and shock at the diverse individuals in the process with me, I returned home and started as the lucky person taking over Patrick LeBlanc’s previous position in a specialized group in the EDU. I always hate starting a new job and this was no different. I had no idea what I was doing, was drinking from the fire hose, (which at Microsoft is always the case with how much is constantly evolving in the technology) and…
-
I’ll be speaking along with a slew of fantastic other presenters on mental health and wellness as part of the Women in Tech Data Platform on May 7th, 2021. This is a day we all come together to recognize the importance of self-care in our lives, but especially during this unprecedented time of the pandemic. I’ll be presenting a session titled, “Turning ADHD into “Awesome Dynamic Highly Dependable” It’s a long time coming, as I’m so often asked how I make ADHD look so easy. As most folks know, I don’t consider ADHD a disorder, but a unique wiring of…
-
Disclaimer: I’m not a big fan of benchmark data. I find it doesn’t provide us as much value in the real world as we’d like to think it does. As Cary Milsap says, “You can’t hardware your way out of a software problem” and I find that many folks think that if they just get the fastest hardware, their software problems will go away and this just isn’t true. Sooner or later, it’s going to catch up with you- and it rarely tells you what your real database workload needs to run most efficiently or what might be running in…
-
I’m about simplifying anything for customers as we bring over complex environments into Azure and Oracle databases running on Exadata is a big part of these challenges. Decoupling the database from the engineered features is a crucial part of my work and with Oracle 19c, having customers running on the terminal release isn’t the only reason to upgrade if the database is on an earlier release. As I’ve discussed in other posts, blogs and articles, I have numerous ways to address latency when losing cell node offloading, hybrid columnar compression (HCC), thin cloning with sparse clone, flash cache, flash logging,…
-
With my upcoming session on “Migrating Oracle Workloads to Azure IaaS” this week at PASS Virtual Summit 2020, I wanted to take some time to dig deeper onto the performance side. The last thing you want to have happen is to migrate your database to the cloud and have it just screech to a halt. The truth is, its often a combination of database and infrastructure issues that are the cause. Although many of you may want me to dig into database performance data, I’m actually going to first focus on infrastructure, as it’s the area that most aren’t privy…
-
It’s not uncommon for different recommended practices to arise in technical sizing and optimization practices. For many, it’s a compromise between most optimal data and ease of access vs. impact on production environments, which is no different from what we face when sizing Oracle on Azure. As we know it’s important to lift and shift the workload vs. moving the hardware, we must have as simple way to perform this task. The question comes up repeatedly as to our preferred method of working with a one-week Automatic Workload Repository, (AWR) report to do so. This post will be focused on…
-
I barely have enough time to breathe let along blog these days, but lucky for me, I am taking some downtime today, so I can come out here and write! Anyway, since I’m so busy, I volunteered to help judge the Azure SQL Championship that you can be part of! This is a great opportunity to level up your skills from onprem to be more cloud-centric and you’re not too late! The competition is from Oct. 12th-30th and there will be new contest challenge each week and daily quizzes that offer you the chance to win badges and prizes, including…
-
There’s so much I need to get written down these days, but there’s only so many hours in a day and days in a week and I’ve totally failed in this area. Well, I have a little time right now, so going to try to get something down. It only took me four times to get this published! 🙂 I’m often asked how I migrate an Oracle database to Azure and although each database is unique, there are some things that are pretty consistent that need to be identified and some that should be resolved before migrating to the cloud.…
-
In two hours I am honored to be the guest of the CSME Women’s Book Club event at Microsoft to discuss my book, “Crushing the IT Gender Bias.” In celebration of this, I want to discuss the importance of Women in Technology, (WIT) initiatives and the mistake many groups continue to make these days consolidating them into Diversity and Inclusion, (D&I) groups. A few years ago, when Women in Technology, (WIT) initiatives were the newest, coolest thing for business to be a part of, I was awarded an annual WIT award from the state’s tech organization. I was quite humbled…
-
This is commonly the time at any company I discuss how I’m about to move on… Nope, not planning on going anywhere… I know, it’s odd for everyone involved, but we’ll all get used to it. Where I’ve Been I joined Microsoft two years ago, to take on the role that Patrick LeBlanc left so that he could accomplish all that we’ve observed with Adam Sexton on Guy in a Cube. It was just a bit intimidating, as I’d never done analytics or AI before, nor had I really any experience in Azure. I hadn’t even thought about the big…
-
As the flood gates open up on Oracle for Azure IaaS, working in an efficient manner has become a necessity. We’re building out partners to help, but there are ways to empower our customers and those doing this work to make us all successful- hopefully this post will assist. After I posted the Estimate Tool for Sizing Oracle Workloads on Azure, I realized more guidance around AWR reports would be beneficial. These tips will provide help to any migration, not just one to Azure, so read and reap the rewards! Separate and Conquer A sizing estimate isn’t the same thing…
-
A week ago, Friday was my 13 year-old Cattle Dog/Jack Russell mix, DaVinci’s time to go to doggo heaven. He was a great flurry of tri-color energy, wrapped up in a small package. DaVinci at 4 Yrs Old I adopted him from a rescue that has discovered him during a Meth lab bust in Colorado. I liked to call him “My Little Crack-Puppy” and he was known for losing his little doggy mind around any animal that called to his prey drive,…