Category: DBA Life

December 27th, 2016 by dbakevlar

The only thing that remains constant is change.   ~Heralitus

chameleon

This often is more apparent in technology than anywhere else.  Even with a group of Oracle evangelists and enthusiasts like the ACE program, which offers the opportunity for peers to recognize those that contribute to the community and help make it a better place.

I’ve [often quietly] assisted many around me to find their path into the ACE program, even when I was an employee at Oracle and even now that I have ACE alumni status.  It was once a rare thing to have this status, but I was also considered an oddity, after spending a couple years learning all that I could about Enterprise Manager, moved on to Delphix to undergo my next opportunity for growth.  I departed Oracle at a time the ACE program was going through a major overhaul, with new requirements and rules to being part of the program.

For some in the Oracle community, it simply doesn’t make sense for them to be part of the program any longer, but it can also make it easy for those of the “reality TV” generation to try to find drama and gossip in it all.  Being nominated to the ACE program is something to be proud of-  you’re peers have reached out to recognize your contributions.  As rules were changed and re-evaluated while I was traversing the questions about how I would re-enter the ACE Program.  I received a large amount of emails of support, but at the same time, recommendations that it would be best to just stay the course and do what I do best, so I’ve made the decision, like many others, not to pursue re-activating my ACE Director.  At this time, 155 out of almost 700 members in the directory are listed as having alumnus status, so I’m suddenly far from alone.

There are many reasons individuals in the Oracle community would wish to still pursue the ACE program and I will continue to support anyone who wishes assistance with this goal.  I also recognized how difficult the decision was for those that left the program and believe the earned recognition should continue.  Just as The ACE program recognizes them as ACE Alumni in the ACE Program registry, RMOUG Training Days has updated the speaker biography with an option to be listed as an ACE Alumni.

If you are a speaker with our conference and an ACE Alumni, you have the option to update your profile and be recognized for your earned and continued contributions to the Oracle community.

I look forward to seeing everyone in February and Happy Holidays!

Posted in DBA Life Tagged with: , ,

December 16th, 2016 by dbakevlar

screen-shot-2016-12-16-at-12-05-22-pm

On the first day with Delphix, I provisioned with glee, an IT Manager Happy.

On the second day with Delphix, I provisioned with glee, two SAP ASE and an IT Manager Happy.

On the third day with Delphix, I provisioned with glee, three Oracle Databases, two SAP ASE and an IT Manager Happy.

On the fourth day with Delphix, I provisioned with glee, four EBS Clones, three Oracle Databases, two SAP ASE and an IT Manager Happy.

On the fifth day with Delphix, I provisioned with glee…

Five Cloud Migrations!

Four EBS Clones, three Oracle Databases, two SAP ASE and an IT Manager Happy.

On the sixth day with Delphix, I provisioned with glee,

Six SQL Servers running, Five Cloud Migrations, four EBS Clones, three Oracle Databases, two SAP ASE and an IT Manager Happy.

On the seventh day with Delphix, I provisioned with glee,

Seven developers coding, Six SQL Servers running, Five Cloud Migrations, four EBS Clones, three Oracle Databases, two SAP ASE and an IT Manager Happy.

On the eighth day with Delphix, I provisioned with glee,

Eight testers testing, Seven developers coding, Six SQL Servers running, Five Cloud Migrations, four EBS Clones, three Oracle Databases, two SAP ASE and an IT Manager Happy.

On the ninth day with Delphix, I provisioned with glee,

Nine applications applying, Eight testers testing, Seven developers coding, Six SQL Servers running, Five Cloud Migrations, four EBS Clones, three Oracle Databases, two SAP ASE and an IT Manager Happy.

On the tenth day with Delphix, I provisioned with glee,

Ten DevOps leading, Nine applications applying, Eight testers testing, Seven developers coding, Six SQL Servers running, Five Cloud Migrations, four EBS Clones, three Oracle Databases, two SAP ASE and an IT Manager Happy.

On the eleventh day with Delphix, I provisioned with glee,

Eleven DB2 humming, Ten DevOps leading, Nine applications applying, Eight testers testing, Seven developers coding, Six SQL Servers running, Five Cloud Migrations, four EBS Clones, three Oracle Databases, two SAP ASE and an IT Manager Happy.

On the twelfth day with Delphix, I provisioned with glee,

Twelve databases masking, Eleven DB2 humming, Ten DevOps leading, nine applications applying, eight testers testing, seven developers coding, six SQL Servers running, five Cloud Migrations, four EBS Clones, three Oracle Databases, two SAP ASE and as IT Manager Happy.

happy_h

Posted in DBA Life, Delphix Tagged with: ,

November 23rd, 2016 by dbakevlar

The challenge of coding, is that you sometimes need to be aware of what can be impacted outside of your code to make it appear guilty.

didnt

I wrote a blog post a short time back on my first time scripting with Apple Script with a goal of automating my weekly status reports to my new manager of my tasks in OmniFocus.  After seeing some cool stuff one of my peers did with their setup in OmniFocus, I built out mine to do something similar.  What I didn’t realize, was that my code was significantly dependent on my original setup and no new updates were created post the change.

Now that I know a little bit more about Apple Scripting and Omni Focus, I chose to do the following:

  1. Use Omnifocus’ Perspectives to give me a better status report output.
  2. Simplify my code to use the perspective vs. me “scraping” the data in Omnifocus.

For the database folks out there, a Perspective is just like a view in a database.  It’s just an alias with a selection of data that answers the query, “What have I completed in the last month, listing the project, the notes on my status and organize it by date completed.”

Create Perspective

You can create a new Perspective quite easily:

screen-shot-2016-11-23-at-11-12-15-am

You can create the perspective, (I’ve named mine “Weekly Report” and then create the “view” that will populate our report properly.

screen-shot-2016-11-23-at-11-13-05-am

Apple Script

Now, we’ll need to build our code to match what our perspective is done:

--Set up code to match the perspective

set thePerspective to "Weekly Report" --The exact Perspective name
set theSubjectOfMessage to "Task Report for Kellyn" --The Subject of Email
set theSender to "Kellyn Gorman"
set POSIXpath to POSIX path of "/Users/pathname/Library/Containers/com.omnigroup.OmniFocus2/Data/Documents/tasklist.txt"
tell front document of application "OmniFocus"
 tell front document window
 set perspective name to thePerspective
save in POSIXpath as "public.text"
 end tell
end tell
tell application "Mail"
 set theMessage to make new outgoing message with properties {subject:theSubjectOfMessage, sender:theSender}
 tell content of theMessage
make new attachment with properties {file name:POSIXpath} at after last paragraph
 end tell
 tell theMessage
make new to recipient at end of to recipients with properties {address:"emailaddress@.com"} --add address for email
 end tell
send theMessage
end tell

And test your code…always… 🙂  If you’ve set everything up correctly, then you should have an awesome weekly status report sent to your manager telling him how awesome you are.

Posted in DBA Life, Oracle Tagged with: ,

October 28th, 2016 by dbakevlar

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??

1d58vj

Pass Summit 2016

The Summit event has around 5000 attendees and is held in Seattle each year around the last week of October.  Its held in the Washington Convention Center which is a great venue for a conference.  I’d attended KSCOPE here in 2014 and loved it, so was looking forward to enjoying this great location once more.

As I’m just re-engaging the MSSQL side of my brain, I have some catching up to do and there was no place better to do it than at Summit.  I was able to dig in deep and attend a few sessions around booth duty and meeting folks I’ve rarely had opportunities outside of Twitter to interact with before this event.

brento

Brent Ozar came by the Delphix booth to say “Hi” and absolutely made my day!

Opportunities to Learn

There is always that challenge of learning about what you need to know and what you want to know-  this event was no different.  I had a list of features and products that I really need to come up to speed on, but with cool technology like Polybase, Analytics with R and performance talks, it could be a bit distracting from my main purpose here.  I’ve always been a performance freak and I still find it pulling me from the database knowledge that is important to day-to-day tasks.  I know this is why I find such value in Delphix-  It frees the DBA from spending any extra time on tasks that I find more mundane so we can spend it on more interesting and challenging areas of database technology.

What I did learn was that many of the companies that are realizing the importance of virtualization for on-premise and in the cloud, aren’t coming close to Delphix in features of ensuring they have the basics down first.  You can’t just talk the talk, you have to walk the walk, too.  I’m proud of Delphix and what we’ve accomplished-  that we don’t say we can do something we can’t and continue on the path to be Azure compliant for 2017.  Azure was everywhere this year at Summit and will continue to be a major push for Microsoft.

Pass Women in Technology Power-  ACTIVATE!

Another important recognition at Summit was the percentage of women attendees, the women in technology program at Summit, along with the support of the everyone at Summit of the WIT program.

https://pbs.twimg.com/media/CvzBrxYUEAAHogk.jpg:large

The WIT luncheon and happy hour was on Thursday.  In support of this day, over 100 men showed up in kilts.  It may seem like a small gesture, but it shows in how the men and women interact at this conference and the contribution of everyone at the event.  There is a lot more collaboration and the community is on average, much more interactive and involved than I’ve experienced at any Oracle event.  It’s not to say that Oracle is doing it wrong, it’s just to say that the SQL Server community is much farther ahead.  They refer to their SQL Family and they take it seriously in a good way.

PassTV

Due to all of this, I was given the opportunity of a PassTV interview, met a number of incredible experts in the MSSQL community that I’ve only previously known on social media and appreciate being embraced.

interview

I want to thank my great cohorts from Delphix who manned the booth with me at Summit.  We had incredible crowds that kept us so busy answering questions, doing demos and talking about how virtualized databases can increase productivity and revenue.  Sacha, Venkat, Jonathan, Dante and Jenny and Richie- you all ROCKED!

Thanks to everyone for making my first SQL Pass Summit conference AWESOME!!

 

Posted in DBA Life, SQLServer Tagged with: ,

October 20th, 2016 by dbakevlar

I think we’ve just about all heard enough about voting this election year, but I want to discuss a slightly different angle and that’s when it comes to user groups.  As most people know, I’m pretty passionate about everyone contributing time to your local and national user groups.  I also think it’s important to take pride in and be responsible for the promises you make.

screen-shot-2016-10-20-at-3-09-42-pm

I was sent a reminder to vote for the Oracle Developer Tools User Group, (ODTUG) Board of Directors as a member today.  I’ve already voted, but it also reminded me that I’d been politely approached by Eric Helmer via Linked in asking if I’d consider voting for him, (which is in the rules, you are supposed to campaign peeps!)  Now Eric doesn’t know me outside of a few nods and hellos at Oracle events.  I don’t think I’ve ever sat through a presentation of his, but that’s not what I go on when it comes to voting for a board of director.  I’ve worked on a couple boards now and supported a couple more.  User groups are often not impacted so much by their changing membership, but by those that want to be part of a user group board, but don’t want to contribute.

notdothem

Got my Vote

I was able to quickly respond to Eric and tell him, “too late, I already voted for you.”  I did take my vote seriously for ODTUG and was responsible to not just vote for my friends or those I recognized the names of, but to actually read the campaign statements and do a quick Google or Linked in search to see what the person has accomplished.

Eric got my vote for having a well thought out and well written campaign statement.  He didn’t just discuss who he was, what he had done, but what he WAS GOING TO DO for the user group. User groups need people that GET things DONE and by my research I believe Eric will follow through with his promises from his statement.

So if you are voting or looking for those to join a user group board, take the responsibility seriously and realize that user groups die or survive by the heart of the people that run it.  Take the time to research and read the statements.  If someone can’t put the time into a campaign statement, how can you expect them to follow through with the demands on a board of directors?

By the way, I was allowed four votes, so I also want to put a shout out for the other three candidates I voted for:

There were some other great campaign statements out there, so if you did your duty and voted for some other people, you’re not going to hear anything from me.  I do realize the guts it takes to put a campaign statement together and put yourself out there.  It did take research and data, along with the campaign statements for me to make my final decision on who got my vote.

Now, if I don’t get started on my review of KSCOPE 2017 abstracts, Galo Balda is sure to hunt me down and remind me I’m not living up to the promises I’ve made!  Go out there and vote, peeps!

Posted in DBA Life Tagged with: , ,

October 12th, 2016 by dbakevlar

I know it’s supposed to be an Oracle Technology Network, (OTN) Appreciation day, but for me, OTN is their OTN Community Manager, Laura Ramsey.  Ever since we first were introduced and I tried to do the right thing, making sure she was networked properly, she’s always made sure to be there for me and I appreciate that as both a woman in technology and a fellow Oracle community member.

To celebrate, I’ve hired this amazing, trained Hedgehog DJ for RMOUG Training Days 2017, OTN area:

hedgehog

You can thank me later, Laura… 🙂

Everyone has challenges and as I moved from the Oracle community to being an Oracle employee, there was a huge transition, yet Laura made sure that while I still tried, (heck, more like I was drafted!) to run RMOUG’s Training Day conference, she was there to lend OTN’s support for the event.

Many assumed that after going to Oracle that I would just disappear into what some of them considered a vast machine, but I was part of a wonderful team and my speaking opportunities and contributions to the community continued to flourish, Laura made sure I had opportunities to contribute to OTN by the way of interviews, articles and participation in panels.

At Oracle Open World 2015 she approached me about how she could do more for Women in Technology and we talked a lot about it, but with everything I was already engaged in, I wasn’t much help to her.  All on her own, she was able to take what she captured from the women in the Oracle community and really make a space for us at Oracle Open World 2016 with a panel, a social media presence, (#OTNWIT) and an ongoing online forum.

So as much as I know others are showing their appreciation for OTN in their own way, I’m going to point out a very valuable member, Laura Ramsey.

Happy OTN Appreciation Day, #ThanksOTN and #ThanksLaura

Posted in DBA Life

October 4th, 2016 by dbakevlar

My sabbatical from speaking is about to end in another week and it will return with quite the big bang.

bigbang1

Oct. 14th

First up is Upper NY Oracle User Group, (UNYOUG) for a day of sessions in Buffalo, NY.  I’ll be doing three talks:

  1.  Virtualization 101
  2.  The Limitless DBA
  3.  AWR and ASH with Database 12c

 

pass_2016_stacked

Oct 25th-28th

I’ll be at Pass Summit!  I’ve been wanting to attend this conference since I was managing MSSQL 7 databases!  I finally get to go, but as I’m newly back in the MSSQL saddle, no speaking sessions for me.  I do have a number of peers on the MSSQL side of the house, so hoping to have folks show me around and if you have the time to introduce yourself or introduce me to events and people at this fantastic event, please do!

Nov. 2nd

Next, I head into October with quite the number of talks.  I’ll start out on Nov. 2nd in Detroit, Mi at the Michigan Oracle User Summit, (MOUS) doing a keynote, “The Power in the Simple Act of Doing” and then a technical session, “Virtualization 101”.

Nov. 3rd

I’ll fly out right after I finish my second talk so I can make my way down to Raleigh, NC for the East Coast Oracle conference, (ECO), where I’ll also be doing a couple presentations on Nov. 3rd.

Nov. 9th

The next week I get to stay close to home for the Agile Test and Test Automation Summit.  This is a brand new event in the Denver area.  I’ll be doing a new talk here on Test Data Management, a hot buzzword, but one that people rarely understand the complexities and automation around.

Nov. 10th

The next day, I’m back downtown in Denver, where I can present at Rocky Mountain DataCon, (RMDC) event in Denver.

screen-shot-2016-10-04-at-12-24-56-pm

The RMDC is a newer event and it’s really been picking up traction in the Denver area.  I’ll be speaking on “The Limitless DBA”, focusing on the power of virtualization.  Kent Graziano, the Data Warrior and evangelist for Snowflake will be there, too.  I’m glad to see this new local event taking off in the Denver area, as the Denver/Boulder area consistently ranks high as one of best places to be if you’re in the tech industry.

I’m working to take it easy during the month of December, as I’ll have enough to do just catching up at work at Delphix and then with RMOUG duties with the upcoming Training Days 2017 conference in February 2017!

 

Posted in DBA Life, Delphix Tagged with: ,

September 22nd, 2016 by dbakevlar

The Oak Table network is a closed membership of about 100 technical scientists who have a passion for technology and the world around them.  These men and women, representing some of the brightest minds from each of their companies, are individuals who have built companies and major technical innovations.

Initially, much of their research and work was presented at Oracle Open World.  Over time, Oracle Open World welcomed less and less of their participation.  They decided to create their own network and present their information at their own conference, held annually at the same time as OOW.  Over a decade later, the event now has company sponsors and a dedicated following of Oracle specialists who attend to receive the deepest and most interesting details of technical data in the industry.

There is a “cool factor” for those going to Oak Table World.  Most of the members are also part of Oracle’s famed ACE Program, (most have ACE Director associations).  Some of the members work for Oracle; most members work for companies that are Oracle partners.  All of the sessions have a tendency to leave the attendee with their mind blown after each session.

billnye_mindblown

The conference this year was sponsored by Delphix, Pythian and Amazon Web Services and was held at the Children’s Creativity Museum.  The two day schedule only allows for 13 1-hour sessions and 8 10-minute “TED” style talks.  This year the conference attracted over 400 attendees in two days. A majority of the talks were the deeper technical content that wasn’t deemed suitable for the more marketing driven Oracle Open World event.
Because Delphix is one of the major sponsors, by default, it receives quite a bit of exposure at the event.  In addition to sponsoring, Delphix does the coordination for the event.  These opportunities provide us a way to create awareness with the primary technical thought leaders in the Oracle community.

In the next couple weeks, you’ll see a post on Oak Table with links for the presenters incredible slides and to the recorded sessions. One session that wasn’t captured was Toon Koppelaars one hour session on the first day. We know this was a session that many said was a must-see, so I’ll be working with Laura Ramsey from OTN to get a webinar set up so many can take advantage of Toon’s amazing contribution.

If you have questions, please feel free to reach out to me and I’ll happily share information on what we shared today and how we will continue to support Oak Table Network and thank you to each of the sponsors who, like Delphix, know the value of these incredible technologists.

delphix-logo_w_500 Pythian_Company_Logo_2015AmazonWebservices_Logo.svg

 

Posted in Database, DBA Life Tagged with:

September 8th, 2016 by dbakevlar

With me traveling to Redwood City next week to visit HQ and then Oracle Open World the week after, I’m busy during many of my off hours preparing a new Raspberry Pi STEAM setup for a maker’s faire the beginning of October.

I’d heard that many were having challenges with installing different HATs on their new RPI 3, especially older ones like the Pibrella.

pibrella1

This is still one of my favorite accessories for my RPI due to the button, speaker and three LEDs, but also since I can hot swap jump wires without risk of shorting out the unit like when you’re using the direct GPIO on the RPI.

I have a great new setup for travel for my Raspberry Pi that has the newest 7in touchscreen and protective case, which opens on the back.  Could I install my Pibrella with the constricted opening and the GPIO wires still powering the enhanced touchscreen card?

Knowing the GPIO setup

The Pibrella requires 26 of the pins to function and installation asks you to place the unit to the 1st pin.  It has a mini USB connector for power, but can run off of the GPIO.  The challenge is that the new 7inch touchscreen ALSO is powered by the RPI GPIO, connecting to pin 2, (5V) and 6, (Ground.)

When a competing configuration is found for GPIO, its important to inspect the GPIO map and see what is available:

gpio

Now using the above map, you’ll notice that pins 1, 2 and 3 are all power.  The Pibrella ONLY needs one 5V power source, which means that installing it from the first pin may be best practice, but it’s not required.   OK, so that means we can still use Pin 2 for the touchscreen.  Now, if we move down the Pibrella one, that leaves 6 rows of pins free at the other end. The 6 pin, which is the second necessary pin for the touch screen to ground it, can be shifted to the 39 pin, which is another ground pin!

I then moved the GPIO pins for the touchscreen and installed the Pibrella to the RPI 3.  It was a tight fit, but it did install:

 

Test the Installation

The next thing was to test it all.  Each of the GPIO connected match to the GPIO attached.  These will have to all be tested to see if there are any mismatches between the board and the RPI. The Pibrella library that is installed is just functions that have been written to tell what pins correspond to what commands.

So I run a small test script:

import pibrella

import time

pibrella.light.red.on()

time.sleep(2)

pibrella.alarm.on()

pibrella.light.red.off()

 

This script is to turn on the red light for 2 seconds, ring an alarm and then shut off the red light.

What happened?  The amber light lit on and then off.  No alarm-  yep, may have my monitor working and power to the pibrella, but as suspected, the GPIO orientation is off for each of the LEDs, alarm and I expect, the GPIO connections on the board.

Now I could give up my pibrella….or the touchscreen, but what if I’m just plain stubborn and want both?

So the files I need to work with are in the distribution packages for Pibrella.  I had to go to /usr/local/lib/python2.7

Now you may be wondering why this was in the Python 2.7 instead of the 3.4 distribution…  RPI 3 still has the 2.7 python set as default.  If you don’t change this, then this is where you go.  I prefer RPI 3 and write my code per Python 3 standards, but I’m not surprised the Pibrella library installed here.

Inside this directory, under the dist-packages is the Pibrella directory and it’s just a matter of .py, (python) files.  There is one called pins.py that I had to update to reflect the changes I made to my match my installation.  Now, we can fun the red light script and it actually lights up the correct LED.

It appears the alarm and button are set up in a different set of code, so now I need to just locate the other python scripts for the alarm and such and get that corrected.

That doesn’t mean I can’t get motors and other devices working from the new setup….

Oh Joy!!

 

 

 

Posted in DBA Life, Raspberry Pi Tagged with: , ,

August 31st, 2016 by dbakevlar

Oracle Open World 2016 is almost here…where did the summer go??

damn_fall

With this upon us, there is something you attendees need and that’s to know about what awesome sessions are at Oracle Open World from the Delphix team!  I gave my options up as is the tragedy of switching companies in late spring from Oracle, but you can catch some great content on how to reach the new level in data management with Tim Gorman, (my phenomenal hubby, duh!) and Brian Bent from Delphix:

After absorbing all this great content on Sunday, you can come over to Oak Table World at the Children’s Creativity Museum on Monday and Tuesday to see the Oak Table members present their latest technical findings to the world.  The schedule and directions to the event are all available in the link above.

If you’re looking for where the cool kids will be on Thursday, check out the Delphix Sync event!  There’s still time to register if you want to join us and talk about how cool data virtualization is.

If you’re a social butterfly and want to get more involved with the community, check out some of the great activities that, and I do mean THAT Jeff Smith and the SQL Developer team have been planning for Oracle Open World, like the Open World Bridge Run.

 

Posted in DBA Life, Delphix Tagged with: , , ,

August 19th, 2016 by dbakevlar

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.

alive

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.  If there isn’t a similar term or task, I’ve marked not applicable, (N/A).  If you have any additions or suggestions on how to improve the list, please feel free to comment or email me at DBAKevlar at Gmail.

As I’m still working on the best viewable format, keep in mind, you can export the table into a number of formats or even print it!

Thanks!

The Rosetta Stone for Database Platforms

Generated by wpDataTables

Posted in DBA Life, SQLServer Tagged with: , , , , , ,

August 2nd, 2016 by dbakevlar

otw

Anyone who’s anyone knows to search out OakTable World at major events in the US and Europe, and Oracle Open World 2016 is no different!

OakTable World 2016, (#otw16) will be held at the Children’s Creativity Museum again this year during the week of Oracle Open World.  The Oak Table members will be discussing their latest technical obsessions and research on Monday and Tuesday, (September 19th-20th).  The truth is, folks-  The Oak Table experts are an AWESOME group, (if I don’t say so myself! :)) as we could have easily done another day of incredible sessions, but alas, two days is all we have available for this year’s event.

This year’s sponsors to make sure the Oakies have a place to rest their weary laptops are no slouches themselves in the technical world:

delphix-logo_w_500Pythian_Company_Logo_2015AmazonWebservices_Logo.svg

Schedule-  A Work in Progress

I’ll continue to formalize the schedule as the session titles fill in and expect a few more ten minute ted talks to be added to the schedule as well.  Each session is 50 minutes, so there will be a 10 minute break between each session in this packed schedule!

The Great Dane

Mogens Norgaard will be opening Oak Table World on Monday, at 8:30am.  Be prepared to be awe-inspired by all he has to share with you, (which may go hand-in-hand with the amount of coffee we can provide to him…)

screen-shot-2016-09-19-at-8-08-00-am

screen-shot-2016-09-19-at-8-09-06-am

 

Location, Location, Location

If you’re unsure of how to get to Oak Table World, I’ve included a map below of San Francisco’s Moscone Center, where Oracle Open World will be.  OTW will be held in the Creativity Theater, which is in the museum behind the carousel, around the Southeast side of the building.

Moscone_ctr

Oak Table World is FREE to the PUBLIC!  We don’t require an Oracle Open World badge to attend, so bring a friend and they’ll owe you big time!

Food + Beer, Yes, I SAID BEER

So currently, instead of the formal breakfast and lunch that’s been previously offered, we’re going to try something more…”Oakie” and crowd friendly.  As the Executive Goth Girl, (my own designation) I am going for good coffee and awesome donuts in the mornings to fuel the attendees.  As lunch is offered with registration to OOW for 90%, (or more) of our participants, I’m spending money that would go to lunch and following the requirements for an event per the ABC, (Alcohol and Beverage Control of California) we’ll be having beer tasting from some of the local breweries.  We’ll have some fantastic munchies if you get hungry, but as we all know, beer is really a carb.  You can thank me later… 🙂

Video Streaming

For those of you wondering if we’ll be doing any recordings of the sessions-  OTN and Laura Ramsey have agreed to do the live streaming for the event, (because they ROCK!!) so be prepared for some seriously impressive content streaming your way from their channel after the event if you’re unable to attend.

I’ll keep this page updated with new information as Oak Table World 16 gets closer and thank you to everyone for their support!  Have questions or ideas?  Email Kellyn at dbakevlar at Gmail.

 

Posted in DBA Life, Oracle, Social Media Tagged with: , ,

July 14th, 2016 by dbakevlar

So some unknowing fool gave me full access to a fridge of Starbucks caffeinated beverages, which should be against the law in this fine country.  Needless to say, my ability to type approximately 180wpm has offered me the opportunity to catch up and blog about what it’s like almost a month in employed with Delphix.

typing fast 1

In just the last two weeks, a number of conference sessions have come about and events that I plan on being part of.  Some of them are well known, some aren’t and some require a bit of promotion to make them even greater than they already are, (you don’t want to be that person that wonders why they missed out, now do you?)

RMOUG Quarterly Education Workshop

At the end of this month, on July 29th, RMOUG is having their summer QEW at the Denver Aquarium.  The summer event is our second largest event of the year, (behind February’s Training Days conference) and the planning is starting to come together, (which is good considering it’s in a couple weeks!)  The speakers are two great ones in the community, Solarwinds’ Janis Griffin and OnX’s Jim Czuprynski.  We’ll have a Women in Technology lunch and learn, (Jim’s wife, Ruth, who had a long career in technology) will be part of the round table conversation with the women in our community to discuss some great topics!  If you have family you’d like to invite, check out the opportunity for discount tickets to enjoy the aquarium post the event!  You can read the details of the event and register at RMOUG’s website.

The Bay Bridge Run

The first will be a promotion for Oracle Open World.  Every year there is a run across the bridge on September 18th and it’s a great way to get to know some of the best people in the Oracle community before we get lost amidst the Moscone mayhem.  The view is fantastic and if you’re like me and age has impacted your ability to keep up with some of those in our community that like to run 100+ miles in a single outing, you can walk the bridge as well.  If you’re interested, check out the following Facebook link and come be a part of this great event!

baybridge

During Oracle Open World, I’ll be busy Tuesday and Wednesday, (Sept. 20th and 21st) at the Children’s Museum, heading up the Oak Table World.  It’s one of those tasks that I took over for Kyle so he can focus on what he does best.  The event will be at the Children’s museum by the Moscone again and we’re close to signing on Pythian and one other vendor to sponsor the event with Delphix.  Tim will be designing the great t-shirts that are coveted each year and I’m considering scheduling a hackathon if there’s enough interest.  I’ll get the schedule posted soon and thanks for everyone’s patience!

oaktable

 

OK, time for another Starbucks, pray for my office mates… 🙂

 

Posted in DBA Life Tagged with: , ,

June 24th, 2016 by dbakevlar

I’ve been going through some SERIOUS training in just over a week.  This training has successfully navigated the “Three I’s”, as in its been Interesting, Interactive and Informative.  The offerings are very complete and the knowledge gained is limitless.

I’d also like to send a shout out to Steve Karam, Leighton Nelson and everyone else at Delphix who’s had a hand in designing the training, both for new employees and for the those working with our hands on labs.  I’ve had a chance to work with both and they’re just far above anything I’ve seen anywhere else.

The Challenge of Patching and Upgrades

Most DBAs know-  If you attempt to take a shortcut in patching or upgrading, either by not testing or hoping that your environments are the same without verifying, shortcuts can go very wrong, very quickly.
hardway

Patching is also one of the most TEDIOUS tasks required of DBAs. The demands on the IT infrastructure for downtime to apply quarterly PSU patches, (not including emergency security patches) to all the development, test, QA and production databases is a task I’ve never looked forward to.  Even when utilizing Enterprise Manager 12c Patch Plans with the DBLM management pack, you still had to hope that you checked compliance for all environments and prayed that your failure threshold wasn’t tripped, which means a large amount of your time would have to be allocated to address patching outside of just testing and building out patch plans.

This is Where Delphix Saves the Day

I bet most of you already knew you could virtualize your development and test from a single Delphix compressed copy, (referred to as a DSource.) create as many virtual copies, (referred to as VDBs) as your organization needs to have for development, testing, QA, backup and disaster recovery, (if you weren’t aware of this, you can thank me later… :))

What you may not know, (and what I learned this week) is that you can also do the following:

  • Test patches and upgrades on a VDB or a DSource to verify there aren’t any issues instead of doing a full, manual clone which is very time consuming.
  • Apply patches and upgrades to a DSource and the patch and/or upgrade all the VDBs attached to the DSource by simply performing/scheduling  a refresh.

Screen Shot 2016-06-24 at 10.56.17 AM

Considering how much time and resources are saved by just eliminating such a large portion of time required for patching and upgrading, this is worth investing in Delphix just for this alone!

Want to learn more?  Check out the following links:

Testing Oracle Upgrade and Application Patching

Upgrade Oracle DSources After an Oracle Upgrade

Want to Demo Delphix? <– Click here!   

Posted in Database, DBA Life, Delphix Tagged with: , ,

June 7th, 2016 by dbakevlar

So after over two years at Oracle, I’m moving on.  Yes, for those of you who haven’t seen the tweets and the posts, you heard right.

dorothy_appaulled

OK, everyone-  cleansing breath.

I worked with great people and did some awesome things in the community, blogged everything Enterprise Manager and talked over 1/2 the Oracle community into buying and doing projects with Raspberry Pi while I was at it!

Many folks thought I was a product manager or a technical consultant, but my title was Consulting Member for the Technical Staff with the Strategic Customer Program with the Enterprise Manager and Oracle Management Cloud Group.  I know I was part of a select group at Oracle, but I believe the opportunity to work at Oracle was an important step in my career and I’d recommend it to anyone for the experience it provides.

There is a huge difference working for Oracle vs. being in the Oracle community, even as an Oracle ACE Director.  I was utterly amazed being part of the Oracle machine.  One of the most amazing experiences was observing how releases came together.   It was a complete different experience as an employee vs. a customer.  Being part of a massive undertaking such as a product release, impressively building out software to be released to its customer base is pretty astounding.  Understanding how and what it takes to move the machine and once it gets moving, how pertinent it is for anyone in its way to get out of the way is important to understanding how a successful product is created.

I learned a lot in just over two years and I have to admit-  many of the negatives that people said would be present at Oracle, I just didn’t experience.  I had great mentors and contacts inside of Oracle.  It’s easy to assimilate into a big company environment when you have people like Pete Sharman, Tyler Muth, Mary Melgaard and other’s looking out for you. I’ll be sad to leave all the great people that I worked with at Oracle, too-  Steve, Courtney, Scott, Werner, Andrew, Joe, Pramod and Will.  At the same time, I look forward to opportunities to learn new skills with the awesome folks that have so readily embraced my quirky self at my new company. I learned a great deal in my two years at Oracle and this is knowledge that I’m able to take with me as I move forward to my new adventure.

With that said, I’ve been offered an incredible opportunity to stretch my legs a bit and try something new and I am excited to move onto this new challenge.  I’ll still be speaking at conferences, but also will direct technology in a a way that should be very constructive to my technical style.

There has been a lot of rumors to where I’m off to.  Some of you have guessed correctly on where I’m going, but I know none of you guessed what I’ll be doing.  I will be focusing more on my multi-platform skills, so for those of you that thought I would be leaving all those years of experience in database and OS platforms, it’s going to be just the opposite.

I’m very excited to announce that, as of Monday, June 13th, I’m the new Technical Intelligence Manager at Delphix.

delphix

Buckle up, Baby!  This is going to be good.

Posted in DBA Life, Delphix Tagged with:

June 2nd, 2016 by dbakevlar

I know Werner DeGruyter will like the title of this post, so here’s a post dedicated to him as my last week at Oracle is off to a busy start…. 🙂

yoda

As I attempt to wrap up any open tasks at Oracle, I’m still Training Days 2017 Conference Director for RMOUG, have a planning meeting for the 800 member Girl Geek Dinner Boulder/Denver Meetup group that I’m the owner of, designing the booth and building out all the projects for the MakerFaire event at the Denver Science Museum next weekend and now have taken on the Summer Quarterly Education Workshop at the Denver Aquarium in the end of July.  This is a bit much as I start a new job for the end of June, but there are things that need to be done for community organizations to survive and often not enough people doing it.

As I know that many other user groups are in the same boat, I come to you with pleading, open arms and say to you, as part of your community, volunteer your time.  If all of us give a little, it really adds up to a lot in the end.  As attendees at conferences, events and meetups ask what happened to this or that group and wonders why they don’t have activities any longer, it seems to always boil down to commitment from it’s volunteers.  If it’s not fed and cared for by time and care, then it won’t survive.  I have this conversation at almost every user group conference and hear similar stories from meetup groups and other event groups that you might think are no where related.  It all comes back to the passion and commitment of those involved, along with the support of those that may not be giving as much, but ensure those that are, are well cared for.

So here are the rules for the survival of a group:

  1. Everyone do a little so no one is doing too much and you end up losing those valuable resources.  I see volunteer groups and board of directors that are commonly unbalanced and that is expected-  we all have lives and demands, but if it’s always like this with no check and balances, then it’s time to for people to step up and put in some time.
  2. If you aren’t doing, you don’t complain.  If you do see something that isn’t working well and want it fixed, please be prepared to volunteer some time to help out vs. volunteering others to do the work.  That’s just flaky and do you really want to be that flaky whiner at the event? 🙂
  3. Support the people who volunteer their time to your groups and defend them within an inch of your life.  Without them you don’t have a user group, you don’t have new members, you age out and your user group dies a slow, quiet death.  If you doubt me, just look at the strewn carcasses of user groups that were once impressive specimens in the event world.
  4. There is no magic formula.  What works for one group might not work for another.  There are some very impressive individuals that are working hard to create the newest, shiniest events that attract speakers, sponsors and attendees.  This is how it always will be. The groups that have been around awhile just need to keep updating with the new and improved to stay on top of the game and compete.

RMOUG has an incredible board of directors and our volunteers are SECOND to NONE!!  This has served us well all these years.  I don’t know how I would survive the demands of Training Days if it wasn’t for the volunteers and those on the board that help me when the going gets tough.  I’m quite aware of this need in other user groups as well.

So here’s the challenge for those of you out there-  Reach out to your local user group and consider volunteering a little time to one of it’s events.

  • Help with event check in.
  • Help with setup.
  • Consider sponsorship with your company.
  • Consider helping with the board, (we have members at large on our board that is a good way to test out the waters as a board member.)
  • Look at how to become a board of director.

Ask the user group or meetup what they could use help with and DO IT.

Here is the list of regional user groups from Oracle and from IOUG.  Find yours and volunteer to your community.  It’s worth your time, valuable to your career, and it’s the only way they can continue to be successful.

Posted in DBA Life, Oracle Tagged with: ,

May 11th, 2016 by dbakevlar

I fly out tomorrow for NoCOUG’s Spring Conference, which will be held on Friday, the 13th in San Jose, California. If you were thinking of attending and needed an added incentive to attend, I’ll be putting on a FOUR hour Enterprise Manager 13c hands on lab, so admit it, you’re intrigued… 🙂

friday_13th

I want to thank Iggy Fernandez, who is the heart of NoCOUG, for contacting me and asking me to do the HOL, along with the folks from Oracle ensuring that I have the environment to offer the attendees to enjoy this great event!

I’ll fly back out of San Jose on Saturday morning and then will be flying to Cleveland on Monday morning for the Great Lakes Oracle Conference, (GLOC).  I’ll have a couple presentations on Enterprise Manager 13c and will be hosting the Women in Technology lunch area with Maria Colgan and Elke Phelps!

It should be a great event-  lots of Oracle peeps, ACE and ACE Directors, along with some Oakies.. 🙂

The conference has been growing over the last few years with the great effort of the NEOOUG and their conference support team, headed up by Linda Hoover.  I know from my work on RMOUG’s Training Days, how much goes into a conference, so when we discuss user groups like NoCOUG and NEOOUG, it’s important to support your Oracle community.  It’s the only way these communities survive is with the membership and community support.  These are two groups that are well worth the effort to ensure we continue to do so.

For those that will be at these two great events in the upcoming two weeks, see you soon!

 

 

 

Posted in DBA Life, EM13c Tagged with: , ,

May 2nd, 2016 by dbakevlar

So Uwe Hesse caught my interest when he blogged about how to add your twitter handle to your time on your taskbar.  This is really cool for those of us that present, so that while we demo, you’ll see our twitter handle displayed at all times.

I did notice that his instructions, as most instructions I find for things on the Oracle side are for older versions of Windows or for Mac.  I have a Window 10 machine and yes, it’s possible, just a few steps different.

There are a number of ways to do this….most of them are long, so I’m going to try to take you through the least amount of steps in Windows 10, which for some reason, has buried time settings… 🙂

The Easy Way

Click on the Start Window and the Auto Search Function is activated.  Type in Region.

Click on the one that has the following icon:

datetime1

Click on Additional Settings at the bottom of the Region window:

datetime3

And now you will be at the same basic Time settings as you would be in Uwe’s instructional post and can changed the displayed symbol for AM and PM to your twitter handle.

datetime2

Thank you for sharing this with us, Uwe! 🙂

Twitter_taskbar

 

 

 

 

Posted in DBA Life

  • Facebook
  • Google+
  • LinkedIn
  • Twitter