This is a continuation of the evolution of AI with ChatGPT and how much it can be leveraged, allowing me to do more with less time. As a DBA, many times I’m copying and pasting past versions of code, then making changes to do what needs to be done each day. the idea that ChatGPT could do some of this FOR ME is very attractive. It’s still in its infancy, but I’m thrilled to say, it’s getting better every day and you get out of it what you put in….as in prompts. This week, one of my prompts with the…
-
-
I always like to start with something easy, or at least easy for me… 🙂 ChatGPT, using GPT4 is moving fast and at this point, we can test it to generate code that will replace much of what I would write in a BASH, Python or PowerShell script. The prompt in ChatGPT was as follows: “Deploy Oracle 19.3 image on an Azure VM, using an E8ds_v5 SKU, with P6 for the OS Disk in EastUS2 in Azure CLI using BASH” ChatGPT is good about using natural language in it’s output to parse through each step and include the code that…
-
Did I really say that I would be presenting somewhere IN PERSON?? I’m actually coming out of hibernation and thinking about being social? Thursday, March 30th at 12pm PT/3pm ET, I’ll be on my first 2023 Redgate Webinar Is AI the Key to Driving Database Efficiencies? April 13th, 11am ET, I’ll be on a DZone webinar, another great one on Databases and AI! “Machine vs. Human: A Fireside Chat on Conversational AI” The link for this should be up soon, so stay tuned! May 5th, all day, Data Platform WIT/DEI…
-
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…
-
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…
-
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…
-
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…
-
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…
-
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,…
-
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…
-
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…
-
I know, I know- there’s a number of you out there thinking- I’m being brought in on more and more of these projects due to a recent change for some Exadata backup components many companies kept onsite, (parts that wear out more often, like PDUs and cell disks) which are no longer an option and that moving to Azure is a viable option for these workloads if you know what to identify and address before the move to the cloud. Engineered, Not Iron An Exadata is an engineered system- database nodes, secondary cell nodes, (also referred to as storage nodes/cell…