• DBA Life - Oracle

    Denmark, MOW2012 and ODTUG’s KSCOPE Blog

    I am preparing to fly out to Denmark tomorrow for Miracle Open World, 2012 in Billund, Denmark, MOW2012 It will be my first time to Europe, so I’m highly anticipating the journey and conference. I also had the pleasure of guest blogging on ODTUG’s blog this week: ODTUG’s Blog I’m all packed, ready to go and ramping up for KSCOPE 2012 in June!! Enkitec will have a huge booth, no doubt and we will have a solid group of folks speaking at the event!

  • DBA Life - Oracle - SQLServer

    Assumptions- The Other DBA Killer

    ~ The least questioned assumptions are often the most questionable ~ Paul Broca I’ve always found assumptions to be one of the most common cause of failures in software releases/maintenance windows. If I had a dime for every time I’ve heard, “I thought you were going to take care of/do that…” or “I didn’t involve you earlier because I thought the steps you were responsible for were so easy…”, well, you know the saying and I’d be rich. Assumptions causing participation of the DBA too late into a project, release or maintenance is widespread enough when you are onsite, but…

  • Enterprise Manager

    EM12c’s Configuration Topology

    This is another little known feature, but one you have to work with to get a solid feel for and find value in. When I came upon it in EM12c, I was not that impressed, but quickly became more impressed with the “just the facts” and “all in one” interface that it is, especially if you are working in a RAC environment. Its another one of those features the DBA can stumble upon as they are working through issues, but to purposefully utilize it, the quickest way is after logging into the Enterprise Manager, click on Targets –> Hosts and…

  • Oracle - SQLServer

    Oracle for the SQL Server DBA Presentation Slides

    Chris Shaw from Colorado Springs SQL Server SQLPass group invited me to come speak at this wonderful group last week and I promised a few folks that I would upload my slides to my site, (they are also available via Chris, too…) The group is a small, close knit group that I was very pleased to have the opportunity to speak to and look forward to having more interaction with in the future! Thank you to Chris and the rest of Springs SQLPass! Oracle for the SQL Server DBA Slides

  • DBA Life - Oracle - SQLServer

    Enkitec and SQLPass, Colorado Springs Style

    Two things to be happy about today! 1st-  Enkitec did a lovely announcement on Enkitec regarding my coming on board.  I just arrived last night after three days at the main office in Irving, Tx, (Dallas area is lovely with all the fields of Blue Bonnet flowers this time of year…) and am psyched about working remotely for them from my home, northwest of Denver. 2nd-  I have a wonderful opportunity to speak this evening at Colorado Springs SQL Pass group on “Oracle for the SQL Server DBA”.  SpringsSQL It’s only going to get crazier the next two months from…

  • Database

    My Review of REI Monorail Sling Bag

    Originally submitted at REI The REI Monorail Sling bag has the volume of a daypack and the features to meet all the challenges of the daily urban grind. Outdoor-inspired details make hauling the load comfortable and convenient. REI Monorail Sling Bag Light, Sturdy, Roomy and Comfortable!! By dbakevlar from Westminster, CO on 3/17/2012   5out of 5 Pros: Lightweight, Easy To Access Items, High Quality, Comfortable, Good Capacity, Easy To Carry, Stylish Cons: No Zipper pocket in main Best Uses: Weekend Trips Describe Yourself: Modern, Stylish, Practical, Comfort-Oriented, Career Travel Frequency: 6-10 Annual Trips Primary use: Business Was this a…

  • Database

    SQL Saturday Presentation!

    Due to scheduling conflict though, it’s on a Thursday evening for once! I will be presenting for the first time as an Enkitec employee in Colorado Springs, March 22nd. All you SQL Server folks out there that want to come on out, here are the details: SpringsSQL

  • DBA Life - Oracle

    KSCOPE 2012 Events!

    I’m forwarding out the latest KSCOPE 2012 Email. I love their stuff!! ———————————————————————————— The stars at night are big and bright, deep in the heart of Texas… And some of the brightest stars of the Oracle world will light up the scene at ODTUG’s Kscope12, San Antonio, June 24-28. Celebrated around the world for its top-notch content, outstanding networking opportunities, and memorable special events, ODTUG Kscope is unquestionably THE premier user conference for Oracle training. Kscope12 promises to deliver the goods again this year! At last year’s special event, ODTUGgers were putting on the Ritz aboard the Queen Mary. At…

  • Database - DBA Life

    The Technical Bully Scenario

    I’ve been again, unfortunately, reminded what makes a poor work environment for a DBA or Developer.  Eddie Awad had sent this out and the second one really resonated with me: http://www.washingtonpost.com/national/on-leadership/how-to-completely-utterly-destroy-an-employees-work-life/2012/03/05/gIQAxU3iuR_story.html?tid=sm_twitter_washingtonpost I refer to this in the IT world as the “technical bully syndrome” and it’s quite common in the arena.  It’s not because it’s a male dominated group- I’ve seen bullies come in all shapes and sizes, along with being of both genders.  In fact, there are a couple studies out there that say women managers and leads are more likely to bully a subordinate than a male is.…

  • DBA Life - Oracle

    CBO, Statistics and A Rebel(DBA) With A Cause

    This is not an “I’m against Oracle Best Practices” article. This is not an “I’m preaching against histograms” article. This is not an article telling folks that they should EVER take the steps or the choices that are presented in this article. I’m also going to refer to the wonderful post by Greg Rahn as to the reasons why what works in my environment would most likely NOT work in yours: http://structureddata.org/2008/10/14/dbms_stats-method_opt-and-for-all-indexed-columns/ What this article IS:  An honest account of how a unique database design was impacted when changing from a previously researched method of stats collection to post an…

  • DBA Life - Oracle

    RMOUG 2012 Revisited

    As many of you know, I’ve been a bit busy since RMOUG Training Days finding a number of presentation opportunities and while I was at it, a new gig with Enkitec. I am finally sitting down and putting to paper what a great year the RMOUG Training Days conference had for 2012. As everyone is still reeling from the great keynote from Cary Millsap, (so glad I was wrong about screwing up my passenger pick-up schedule, thinking I’d left our keynote speaker at the airport!!)  His speech was enlightening, enjoyable and worth every minute of a heavy morning commute to…

  • Database

    Kellyn’s Presentation Schedule, Spring/Summer 2012

    Kellyn’s Schedule of Presentations, 2012, 2nd and 3rd Quarter March 24th, 2012, Colorado Springs, CO SQL Saturday Oracle for SQL Server DBA’s April 19th, 2012, Billund, Denmark MOW 2012 ASH Analytics- Top Activity, the Next Generation April 20th, 2012, Billund, Denmark MOW 2012 EM12c: Making Oracle Enterprise Manager Work for You May 30th, 2012, Hämeenlinna, Finland OUG Harmony 2012 EM12c: Making Oracle Enterprise Manager Work for You June 1st, 2012, Riga, Latvia JUV Harmony 2012 EM12c: Making Oracle Enterprise Manager Work for You June 26th, 2012, San Antonio, TX. KSCOPE 2012 EM12c: Making Oracle Enterprise Manager Work for You

  • Database

    11g, Sherlock Holming it with Statistics, Histograms and Bind Peeking

    Yes, my dear Watson, Bind Peeking is still an issue in 11g…. We recently upgraded from 10.2.0.4 to 11.2.0.2.0 and come across a couple interesting performance challenges. I do like this type of problem and have been quite busy working on the fixes for each one that has shown itself. This was one of the latest, requiring a solid, positive relationship between the developer and the DBA to solve- The DBA may have the answer, but the developer must be comfortable with the solution and make the code/design change that is required to correct the issue. I do work with…

  • DBA Life - Oracle

    RMOUG 2012 Presentation Slides!

    Graham Wood was kind enough to send me a quick email and let me know that my presentation slides weren’t downloading correctly from RMOUG’s website, so I’ve put them here for anyone that may like to have them. I’m still recovering from the post RMOUG Training Day festivities, aka Foak Table, which was held up in Breckenridge again this year. I will make sure to blog about Training Days and the post event at a later date, but until then, here is a link to my slides. Please email me with any questions or comments you may have- always glad…

  • Oracle

    Getting the Most Out of Enterprise Manager and Notifications

    I ran out of time before I was able to provide an adequate white paper this year for my EM12c presentation, but there was some valuable info in what I had started, so thought I’d turn it into a mulit-part blog post… The Oracle Enterprise Manager, (OEM) is the standard monitoring tool for Enterprise Edition Oracle databases.  The interface allows the DBA to manage the entire Oracle stack using a single console.  The installation and interface is easy for most DBA’s to implement and utilize.  In the newest EM12c version, it encompasses integrated systems management, application management, application-to-disk and cloud…

  • DBA Life - Oracle

    RMOUG 2012!

    As busy as I am with the 11g project, (no real weekends off for 9 weekends and counting… :P)  I wanted to take some time out to write on the upcoming RMOUG Training Days 2012. For those of you Oracle techies, DBA or Developer, this is a must attend and for any who do choose to travel and attend- kudos to you, good choice.    As one of the directors on the RMOUG board, I can attest to the incredible amount of time and resources that have been invested into what is easily, the best grass-roots, Oracle conference around.  John Jeunette,…