Skip navigation.

DBA Blogs

Simplifying Docker Interactions with BASH Aliases

Pythian Group - Thu, 2015-10-08 12:21
Landing a Docker Whale

Docker has been consuming my life in the last few weeks. I have half a dozen projects in progress that use containers in some fashion, including my Visualizing MySQL’s Performance Schema project.

Since I prefer to work from a Mac laptop, I have to utilize a Linux Virtual Machine (VM) which runs the Docker daemon. Luckily, Docker Machine makes this a very simple process.

However, interacting both with Docker and Docker Machine does introduce some additional commands that I would rather simplify for the repeatable use-cases I’ve come across. With BASH aliases, this is not a problem.

Is My Docker Environment Setup?

When working with Docker through Docker Machine, you first have to set up your environment with various DOCKER_* variables, such as these:

View the code on Gist.

The first alias is an easy way to check that the Docker environment is setup.

View the code on Gist.

Now, all I have to type is de, and I get the Docker environment output:

View the code on Gist.Setting up My Docker Environment

But how do you set up the environment with Docker Machine? The docker-machine command provides the details:

View the code on Gist.

Notice that the comments indicate you have to run the command through eval to get the terminal setup correctly. I don’t want to type that out each time I open a new terminal.

The docker-machine command requires the name of the VM to set up as an argument, so I’ve created a function to accept the argument:

View the code on Gist.

Each time I open a terminal I can setup the environment:

View the code on Gist.

If you only use one Docker VM for local development, you can hardcode the name of it to execute the command to automatically setup the docker environment when a new terminal is created.

Cleaning Out Docker Images

The last helpful alias I have comes from building and re-building containers that have left old images on my VM.

View the code on Gist.

The docker-clean command cleans up all dangling images:

View the code on Gist.

And running the docker-clean command yields:

View the code on Gist.

I put all of these aliases and functions together in my ~/.bash_profile* script, which is executed anytime I open a terminal window:

View the code on Gist.

*Note: Instead of putting these aliases and functions in ~/.bash_profile, other distributions would look for them in ~/.bashrc or ~/.bash_aliases to ensure they are available for all types of interactive shells.

If you have any other commands to simplify Docker interactions, please share them in the comments!


Discover more about our expertise with DevOps.

Categories: DBA Blogs

Partners Guide to Oracle Cloud - The Oracle Cloud Playbooks

OPN has published the Oracle Cloud Platform Strategic Partner Playbook for a while now, designed exclusively for partners. This was created in close partnership with Product Marketing, Product...

We share our skills to maximize your revenue!
Categories: DBA Blogs

My Delphix presentation at OakTable World

Bobby Durrett's DBA Blog - Wed, 2015-10-07 17:52

It is official.  I will be doing my Delphix presentation at OakTable World during the Oracle OpenWorld conference at the end of this month.  My talk is at 9 am on Tuesday, October 27.

I will describe our journey as a new Delphix customer with its ups and downs. I tried to have the spirit of a user group talk where you get a real person’s experience that you might not get from a more sales oriented vendor presentation.

Kyle Hailey, a OakTable member and Delphix employee, will host my talk.  I have been very impressed by Kyle’s technical knowledge and he will be with me to answer questions about Delphix that I could not answer.  I think it will be a good combination of my real world user experience and his depth of technical background in Delphix and Oracle performance tuning.

If you are going to OpenWorld and if you want to know more about Delphix come check it out.  Also, feel free to email me or post comments here if you have any questions about what the talk will cover.


Categories: DBA Blogs

Partner Webcast – Oracle Mobile Cloud Service: Gates to Enterprise Mobility for Your Business

Nowadays Mobility has definitely disrupted business models. Mobile first companies that are using the context of mobile to create unique applications are creating new business models disrupting and...

We share our skills to maximize your revenue!
Categories: DBA Blogs

Partner Webcast – Rapid Digital Transformation with Oracle Process Cloud

Today, IT is heavily optimized to develop and manage longer running durable applications with evolutionary change, current demand calls for creation of disposal applications and fast frequency...

We share our skills to maximize your revenue!
Categories: DBA Blogs

Oracle E-Business Suite: Virtual Host Names

Pythian Group - Tue, 2015-10-06 07:56

The ability to use virtual host names with Oracle E-Business Suite is one of the features that I have been waiting for a long time. When I finally saw a post on Steven Chan’s blog about it, I was very excited. But, when I finally got to review the Mos note “Configuring Oracle E-Business Suite Release 12.x Using Logical Host Names”, I was left with disappointed.

In my opinion, the main advantage of using virtual host names is during a DR failover scenario. By using virtual hosts we can setup the servers in both a primary datacenter and secondary datacenter to use the same virtual hostname, even though their physical hostnames are different. This virtual hostname setup helps when we failover services and databases to a secondary datacenter, as we don’t have to reconfigure the application to use new physical hostnames. Currently when we install E-Business Suite to use a virtual hostname, “Concurrent Managers” dont work, as they internally use the physical hostname to communicate.

The new MOS note describes this very feature of using virtual hostnames with Oracle E-Business Suite. But why I am disappointed? Because it left a very important use case out. In most cases when virtual hostnames are used, the servers are configured with a different physical hostname. i.e., if you run hostname or uname commands you will see that the actual physical hostname and virtual hostname is only present in DNS and hosts file. This scenario is not covered by the MOS note. The MOS note asks us to reconfigure the server with virtual hostname such that when we type hostname or uname command it shows the virtual hostname instead of the physical hostname.

I believe the need to reconfigure the server to use a virtual hostname, defeats the main purpose of setting up virtual hostnames, making this MOS note useless :(

Thus, I will keep on waiting for this out of the box feature. I currently have a custom in-house method to use virtual hostnames with E-Business Suite that I will blog about it in future.


Discover more about our expertise with Oracle.

Categories: DBA Blogs

Submit an abstract for Georgia Oracle User Group (GaOUG) Tech Day 2016

DBASolved - Mon, 2015-10-05 10:15

In 2014, myself, Danny Bryant and Stewart Bryson, from the Atlanta area were added to the board of directors for the Georgia Oracle User Group (GaOUG). With us being added to the Board of Directors, we initatied a rebranding of the user group from GOUSER to GaOUG in Feburary 2015, with much success. Then followed that event up with two quarterly events in April and July 2015, which proved to be an even bigger sucess and we continue to build on each success due to people we have been able to attract for quarterly events. After the success of our quarterly events, the board of directors established a goal of bringing the best speakers, locally, nationally and internationally, to the Atlanta area for a 1 day conference in 2016. So, I’m here to promote the conference and to hopefully convence you to submit an abstract to this new event on the conference circuit.

Little Background:

When I first moved to the Atlanta area (2001), I didn’t know anything about Atlanta much less the Oracle community. I joined GOUSER around 2006 with little going on in the community (story for another time). It wasn’t until 2012, when I first ventured out onto the conference stage at Oracle Open World 2012. For my first conference, it was nerve racking to say the least; however, I was introduced to many great people that year and my career, personal and professional networks, and friendships have benefited from that experiance. These are just some of the reasons why I keep submitting annually for a wide range of conferences and why I’m helping to bring this conference to Atlanta.


The aim of GaOUG Tech Day 2016 conference is to start small and grow into the best regional Oracle User Group conference in the Southest! This can only be achived with the help of great speakers (new and existing) from the Oracle Community! With that being said, our call for papers is currently open (submit here).

GaOUG Tech Day 2016 will have three categories for abstract submissions. These include Database & Development, Middleware and Applications. These categories cover a wide range of technologies form the Oracle stack plus many others.

Submitting an Abstract:

Before you submit your abstracts, there are a few reminders that you should be aware of that make a great abstract:

  1. Take the time to make a great abstract title and fill out the abstract and summary completely!
  2. Run it through spelling and grammar check.  If you submit a “sloppy” abstract with misspellings and errors in grammar, how can we know that you’ll take the time to ensure that the presentation will be performed professionally and technically accurate?
  3. List a few take-aways the attendee will leave with.  What is the value that will be gained by attending your session?
  4. Fill out your speaker biography.  We like to know a bit about you and why you are important to have presenting at the conference.
  5. No marketing!  Keep your session technical.  Our conference is a technical conference and nothing irks our attendees like marketing!  If they like what you are teaching, they’ll search out your company and/or product-  trust me!

(Tips were provided by DBAKevlar, thanks Kellyn!)

First/Local Time Speakers:

Finally, if you are submitting an abstract and you are a first time or local speaker; do not hesitate to reach out to the board and ask for guidance and/or mentoring. The board of directors has the experience to assist you in your submissions and selections. We are looking forward to and wanting to hear from new speakers in the community and help build your confidence in the speaking arena.

Submit your abstract today! Deadline for submissions is November 2nd, 2015!

Filed under: GaOUG, General
Categories: DBA Blogs

Five Years, Five Top 5’s

Pythian Group - Sun, 2015-10-04 22:59


Five Years, Five Top 5’s

On October 4th, 2010 I joined Pythian. At that time Human Resources (HR) was a team of one, supporting 90 employees in 13 countries. Five years later on October 4th 2015, HR is now a team of fifteen, and today Pythian celebrates a milestone as we reach 400 employees in 36 countries!

What an incredible journey (…and yes, it’s all about the journey)!

The opportunity to work with stunning colleagues and to collectively build a team of passionate and talented HR professionals who continuously make me laugh, inspire me with their creativity, and challenge me to be a better leader is both a privilege and an honour. I am fortunate to work alongside them every day.

As members of Pythian’s HR team, we are business leaders. We care about (and contribute to) the success of Pythian. We solve the puzzles that can come with growing a business from 90 to 400 employees in five years. We deliver quality of service to our clients. We make a difference. We value our employees. We have fun.

To celebrate five incredible, challenging and rewarding years I share my Top 5’s.


Five Things I Appreciate Most About Pythian HR:

We are strategic.

We think global, not local.

We are productive, not busy.

We brainstorm without the “but”.

We are consistent, fair and we care.


Five Favorite Moments:

Each HR hire and expanding our HR team globally in 2014.

Celebrating our 2013 HR Initiative of the Year win with our world class HR team.

Reaching 200 employees in September 2012.

Celebrating our First Geek Day on May 25th 2011 and observing our global team spirit has grown.

Delivering our first BORG and Orientation session on January 4th 2011.


Five Favorite Programs We Have Built:

Love Our Community, the programs that supports our global employees and their communities.

SEED, the Self Directed training and professional development fund.

Delphic Journey, the Performance Feedback program.

Delphic Iris (the newsletter) and Newsflash (the weekly update).

Pythianology, the internal speaker series that showcases our talents, passions and interests.


Favorite Leadership Lessons in 10 Words or less:

Leadership is an art, not a science.

Lead the way you want to be led.

If you don’t lead by example, you are not leading.

Embrace Self Awareness, but focus your efforts on Self-Regulation.

Words matter. Less is more.


Five Favorite Books from the Last 5 Years:

You Are the Placebo: Making Your Mind Matter

The Power of Habit

When All You Have Is Hope

Turn The Ship Around

Speaking As A Leader


Steve Jobs once said that “Your work is going to fill a large part of your life, and the only way to be truly satisfied is to do what you believe is great work.  And the only way to do great work is to love what you do”.

Great work, amazing colleagues, and the opportunity to do what I love…thank you Pythian for a fantastic five years!

Categories: DBA Blogs

Enterprise Manager 12c R5 - Manage Hybrid Cloud from a Single Interface

Oracle recently announced Oracle Enterprise Manager 12c Release 5, which simplifies the journey to the cloud.  For the first time, with Release 5 ( you will be able to manage your...

We share our skills to maximize your revenue!
Categories: DBA Blogs

Pythian’s Velocity of Innovation Event Gives Attendees a View Into the Future of IT

Pythian Group - Fri, 2015-10-02 12:20

This summer I had the opportunity to moderate a discussion that brought together IT’s most innovative thought leaders with some of North America’s top CIOs. And we gave the CIOs the chance to ask the panelists anything. Here’s what happened.

When three of the most respected information technology thought leaders came together with 20 of North America’s top CIOs for an hour and a half in New York City this summer, the result was a compelling discussion about the future of IT.

Pythian supplied the panel of experts at the Velocity of Innovation CIO event: Paul Vallé, Pythian’s founder and CEO; Gene Leganza, vice-president, principal analyst serving enterprise architecture professionals at Forrester Research; and Otto Toth, CTO at Huffington Post. And the attendees supplied the questions, covering an impressive range of topics.

More than an exchange between panel members, the 90-minute session fully engaged the audience in a discussion about everything from agile software development and the importance of being a data-driven business to such forward-looking matters as artificial intelligence and virtual reality.

This blog post is the first of a series that focuses on topics covered in the Velocity of Innovation discussions in New York, and concentrates on the first question addressed: putting innovation and agility into practice.

Question: Innovation and agility are common buzz words to describe what everybody wants. What have you explicitly done to get better at innovating or to make your organization or your clients’ organizations more agile? And how has this push for agility impacted either your enterprise architecture or your enterprise culture?

Otto Toth: Innovating quickly is not always in the best interest of the business, or it may not be easy to do properly. It can actually work against the business. Instead of moving faster, being very agile can slow down everything.

Everybody has a different perception about what agile should be and we have our own definition. We started to build our own CMS three years ago. We started very agile, building everything simultaneously. Later, we decided to use Scala as the programming language, but it’s hard to find people who are educated in this language.

A year ago, I changed the process a little bit. Now we break down the process into small pieces and modules. After three years in development, we finally shipped the first module of our CMS. This is an interesting story about how big agility can slow down the whole process.

Most users don’t really know what they want. Too many decision-makers just slow down the process. It’s better to have a few selective people or a core team who make the decisions and dream about features that are not available.

Gene Leganza: What makes an enterprise agile is being able to sense what’s going on in the marketplace and responding to it. What’s happening in your marketplace is about being able to deal with data. The ability to understand everything that everybody is doing and everything their friends are doing because of available data means you can be in tune with the marketplace as never before.

What does that mean for your organization? Data modelling and data integration are starting to migrate to the business side, where people are doing self-service analytics. If you try to keep up by jumping on some of this technology, you may shoot yourself in the foot. Instead of being on the leading edge, pay attention to what’s going on and when you figure out how to do it right, then do it as soon as possible. You avoid shooting yourself in the foot and you’re not that far behind the leaders of the dot-coms.

The flip side of agility is innovation. An interesting aspect of innovation is getting really hot talent into your environment. Getting the right talent and doing smart things and being leading edge are challenges. You have to figure out what level to drop in on, where you are in the industry. Are you a startup or are you a state organization that needs to be a fast follower?

Paul Vallé: Addressing what Otto Toth highlighted, tying up capital for three years is an enormous cost, in carrying costs, as well as competitive posture. Any solution you imagined three years ago has three years of technical debt when it launches. Three years is about the amount of time we expect the system to last before renewal. This is a key problem that the agile development methodology tries to tackle.

If you can create high bandwidth, you have access to a lot of knowledge and a lot of insights. Then you have low latency, and you’re able to respond to what you learned quickly and you’re able to inform your business decisions.

Your systems must be alive and you must continuously push them forward and tighten up your release cycles. You should try to release four or eight times a year, and eventually get to a point where you can do multiple releases per day, and even do per feature releases.

Per feature releases are ideal in an agile world. It gives you the high bandwidth, the low latency and feedback loops. And a per user feature enablement lets you create an A/B testing capability for new revolutions of your application. Moving to per user feature enablement and per feature releases is an enormous transformation and has everything to do with agility and velocity.

Audience comment: As a CTO manager, what resource do you use to be skeptical of smart engineers who want to build things from scratch?

Otto Toth: I have a very simple rule that if the service costs less than an engineer’s one-year salary, then don’t even think about developing it. Two weeks can turn into two years and 10 people and can result in nothing.

Gene Leganza: There’s a notion at the engineer level that agile means “There’s nothing between me and creating a solution. That’s what you hired me for and I have the smarts. And I don’t want any bureaucracy.” Then there’s agility at the enterprise level, which is about reducing risk and understanding how soon change can be in production.

What I tell people is it depends who you talk to. The higher up you go, the more people are going to be receptive to what improves the whole portfolio rather than one project.

And this is where architects come in, someone who has been hands-on, and has the credibility and knowledge to guide the organization more strategically.

Interested in being a part of a discussion like this one? VELOCITY OF INNOVATION is a series of thought-leadership events for senior IT management hosted by Pythian. Pythian invites leading IT innovators to participate in discussions about today’s disruptive technologies: big data, cloud, advanced analytics, DevOps, and more. These events are by invitation only.

If you are interested in attending an upcoming Velocity of Innovation event in a city near you, please contact To view our schedule of upcoming events visit out Velocity of Innovation page.

Categories: DBA Blogs

Pythian at Oracle Open World 2015

Pythian Group - Fri, 2015-10-02 11:45


Are you excited for this year’s Oracle Open World 2015? Pythian will once again be attending and participating in a number of marquee presentations and events.

This event is an amazing opportunity to hear from the finest minds in the Oracle space from Pythian and across the industry. We will be sending our Oracle experts to deliver some compelling presentations, packed with best practices, expert tips and advice that you won’t want to miss (See schedule below). Make sure you take some time to connect with us, and engage with our sought-after Oracle experts.


Oak Table World

Don’t miss the popular mini conference – Oak Table World in San Francisco, October 26th & 27th. There is a stacked agenda for this years conference along with our very own CTO Alex Gorbachev on stage at 3PM October 27th.


Bloggers Meet-up

Once again, we are thrilled to announce that we will be co-hosting the Annual Bloggers Meetup, organized in partnership with the Oracle Technology Network on October 28th (Save the date!). Be on the lookout for a blog post from Alex Gorbachev, Pythian’s CTO, providing details including the location, opportunities to connect, and activities.


Contact Us

Should you wish to schedule time to connect with one of our experts at OOW reach out to Emilia (Partner Program Mgr/ and she will be happy to help set that up. Alternatively, catch all the action live from @pythianpartners while on site. This is the best way to get a hold of any of the Pythian team attending the event.

Attention Pythian Partners & clients, if you’re attending please reach out to us for details on social happenings you won’t want to miss!

See you there! #oow15 #pythianlife



Pythian Sessions at Oracle OpenWorld 2015

Alex Gorbachev

Session 1 – Bridging Oracle Database and Hadoop

Date/Time: October 25, 8:00 am – 8:45 am | Moscone South—303

Abstract: Modern big data solutions often incorporate Hadoop as one of the components and require the integration of Hadoop with other components including Oracle Database. This presentation explains how Hadoop integrates with Oracle products focusing specifically on the Oracle Database products. Explore various methods and tools available to move data between Oracle Database and Hadoop, how to transparently access data in Hadoop from Oracle Database, and review how other products, such as Oracle Business Intelligence Enterprise Edition and Oracle Data Integrator integrate with Hadoop.


Session 2 – Solving the “Dirty Secret” of Big Data with Oracle Big Data Preparation Cloud Service

Date/Time: October 27, 5:15 pm – 6:00 pm | Moscone South—310

Abstract: Big data promises many game-changing capabilities, but the “dirty secret” is that up to 90 percent of big data project time is spent preparing the data so that it can be usefully analyzed. Join this session to see a live demonstration of a new solution to this problem—Oracle Big Data Preparation Cloud Service. See how Oracle Big Data Preparation Cloud Service takes “noisy” data from a broad variety of sources in many different formats, both structured and unstructured, and uses sophisticated statistical, knowledge-based, and machine-learning algorithms to cleanse, enrich, and blend it into useful data streams, ready for further discovery, analysis, and reporting.


Oracle Multitenant: Customer Panel Date/Time: Wednesday, Oct 28, 1:45 p.m. | Moscone South—301Abstract: Attend this session to hear from some of Oracle’s leading customers about their successful deployments of Oracle Multitenant.

Session 3 – Oracle Multitenant: Customer Panel 

Date/Time: October 28, 1:45 p.m. | Moscone South—301

Abstract: Attend this session to hear from some of Oracle’s leading customers about their successful deployments of Oracle Multitenant.

Rene Antunez

Session 1 – Oracle Exadata 101: My First 100 Days with Oracle Exadata 

Date/Time: October 25, 3:30 pm – 4:15 pm | Moscone West—3011

Abstract: The biggest headline at the 2009 Oracle OpenWorld was when Oracle’s Larry Ellison announced that Oracle was entering the hardware business with a prebuilt database machine, engineered by Oracle. Since then, businesses around the world have started to use these engineered systems. This beginner- to intermediate-level session takes you through my first 100 days of administering an Oracle Exadata machine and all the roadblocks and success I had along this new path.


Session 2 – Private Cloud Provisioning Using Oracle Enterprise Manager 12c

Date/Time: October 25, 12:00 pm – 12:45 pm | Moscone South—305

Abstract: With the newest version of Oracle Database 12c and its multitenant option, we are moving toward an era of provisioning databases to our clients faster than we ever could, even leaving out the DBA and allowing the developers and project leads to provision themselves the database that they need. This presentation guides you through the different ways you can provision data from one Oracle Database to another using Oracle Enterprise Manager 12c.


Session 3 – Oracle Recovery Manager 12c>: It’s Alive and All About Recovery, Recovery, Recovery 

Date/Time: October 25, 9:00 am – 9:45 am | Moscone South—304

Abstract: Oracle Recovery Manager (Oracle RMAN) has evolved since being released in Oracle 8i Database. With the newest version of Oracle Database 12c, Oracle RMAN has great new features that allow you to reduce your downtime in case of a disaster. In this session, learn about the new features that were introduced in Oracle Database 12c regarding recovery and configuration tips, and go over several demos so that if you are ever faced with this adversity, you will come out on top.


Session 4 – Database as a Service: What Is It and How Do You Use It? A Q&A with an Expert Panel 

Date/Time: October 29, 9:30 am – 10:15 am | Moscone South—102

Abstract: What is the best method for delivering, setting up, and using database as a service (DBaaS) utilizing Oracle software, hardware, or the cloud? Within a company (private cloud) there are several ways, outside of a company (public cloud) there are additional ways, or you can use a combination of both. For IT, Oracle Database, and technology professionals, platform as a service (PaaS) and DBaaS are technologies you need to know about and use to stay current in your profession. Attend this session to learn about technology and deployment choices available using Oracle technology and solutions. Subject matter experts from Oracle OpenWorld and Collaborate answer your questions so you can architect, plan, and implement a successful DBaaS project.


Christo Kutrovsky

Session 1 – Oracle Real Application Clusters Solving Common Scalability Problems 

Date/Time: October 25, 8:00 am – 8:45 am | Moscone South—304

Abstract: In this session, explore the promise of near-linear scalability that Oracle Real Application Clusters (Oracle RAC) makes. This session investigates several common problems in detail and presents solutions that are transparent to the application. Cache fusion contention, write-write contention, application partitioning and indexing are some of the topics discussed. Specific examples and their solutions are provided as well as performance comparisons.


Maris Elsins

Session 1 – Mining Automatic Workload Repository: Alternative Methods for Identification of the Top SQLs 

Date/Time: October 25, 1:30 pm – 2:15 pm | Moscone South—308

Abstract: We can use reports from the Automatic Workload Repository feature to quickly identify the SQL_IDs of the top statements in the database. But what if the Automatic Workload Repository report reveals no “low-hanging fruit,” and the resource usage is evenly distributed among multiple statements? Where do we start? Is there a better way to identify the starting point for the tuning of a resource-bound system? This session explains when the Automatic Workload Repository reports are misleading and how to look at stored data from a different angle to determine the top consumers. This session includes a practical demonstration using scripts for Automatic Workload Repository mining that attendees can apply to their own challenging database performance tuning problems.


Nelson Calero

Session 1 – Oracle Exadata Maintenance Tasks 101 

Date/Time: October 25, 1:30 pm – 2:15 pm | Moscone West—3011

Abstract: You have been working as a DBA for years and are planning/starting to support an Oracle Exadata installation. There are several planned and unplanned maintenance tasks that you will face, each one involving many details. Don’t wait to master them through practice—in this session, the speaker shares their experience with Oracle Exadata installations during the last few years, and shares details of the most common maintenance tasks and best practices to make better use of your resources. This includes setting up ASR, replacing components (hard and flash drives, batteries, InfiniBand switches, and more), and patching.


Session 2 – Get More Out of Your Oracle Investment in Latin America

Date/Time: October 25, 2:30 pm – 3:15 pm | Moscone West—3010

Abstract:  Nelson Calero Database ConsultantOracle ACE The LAOUC is the Latin America user group community that has an affiliated group of about 1,000 professionals. It is a self-governing community of Oracle users who volunteer to achieve common goals and objectives connected with Oracle technology. The group’s purpose is to promote membership involvement, education, and influence. Come to this session to learn more.


Deiby Gómez

Session 1 – Oracle Database New Features 

Date/Time: Sunday, Oct 25, 11:00 a.m. | Moscone West—3011

Abstract: Oracle Database was released more than one year ago; however, a lot of new features are not well known by the community yet. In this session, learn what you have to know for each new feature in order to understand how they work. This session goes deep to give you enough information to go home talking about Oracle Database and feel prepared to welcome the new versions of Oracle Database with your new knowledge.



Discover more about our expertise in the world of Oracle.

Categories: DBA Blogs

Log Buffer #443: A Carnival of the Vanities for DBAs

Pythian Group - Fri, 2015-10-02 10:45

This Log Buffer Edition finds and publishes blog posts from Oracle, SQL Server and MySQL.


  • SCRIPT execution errors when creating a DBaaS instance with local and cloud backups.
  • Designing Surrogate vs Natural Keys with Oracle SQL Developer.
  • EBS General Ledger – Accounting Hub Reporting Cloud Service.
  • Oracle Database Standard Edition 2 is available.
  • Disable “Build After Save at JDeveloper” 12c.

SQL Server:

  • Learn where to get the latest installation and learning resources for the ever-evolving components of the Hadoop ecosystem and how those components may complement Microsoft SQL Server common everyday tasks.
  • Creating Dashboards for Mobile Devices with Datazen.
  • Install SQL Server Management Studio with Web Installer without Internet Access.
  • Using wildcard to find patterns in strings going from the basics to some more complicated conditions.
  • A general way to maintain History tables.


  • Capture database traffic using the Performance Schema.
  • Become a MySQL DBA blog series – Database Indexing.
  • Prepping your MySQL indexes for a character set change.
  • HowTo: Retrieve Direct Messages From Twitter and Store Them in MySQL.
  • Using Docker to Visualize MySQL Performance Schema.


Learn more about Pythian’s expertise in Oracle SQL Server & MySQL.

Categories: DBA Blogs

My Sales Journey: #5

Pythian Group - Thu, 2015-10-01 13:49

I am a little sad to let go of the Life of a newly minted Sales Professional title today but happy that I am starting to develop a bit of a patina. My Sales Journey reflects my state of mind right now and feels more appropriate given the fact that today marks the end of my first month at Pythian!

Last week we explored social media and where people are building their online habitats. Today, lets journey inside the minds of these people to see what they think. Let me explain.

As a sales professional for a managed service I talk to decision makers and stakeholders. My job is to engage them and hopefully they will want to take the conversation one step further. For all this to happen I need to know what their responsibilities, their pain points and their challenges are.

So today lets step inside the mind of a VP/Director/Executive:

They are responsible for ensuring the continual functioning of mission critical operations. They have to stay relevant while bridging the gap between business and technology. They are in charge of driving innovation and improving profitability. They are also tasked with delivering flexible strategies that enable business to deliver high quality/valuable services.

Now that I know this on a broad level I can be more effective with my message. This week has been all about creating/assembling content that answers to these challenges and responsibilities. These can come in the form of white papers, relevant marketing, team resumes, cost analysis and slide decks.

Know their industry and purchasing cycles. This is a research heavy task but pays off when you have a carefully curated list that you can refer to. It becomes a powerful weapon in your sales arsenal.

Sleuth enough information to determine initial feasibility. Your first contact is twice as likely to be successful if you have qualified the type of messaging with their current challenge.

As you can tell, lots of learning happened in the last week. I hope some of these tips will help you with your outreach. Stay tuned next week when we step in to the mind of a manager who may be lower on the rung but can be a key person to land your message in front of the decision makers.

Now, It is Friday and time to kick back and relax with a team lunch! My second one in 4 weeks! Yessirrrr, that is how we roll at Pythian. See you next week!


Categories: DBA Blogs

Oracle Database Standard Edition 2 is available

Oracle Database Standard Edition 2 was announced earlier this year in a MOS note (2027072.1) and it is now available for download and purchase. Oracle Database Standard Edition 2 is an...

We share our skills to maximize your revenue!
Categories: DBA Blogs

SQL On The Edge #3 – Azure Elastic Database Jobs

Pythian Group - Wed, 2015-09-30 10:15

Hello and welcome to episode number three of SQL On the Edge! In this episode we’re going to cover Azure SQL elastic database jobs. In the last few months, Microsoft has put a lot of effort in augmenting the elastic capabilities of the Azure SQL database service. We’re not only talking about the ability to scale UP but in this case about the capability to scale OUT.

The investments made on this front have produced:

– Elastic database tools for easier .NET development against multiple Azure SQL databases.
– Elastic database pools for better resource management.
– Elastic database jobs for easier job execution against groups of databases.
– Elastic database query for easier integrated querying of groups of databases.

Elastic database jobs are interesting because for a long time there wasn’t a native way to run jobs against Azure SQL databases. The solution we used with many of our clients was to have either a SQL Server on a VM to use the SQL Agent scheduling capabilities or using the Windows scheduler from a Windows Server VM or using the Azure job scheduler. These options, while serviceable were not really optimal for the task.

Elastic database jobs provide capabilities that cover the gaps we had before:

– You can run a job against an entire database pool, a pre-defined shard set or a custom database list.
– Job execution is logged and history can be retrieved per database.
– Information can be collected and stored from the results of each job execution.

For now, elastic database jobs are provided as a customer hosted web solution and an accompanying SQL database. At the moment, Powershell is also required to access the full functionality as the Portal only exposes a small part of it.

Let’s go over the feature and the demo in the video, enjoy!


Discover more about our expertise in SQL Server.

Categories: DBA Blogs