The short summer break is over, and conference treadmill is about to get underway again. I have a few things already on the calendar! July 27th – SQL Saturday Baton Rouge! Migrating High IO SQL Server Workloads to Azure for the Win August 31st- Data Saturday Oslo- Navigating and Thriving in the Age of AI Sept. 7th- Data Saturday Dallas– I’ll be doing two sessions- Relational Database Instant Extracts to Fabric and Turning ADHD into “Awesome Dynamic Highly Dependable” It’s also been announced that Nov. 2nd I’ll be the keynote speaker for SQL Saturday SW Washington and Oregon again this…
-
-
Along with presenting the keynote at SQL Saturday Oregon this weekend, I will be taking the SQL Train up to PASS Summit for the next week’s conference. I will be on the WIT panel, as well as presenting with Chris Yates in a Professional Power Hour: Journey to Management on how to transition from a technical role to management. As much as I enjoy the technical aspect of my career, it was a careful navigation for me to ensure that my neurodiverse self was fulfilled as I moved up the ladder to my current Director position at Silk. If you’re…
-
Here is what’s going on for me at Silk for the month of August! I’ve served in the role as Director of Technical Advocacy at Silk for just over 2 months. It’s been a productive months, helping out with Oracle, SQL Server, PostgreSQL and other workloads on Azure and Google Cloud interested in running with Silk. I love the energy from each of the teams at the company and enjoy the opportunity to contribute to all the different aspects of the business here. I want to thank the sales teams for keeping me engaged. I also would like to curse…
-
I had a customer who needed to know how to retain performance after migrating to the cloud for SQL execution and I recommended SQL Baselines, but the information was surprisingly missing on how to collect an AWR baseline, THEN export out baselines and post migration, start a import baselines and review performance. Goal To stabilize performance of Oracle database during migrations to new Azure infrastructure from on-premises environments. Oracle provides in 12c and above, the ability to create full management baselines of SQL executions, which are a combination of SQL profiles, hints and defined statistical data to ensure performance remains…
-
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…
-
*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 Data Architecture Blog for the Tech Community. 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 kindly and ask for throughput? Thank you for asking… IO requests for Oracle can be exceptionally efficient depending on the type of workload. In this blog post, I’m going to take three, real examples of Oracle workloads and show how different the ratio…
-
*Previously posted on the Microsoft Data Architecture Blog for the Tech Community. 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 deep here, as Azure Oracle SMEs are both data and infra, which is a hybrid area resulting in us splitting between the two focuses. The Oracle Must-Knows An Oracle database is a complex relational database, but there are terminology and physical architecture that is important…
-
*Previously posted on the Microsoft Data Architecture Blog for the Tech community. 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 release will be 23c. Therefore, you don’t see many 18c, 20c or 21c databases. We’ve gone to yearly release numbers, but the fact remains that 19c is going to receive all major updates and continue to be supported unlike the non-terminal releases. Oracle will tell…
-
*Previously posted on the Data Architecture Blog for the Microsoft Tech Community. 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 users and each other. When migrating to the cloud, the architecture discussion about what apps will be placed on what VMs, in what region, availability zones and even availability sets occur, but many forget that Azure is an enterprise cloud and as such, is massive in scale, let alone that…
-
*Previously posted on the Microsoft Data Architecture Blog for the Microsoft Tech Community. 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 with deep infrastructure knowledge combined to identify issues that may be missed without these skills. For one customer this last week, they were receiving poor IO performance on one of their Oracle databases running on a VM in Azure. It’s quite easy to just blame storage or scale up the VM,…
-
*Posted previously on the Data Architecture Blog for the Microsoft Tech Community. 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 help answer this challenge, but for some reason, we still have folks confounded by Oracle sales people who, as sales will do, try to create friction that may cause people to hesitate from doing what they want with their workloads vs. doing what the Oracle sales people want them…
-
*Previously posted on the Microsoft Data Architecture Blog on the Microsoft Tech Community This white paper provides guidance from beginning to end that can be used by any organization to assess an Oracle workload and begin its journey to successfully migrating it to Oracle on Azure IaaS. The goal is to centralize all the recommended practices into one document and yes, it will become a Microsoft document eventually, (we’re still in the early stages or redesigning all the Oracle documentation for Microsoft) but the Data Architecture Blog provides me a quick way to get content to customers in a very…
-
*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…
-
*Previously posted on the Microsoft Data Architecture Blog on the Tech Community. 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 VM, including comparing a standard VM with 16 vCPU and a constrained 8-vCPU with the 16-vCPU chassis, demonstrating the vCPU count validation between both of them. We’ll also discuss the continual confusion around the terms of hyperthreading and multithreading. Oracle recently updated their documentation around third…
-
*Previously posted on the Microsoft Tech Community Data Architecture Blog. I get a lot of questions from our field on how the Cloud Architecture and Engineering (CAE) team Oracle SMEs are bringing over so many Oracle workloads to run in Azure so successfully. One of the biggest hurdles to bringing Oracle workloads into a 3rd party cloud isn’t technology, but licensing hurdles. Oracle doesn’t appear to make it easy, penalizing hypervisor virtualized CPUs. The reason this doesn’t faze us in the internal team is that we KNOW how on-premises database hosts are sized out for capacity planning. It is common for multiple…
-
*Previously posted on Microsoft Data Architecture Blog in the Tech Community Linux really does make the world go around. I love all OS, having been one of those odd Oracle DBAs to have used Mac, Android, and Windows laptops and while at Oracle, had all the OS outside of Linux that I supported, deeming my work, “the island of misfit projects.” As I’ve been asked multiple times this week about Unix platforms and how they can migrate to Azure, I wanted to get a post out on how our customers are handling migrations from Unix to Linux. We will start…
-
*Previously Posted on the Microsoft Tech Community Data Architecture Blog If you’re migrating your data estate to Azure, as is normal considering Azure is an enterprise cloud that can be the home for all data, including Oracle, you may wonder what storage solutions there are to support these types of IO heavy workloads. Maybe you didn’t realize how important storage was to Oracle in the cloud. Most customers we word with are focused on what vCPU and memory are available in Azure, but for 95% of Oracle workloads, it’s IO that makes the decision on the infrastructure we choose and of that…