• Azure - Microsoft - Oracle

    Unreal Load Testing in the Cloud

    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…

  • Azure - Microsoft - Oracle

    Exadata Workloads to Azure, Part II

    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…

  • DBA Rants - Diversity and Inclusion

    Understanding as a Flawed Ally How We All Can be Better

    It was brought to my ADHD attention, that one of our community members is leaving after she was made to feel unwelcome by some who, (IMHO) have insecurities so deep, that they have nothing else better to do than do harm to others. Correcting others on preferred pronouns or even more challenging, transitioning  is something I can’t imagine the difficulty around.  I’ve only had the experiences as a parent of a gay son and one gender non-identifying child-  the unintentional and intentional cruelty of others was impactful enough.  I had more than one occasion of a child returning home, embarrassed…

  • Azure - Microsoft - Oracle

    Migrating Oracle Exadata Workloads to Azure

    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…

  • Azure - Microsoft - Oracle

    Oracle and the Future

    We’ll start with a disclaimer here- this is my experience and my opinion. NO ONE ELSE’S, just as any link to any blog in this post is. Take it or leave it, I really don’t care, never have, never will- never been one to follow any drummer but my own anyway. 😊 Although the basis for calculating database management systems percentage of business is highly contested, there isn’t anyone contesting Oracle as having the largest percentage of the current database management system business. Don’t confuse this with cloud business or other technology platform-  those are two different things.  One such…

  • Microsoft

    The 2019 Year in Review

    It’s that time of year where everyone is doing a “Year in Review” post and why not? It’s good to gain perspective, plan for 2020 and celebrate all that was wonderful about 2019, (outside of politics, that was an utter failure on all fronts, pretty much most countries… :)) The DBAKevlar blog: 46 published posts for 2019 Over 800 posts on the site Over 600K in visitors for 2019 Daily views have increased steadily, with over 2500 visitors yesterday. Somehow, still awarded top 60 blog sites for Oracle database blogs with all that Microsoft content…:) Microsoft Employment for 2019: My…

  • DBA Rants - Thought Leadership

    ADHD and Certification Tests- A Tale of Disaster

    I don’t talk too much about my Attention Deficit Hyperactivity Disorder, (ADHD) brain outside of the occasional squirrel joke and more often view it as a super power, but when it is a challenge, I think it’s important to share what we go through.  You can’t solve a problem if you don’t know it is one. ADHD and Autism For those that aren’t aware, I was diagnosed with ADHD/on the spectrum for autism back in 2004-2005.  Its not that I wasn’t before this, I just grew up in a very rural area. I fully demonstrated traditional traits for a kid…

  • Azure - EM13c - Enterprise Manager - Microsoft - Oracle

    Tools To Monitor and Work with Oracle on Azure

    I’ve been studying for over a week for my certs.  It really is a challenge for my ADHD brain, as I learn by interacting and using a product, not be reading about it and guess what?  Most of what the certs are on are not in my technical area.  Yeah, this is not fun for me.  I find that my brain hits a limit on what it can absorb before the activity levels in the temporal lobes diminish and I need to take a break, which is what I’m doing right now after a full day of Azure Synapse Analytics,…

  • Microsoft - SQLServer

    Installing Microsoft SQL Server 2019 on Linux, Part II

    This is a 2-part blog post, the first in the series can be found on the Microsoft SQL Server blog here. The recently released SQL Server 2019 on Linux includes several updated features, including replication, support for Microsoft Distributed Transaction Coordinator, and Change Data Capture (CDC) support. If you’re running SQL Server 2017 on Linux, these are great reasons to upgrade to SQL Server 2019 to take advantage of these updates. Microsoft SQL Server 2019 was subjected to significant testing and supported to run on several Linux distribution platforms: Red Hat Enterprise Linux (RHEL), SUSE Linux Enterprise Server (SLES), and…

  • Azure - Microsoft - Power BI - Power BI Desktop

    Securing Data in Power BI- an Interactive Diagram

    I haven’t been very good at sharing my analytics work as often I feel others are more skilled in this area than I am, just starting out, but today I’d like to start to fix that by sharing an interactive diagram.  I know, some of you may be saying, “infographic”, but as it’s has links vs. a paginated design, I’ll call it as I see it. Not the Kitchen Sink This diagram I built for a customer who was interested in how data was secured at different stages of the Power BI environment and was built with their specific Power…

  • Linux - Microsoft - SQLServer

    Failed Installation of MSSQL-CLI on Ubuntu

    So you want to run mssql-cli on Ubuntu Linux, but you received a number of errors and even if you got through some errors, you’re still stuck? I’m here to try to help you get through them and hopefully I’ve captured them all.  Trust me, the Oracle DBAs have been here-  our databases and tools failed for a very long time until Linux administrators came to know what we needed and started to build us the images with the correct libraries and versions we needed, so we feel your pain! The easiest scenario for many to deploy SQL Server 2019…

  • Microsoft

    PASS Summit 2nd Day Keynote

    Woohoo, we’ve made it to the second day of PASS Summit!  After an awesome first day running from the keynote, to my first session with Denise McInerney, late for my executive meeting with less than a dozen other attendees with Rohan Kumar and sessions/networking/parties, here we are for the second day of PASS Summit keynote! Info and Awards We started the day with Wendy Pastrick to tell us about the financial status of PASS and she decided to make sure we were awake and serenade us with a lovely song first! Tim Ford was next to talk about what the…

  • Microsoft

    Bacon, Bloggin’ and First Day Keynote at PASS Summit 2019!

    After a flurry of release announcements at MSIgnite this week, it was time to talk about the technology at a deeper level at PASS Summit.  I love this event, which has my undying loyalty due to the sheer amount of technical focus on everything in the Microsoft data platform and of course, was not disappointed with the first day keynote on Wednesday! We started out with a great treat of information before the keynote, just so we were prepared for what was to come in the next couple days…plus bacon! Grant Says Grant Fritchey started the keynote by welcoming all…

  • Microsoft - Power BI

    My PASS Summit, Wednesday, Nov. 6th Recommendations from DBAKevlar!

    I thought I would share the recommendations for the next day that I’m excited about this year at PASS Summit 2019!  There are some really great sessions and as most attendees, I’ve focused the list on topics that I’m interested in or can help me in my role. Although Tuesday afternoon and evening may kill me with how many events are all planned, there’s still a lot going on for the rest of the week! Wednesday starts with my session with Denise McInerney, on Becoming a Technical Leader, so I don’t get to attend first, but will be presenting.  This…

  • Azure - DBA Life - Linux - Microsoft

    PASS Summit 2019 is NEXT WEEK!

    I’m getting ready for SQL Saturday Oregon this weekend, (taking the train up from Eugene to Portland…) but its about time I talked about the exhilarating and exhausting event we call PASS Summit. This year I was lucky enough to be chosen as a speaker and a blogger.  Bloggers at the conference get the opportunity to sit in special zones during keynotes and we write about the event.  We also get special access to Microsoft PMs, (although I may be the only one who works for Microsoft attending vs. running them… :)) I look forward to all of the blogger…

  • Azure - Microsoft - Oracle

    The Complexity Defense and Other DBA Crimes

    No matter how far my career and role has shifted, I will always view myself as a database administrator.  I know this because when I fill out any form asking me what role I fulfill in IT, I still choose “DBA” from the list.  No matter what claims the media and leading sources state, DBAs are an important role, even as technology shifts and traditional database tasks move to the cloud.  Deeper relational database skills are still quite relevant when working in complex technical scenarios. The Experts Companies work to ensure they hire the right technical specialists.  They don’t understand database…