I was caught off guard last week when the “Congratulations on your work anniversary!” messages started rolling in on LinkedIn. It had slipped my mind that it had already been a full year since I began contracting with Redgate back in May 2024. And, true to form, LinkedIn, always eager to simplify the complexities of tech careers and notified my entire network that I’d officially hit the one-year mark, although I hadn’t started full-time till the beginning of October. It can almost feel like an identity crisis as you perform so many roles for different organizations – thrilling and satisfying…
-
-
There’s a large influx of PostgreSQL databases coming into the market. It only makes sense to use this robust open-source database for any new project and to migrate those which can to an open-source solution, saving thousands, if not millions of dollars in database licensing costs. Most of these deployments are as PaaS (Platform as a Service) databases with cloud vendors. To maintain the ability to scale to meet the needs of so many customers, cloud vendors, in general, limit and throttle individual resources. Logically, if you’re able to determine what individual resources will require, it’s much easier to control…
-
I’ve been pretty busy with work and travel, but I finally got an official Silk Github repository to publish a couple new white papers and sizing assessment worksheets for customer access. These are primarily Oracle and SQL Server to Azure focused white papers, but I will be publishing ones on GCP next, to be followed by AI and other database platforms soon. White Papers The A2Z on Oracle for Azure The A2Z on SQL Server to the Cloud The slides for the session that is part of the research that went into the white paper above can be found here. …
-
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…
-
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…
-
I had an interesting opportunity with a complex Oracle environment that exemplified the challenges of technical debt and dependency on database platforms. There are those that believe a database should only be used to hold data and should be completely platform interchangeable. As DBAs, we know this results in very little usage of relational database features and platform strengths and rarely, if ever can scale. I fully support using the strength of RDBMS platform features, but what happens when we embrace what a feature does and attempt to build it better at the database layer than the RDBMS vendor? …
-
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…
-
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…
-
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.…
-
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…
-
A DBA is only as good as their last backup…or more so, their last recovery. To celebrate #WorldBackupDay on Twitter, I’m blogging on how to backup an Oracle database directly to Azure Blob storage. Yes, you could backup on a managed disk directly connected to the VM, then copy it off, but Azure Blob Storage is inexpensive and provides considerable speed and opportunity to create an NSF mount to use the backups with other Oracle hosts for cloning, recovery, etc. Configure Blob Storage in the Azure Portal In this example, we have an Oracle database running on an Azure IaaS…
-
Use the following shell script to create your Oracle VM. I chose the following parameters to create mine: Using Azure Cloud Shell and with persistent storage, which are linked on the github page, I uploaded the mk_oravm.sh script and run it after changing the permissions. chmod 744 mk_oravm.sh Provision the VM Run the script: ./mk_oravm.sh Anwser the questions from the script: What is the name for the resource group to create the deployment in? Example: ORA_GRP Enter your Resource Group name: orabkup_grp Here's the installation version urns available, including Oracle and Oracle Linux Urn ----------------------------------------------------------- Oracle:Oracle-Database-Ee:18.3.0.0:18.3.20181213 Enter the urn you'd…
-
Just like with other UI’s, the Azure portal may not show you the wealth of offerings that can be found in the Azure catalog. For those Oracle DBAs hoping to build an IaaS VM image from a certified OS version, this means they need Oracle Enterprise Linux and are frustrated when they can’t locate it in the portal. Empower with the Cloud Shell Oracle DBAs rarely are fascinated with user interfaces or portals, so when you offer us something like the Azure Cloud Shell, it’s something we should embrace. I’ve spoke about it before and I will rave about it…
-
As often as I use the Automatic Workload Repository(AWR) data in my day-to-day job at Microsoft, I think most can imagine how often I’m explaining its value, along with tracing to my Microsoft peeps. Its time to write a post dedicated to the Microsoft crowd who want to understand a bit more about AWR, so hopefully its helpful! What is the Automatic Workload Repository? The Automatic Workload Repository, (AWR) had been around since Oracle 10g and requires the diagnostic and tuning management pack licensing to use all of its features in Oracle’s Enterprise Edition database. Versions before 10.2.0.4 had limited…
-
Some folks stated they were having trouble finding this, so I’m posting a link here for the blog I wrote on the Microsoft Tech Community Blog on my opinion about building out RAC on Azure.
-
Load testing as part of a cloud migration project is expected and should be built into the requirements. The goal is to set yourself up for success. Log Latency Recently I had a Cloud Solution Architect, (CSA) escalate an Oracle performance problem after migrating from on-prem to the cloud. The information provided from the customer stated they were experiencing log sync latency in Oracle and that they hadn’t experienced this previously on-prem. They said there weren’t really any changes, just a simple lift and shift to Azure, so they were at a loss as to why the latency was being…
-
In my last post, I discussed some of the unique challenges migrating Oracle workloads from Exadata to Azure posed. Engineered systems are not your everyday lift and shift and are rarely simple. Although I covered some focus areas for success, I’d like to get into the migration philosophical questions around cell offloading and IO. cell information is referred to in the average Oracle 12c AWR report almost 350 times. That’s a LOT of data to consider when migrating a workload to a server that won’t have cell nodes to OFFLOAD TO. If cell nodes are creating a ton of different…