• Cloud - Data Masking - Oracle - SQLServer

    GDPR Solutions in the Day of Automation

    There’s something for having job security and many of the solutions that I see offered for RDBMS challenges offer just that. With compliance with EU’s GDPR, (General Data Protection Regulations) just around the corner, (mark you calendar, May 25, 2018) you’d think we’d all be scrambling for a simpler solution to discovering and addressing all that GDPR data. Quick refresher for those of you going, “What is GDPR?” Data security is a known focus of GDPR when you talk to folks, but it’s much more than just security.  It’s about extended rights of the individual in the EU. There’s four…

  • SQLServer

    Pass Summit 2017, 1st Day, Also Known as HumpDay

    I’ve plenty of rest after arriving in Seattle yesterday to get my registration for Pass Summit, attended the Women in Technology Happy Hour and then received my Idera ACE! Now Wednesday morning, I spent it reworking my slides for the third time and preparing while the main keynote was going on, (my session was right after and was streamed.) After all that work, I then came to realize after adjusting my resolution, we loaded the previous deck and I had to think fast, skipping some older slides during my presentation. Lucky for me, I had an awesome audience and the…

  • DBA Life

    My Summer of SQL

    I know that right sidebar on my blog has an AWFUL lot of Microsoft events on it.  There’s so many, I’ve begun to use the hashtag #MySummerOfSQL due to it.  For those of you that follow me with Oracle, it doesn’t mean that I’m leaving the Oracle community- not even close.  I’m as dedicated as ever to Oracle and hope to dig back into my performance roots on both platforms, but know that the summer is the quiet time for Oracle user group events, so I’ll be keeping myself busy with SQL Saturdays and the AWESOME preview to the annual…

  • Delphix - SQLServer

    SQL Server on Linux

    I thought I’d do something on Oracle this week, but then Microsoft made an announcement that was like an early Christmas present-  SQL Server release for Linux. I work for a company that supports Oracle and SQL Server, so I wanted to know how *real* this release was.  I first wanted to test it out on a new build and as they recommend, along as link to an Ubuntu install, I created a new VM and started from there- Ubuntu Repository Challenge There were a couple packages that were missing until the repository is updated to pull universe by adding…

  • Oracle - SQLServer

    Optimizer Compatibility, Short Pants and Hot Sauce

    OK, so I’m all over the map, (technology wise) right now.  One day I’m working with data masking on Oracle, the next it’s SQL Server or MySQL, and the next its DB2.  After almost six months of this, the chaos of feeling like a fast food drive thru with 20 lanes open at all times is starting to make sense and my brain is starting to find efficient ways to siphon all this information into the correct “lanes”.  No longer is the lane that asked for a hamburger getting fries with hot sauce… 🙂 One of the areas that I’ve…

  • DBA Life - SQLServer

    My First Microsoft Pass Summit Conference

    It’s Friday and the last day of my first Summit conference.  I’ve wanted to attend this conference for quite a few years, but with my focus on the Oracle side and scheduling date so close to Oracle Open World, I couldn’t justify it before joining Delphix.  When I was offered a spot to join the Delphix team and attend, I jumped at the opportunity.  Look at this booth and these impressively talented Delphix employees-  how could you resist?? Pass Summit 2016 The Summit event has around 5000 attendees and is held in Seattle each year around the last week of…

  • DBA Life - SQLServer

    The Rosetta Stone of Database Platforms

    This is a living document that I will continue to update and will add new database platforms to as I go along in my career.  I spend a lot of time translating database platforms I’ve worked in for all tiers of the technical business.  It just seems natural that we might need a location on the web where that information is kept. I’ll add some diagrams at a later date, but we’ll start with a simple spreadsheet of common terms and questions and how each of the terms or tasks in Oracle, (the current #1 RDBMS) translates in other platforms.…

  • EM13c - Enterprise Manager

    EM13c Monitoring Non-Oracle Databases

    This last week I presented at Great Lakes Oracle Conference, (GLOC16) and the discussion on monitoring of non-Oracle databases came up while we were on the topic of management packs, how to monitor usage and what ones were required to monitor non-Oracle databases.  I didn’t realize how confusing the topic could be until I received an email while in on layover in Chicago and relaying what the attendee had taken away from it.  I was even more alarmed when I read the email again, planning to blog about it today after a full nights sleep! You’ll often hear me refer…