• big data - DBA Life - Delphix - Oracle - SQLServer

    Time for #GLOC, #SQLSatDallas, #DataSummit18

    The next nine days, I’m traveling to three cities for four events. We’ll just call this the 9-3-4 gauntlet of speaker life. I booked this travel as four, one-way flights to get the itinerary I needed to make the most of my schedule and will have breaks between each event to make sure I don’t kill myself my last two weeks at Delphix. GLOC Today I’m heading to the Great Lakes Oracle Conference, (https://gloc.neooug.org/) where I get to present on DevOps and hang out with all my Oracle peeps. GLOC is the second largest regional Oracle user group event and…

  • big data - Copy Data Management - Data Masking - Database - DBA Life - Delphix - devops - Test Data Management - Thought Leadership

    Broadening Your Audience

    I spent this week speaking at two conferences that may not be familiar to my usual crowd: • Techwell StarEast Testing Conference in Orlando, FL • Interop ITX Data Conference in Las Vegas, NV StarEast Testing Conference Techwell’s event is attended by testers and had over 2000 attendees at the Hyatt Regency Orlando’s Convention Center. This is a huge convention center and I won’t lie- I did try to first register at the Mazda event and then the KPMG event. One of the attendees in my session admitted she was crashing my talk from the KPMG conference and I was pretty…

  • big data - Delphix - devops - Oracle - Test Data Management

    StarEast, InteropITX and GDPR

    I’m getting ready to get on a plane between two events today and have been so busy, that there’s been a break in blogging.  That’s right folks, Kellyn has let a few things slide…. For those people on top of all the happenings in Kevlar’s life, I’ve been busy removing 15 years of possessions from my home so we can sell it in the next month, along with the purchase, upgrade and consolidation into a 42Ft. travel trailer.  It’s quite an undertaking, so a few things have had to be put lower on the priority list to complete the rest.…

  • Azure - big data - cloning - Cloud - Database - DBA Life - Delphix - Oracle - SQLServer

    Content- My Year in Review, 2017

    So where did 2017 go?!?!?  I really, really would like to know…  Needless to say, it’s time to do a year in review already and I actually have time to do it this year! DBAKevlar Blog I wrote over 100 blog posts this year between DBAKevlar, Delphix and partner sites, but I’ve enjoyed sharing with the different communities.  There’s significant changes going on in the IT world regarding the future of the Database Administrator. This deafening message came through when pulling together my top blog posts for 2017, with Death of the DBA, Long Live the DBA presenting itself as…

  • Delphix

    Disrupt or Die- Learning From History

    As I continue to dig into the legacy we’re impacted by in technology, I had the opportunity to read Disrupt or Die, the new book from Delphix and Avamar founder, Jedidiah Yueh.  I was first concerned that the content wouldn’t be that interesting to someone from the deep technical like myself… To be honest, I ended up quite captivated by the history lessons surrounding some of our most successful  technology companies, like Facebook, Google, Salesforce and others.  The book discusses, in Jed’s own words, something that I’ve always referred to as “the power in the simple act of doing” and…

  • Delphix - devops

    Free eBook: DevOps and the DBA, The Last Frontier!

    The first edition of the free eBook is available for download at Delphix! It took us a bit to get the final updates to the eBook version completed and I want to thank everyone at Delphix who helped get the content updated with the latest additions, including the bossman, Eric Schrock and for helping me keep it all organized and finalized, shoutouts to Rita Rosenberg. If you’re interested in downloading a PDF copy, simply go to this link and get a version for yourself and find out what you need to know as a DBA about where we fit into…

  • big data - Database - DBA Life - Delphix - Oracle - SQLServer

    Understanding Data Gravity as a DBA

    Data gravity and the friction it causes within the development cycle is an incredibly obvious problem in my eyes. Data gravity suffers from the Von Newmann Bottleneck. It’s a basic limitation on how fast computers can be. Pretty simple, but states that the speed of where data resides and where it’s processed is the limiting factor in computing speed. OLAP, DSS and VLDB DBAs are constantly in battle with this challenge.  How much data is being consumed in a process, how much must be brought from disk and will the processing required to create the results end up “spilling” to…

  • Delphix - Oracle

    Solaris Cluster and Decreasing Resource Needs After Upgrade

    Delphix Engineering and Support are pretty amazing folks.  They continue to pursue for solutions, no matter how much time it takes and the complex challenges they’re faced with supporting heterogenous environments, hardware configurations and customer needs. This post is in support of the effort from our team that resulted in stability to a previously impacted Solaris 11.2 cluster configuration.  The research, patching, testing and then resulting certification from Oracle was a massive undertaking from our team and I hope this information serves the community, but in no way is recommended by Delphix.  It’s just what was done to resolve the…

  • Cloud - DBA Rants - Delphix - Oracle

    Archaic Data Transfer- A DBA Rant

    There was a great post by Noel Yuhanna on how he deems the number of DBAs required in a database environment by size and number of databases.  This challenge has created a situation where data platforms are searching for ways to remove this roadblock and eliminate the skills needed to manage the database tier. I’ve been a DBA for almost 2 decades now, (“officially” as my beginning date with an official title and my years experience differ by a couple years…) When I started, we commonly used import and export features to move data from one data source to another.…

  • Data Masking - Delphix - Oracle

    The Security State of the Nation

    Even though my social media profile is pretty available for Twitter and Linked in, I’m significantly conservative with other personal and financial data online.  The reversal of the Internet Privacy Rule, (I’ve linked to a Fox news link, as there was so much negative news on this one…) had everyone pretty frustrated, but then we need to look at security of personal information, especially financial data and as we can see by security breaches so far in 2017, we all have reason to be concerned. The EU has taken the opposite approach with the right to be forgotten, along with…

  • Database - Delphix - SQLServer

    SQL Server 2012 and Changes to the Backup Operator Permissions

    I’m off to Columbus, Ohio tomorrow for a full day of sessions on Friday for the Ohio Oracle User Group.  The wonderful Mary E. Brown and her group has set up a great venue and a fantastic schedule.  Next week, I’m off to SQL Saturday Vancouver to present on DevOps for the DBA to a lovely group of SQL Server attendees.  It’s my first time to Vancouver, British Columbia and as it’s one of the cities on our list of potential future locations to live, I’m very excited to visit. Speaking of SQL Server-  Delphix‘s own SQL Server COE, (Center…

  • Database - DBA Life - Delphix - Oracle - SQLServer

    Latest Delphix Blog Post and Upcoming Webinars

    In my latest blog post on the Delphix site, I continue my conversation with why DevOps is the next step for DBAs and how DBAs can embrace this next step in their evolution. This is an extensive series of blog posts, (four so far) to be followed by an ebook, a podcast and two webinars.  One is to be announced soon from Oracle called, “The DBA Diaries” and the other will be a from Delphix, titled, “The Revolution:  From Databases and DevOps to DataOps“. The goal for all of this is to ease transition for the Database community as the…

  • AWS - Delphix - Oracle

    Upgrading an Amazon EC2 Delphix Target, Part IV

    It’s finally time to upgrade our Linux Target!  OK, so we’re not going to upgrade the way a DBA would normally upgrade a database server when we’re working with virtualization. So far, we’ve completed: 1.  Updating our instances so that we’ll have a GUI interface if we’ll need one. 2.  Installed Oracle on the Linux Source and upgraded our Dsource database to 12c   Now we’re done with our Linux Source and onto our Linux Target. Install and Configure VNC and Oracle We’ll run through and install and configure the VNC Viewer requirements just like we did in Part I…

  • DBA Rants - Delphix - Oracle - SQLServer

    Successful Evangelism

    I’ve been asked what it takes to be a successful evangelist and realizing that what makes one successful at it, is often like holding sand in your hands- no matter how tightly you hold your fists, it’s difficult to contain the grains. The term evangelist is one that either receives very positive or very negative responses.  I’m not a fan of the term, but no matter if you use this term or call them advocates, representative, influencer-  it doesn’t matter, they are essential to the business, product or technology that they become the voice for. Those that I view as…

  • AWS - Delphix - Oracle

    Upgrading an Amazon EC2 Delphix Source, Part III

    This is the Part III in a four part series on how to:  Enable VNC Viewer access on Amazon EC2 hosts.  Install DB12c and upgrade a Dsource for Delphix from 11g to 12c, (12.1)  Update the Delphix Configuration to point to the newly upgraded 12c database and the new Oracle 12c home.  Install DB12c and upgrade target VDBs for Delphix residing on AWS to 12.1 from the newly upgraded source. In Part II, we finished upgrading the Dsource database, but now we need to get it configured on the Delphix side. Log into the Delphix Admin console to make the…

  • AWS - Delphix - Oracle

    Upgrading an Amazon EC2 Delphix Source, Part II

    I’m finally getting back to upgrading the Linux Source for a POC I’m doing with some folks and picking up from where we left off in Part I… Address Display Issue Now that we have our VNC Viewer working on our Amazon host, the first thing we’ll try is to run the Oracle installer, (unzipped location –> database –> runInstaller) but it’s going to fail because we’re missing the xdpinfo file.  To verify this, you’ll need to open up a terminal from Application –> System Tools –> Terminal: $ ls -l /usr/bin/xdpyinfo ls: /usr/bin/xdpyinfo: No such file or directory We’ll…

  • Delphix - Oracle

    Development and the Importance of Containerizing

    I’ve been at KSCOPE 2017 all week and it’s been a busy scheduled even with only two sessions.  Its just one of those conferences that has so much going on all the time that the days just speed by at 140MPH. As with most major conferences, KSCOPE abstract submission was about 9 months ago.  This was a time when I was just coming to grips with how much Delphix could solve in the IT environment and may have been one of the first abstracts I submitted as a Delphix employee.  I wasn’t too thrilled with my choice and thank KSCOPE for…

  • Database - Delphix - Oracle

    Insider View of a Delphix VDB Rewind

    I love questions-  They give me something to write about that I don’t have to come up with from my experience or challenges…:) So in my last post, Paul asked: I am not sure what happens to the other changes which happened while the release was happening? Presumably they are also lost? Presumably the database has to go down while the data is reverted? The Setup In our scenario to answer this question, I’m going to perform the following on the VEmp_826 virtualized database: Add a table Add an index Include transactions, both inserts and deletes Rewind the database using the…