Archive

Archive for September, 2014

Where the real technical talks are at OOW

September 26th, 2014
No comments

What are the real technical talks at OOW amid all the marketing fluff? I don’t know all of them but I can vouch for the following

 

time id speaker room title
Sunday 9:00 UGF2563 Jeremiah Wilton, Marc Fielding M South 309 24/7 Availability with Oracle Database Application Continuity
9:00 UGF4378 Gwen Shapira M South 308 Analyzing Twitter Data with Hadoop – Live Demo
10:00 UGF3587 Tim Gorman M South 301 Scaling To Infinity: Partitioning DW on Oracle Database
11:00 UGF3147 Chris Antognini M South 304 Adaptive Query Optimization
2:30 UGF8949 12 speakers… M South 304 12 Looks at Oracle Database 12c: EOUC Short Talks
UGF8949 pt. 1 Jonathan Lewis M South 304 Ugrading to 12c – What will go wrong?
2:30 UGF2244 Connor McDonald M South 303 12c features for Developers
2:30 UGF3475 Martin Bach, Frits Hoogland M South 310 Think Exa!
3:30 UGF4042 Kyle Hailey M south 301 DevOps, Databases, and the Phoenix Project
3:30 UGF6626 Kerry,Tanel,etc M South 310 Expert Oracle Exadata: Then and Now – Panel
Monday 8 Mogens Noergaard Oaktable World Welcome
9 Riyaj Shamsudeen: in-memory internals Oaktable World in-memory internals
1 Chris Antognini Indexes: Structure, Splits and Free Space Management Internals Oaktable World Indexes: Structure, Splits and Free Space Management Internals
11 Martin Bach A deep dive into HCC internals and mechanics Oaktable World A deep dive into HCC internals and mechanics
12 CMillsap, EGrancher, JLewis, JGennick Oaktable World Ted Talks
1 Jonathan Lewis Oaktable World Calculating Selectivity
2 Greg Rahn The Current State of SQL + Hadoop Oaktable World The Current State of SQL + Hadoop
3 Kevin Closson SLOB – For More Than I/O! Oaktable World SLOB – For More Than I/O!
4 Toons Oaktable World Why DBMS’s Still Lack SQL Assertions Support (A polite excuse)
Tuesday 8 Carlos Sierra Oaktable World introducing edb360 tool
9 Kent Graziano Worst Practices in DW Design Oaktable World Worst Practices in DW Design
1 Tanel Poder Hacking Oracle 12c Oaktable World Hacking Oracle 12c
11 Jeremiah Wilton Oaktable World Oracle on EC2: You’re doing it wrong
12 KOsborne, AGorbachev, JLewis, JHarris, Oaktable World Ted Talks
1 Connor McDonald Oaktable World clone db
2 Frits Hoogland Oaktable World Profiling the logwriter and database writer (with version 12.1.0.2 update)
3 Alex Gorbachev Oaktable World Anomaly detection on performance data
4 Karl Arao Capacity Planning: SLAs, KPIs, Headroom, Expiry Date Oaktable World Capacity Planning: SLAs, KPIs, Headroom, Expiry Date
Wednesday 1:45 CON8134 Kellyn Pot’Vin M South 303 Zero to Manageability with EM12c
4.45 CON7726 Kellyn Pot’Vin M South 104 Oracle Exadata Database Machine Administration and Monitoring Made Easy
4:45 CON5773 Eric Grancher M South 306 Database Storage 101 Planning and Monitoring: Performance and Reliability
4:45 CON5915 Jonathan Lewis M South 102 Reading an AWR Report
Thursday 10:45 CON6812 Tanel,Kerry M South 104 Oracle Database In-Memory in Action
12:00 CON10038 Jeremiah Wilton, others M South 301 Customer Panel: Private Cloud Consolidation, Standardization & Automation
1:15 CON3671 Kyle Hailey M north 130 Lies, Damned Lies, and I/O Statistics
2:30 CON4053 Kyle Hailey M north 130 ASHmasters
2:30 CON4039 John Jay King Marriott Marquis Nob Hill C/D Gauging Oracle ADF Application Performance: Instrumenting Your Oracle ADF Code

another good link for talks at OOW14 http://rene-ace.com/2014/09/oow14-what-to-do-and-what-to-see-at-open-world-2014

business vision

Uncategorized

Oaktable World & Delphix Labs on Mon & Tues

September 25th, 2014
1 comment

Next week during Oracle Open World, be sure and come on Monday and Tuesday to the free Oaktable World and  on Tuesday to Delphix hands on lab and free 90 day trial version at #CloneAttack at the same venue as Oaktable World.   The labs will also be joined by DBvisit for #RepAttack and Solarwinds (Confio) for #MonitorAttack.

 

Screen Shot 2014-09-12 at 12.38.32 PM

Screen Shot 2014-09-25 at 8.30.39 AM

Beer, Meat, Explode

 

Screen Shot 2014-09-15 at 10.57.34 AM

 

Screen Shot 2014-09-15 at 10.57.41 AM

Screen Shot 2014-09-22 at 7.18.15 AM

 

 

Uncategorized

Oracle Open World schedule

September 24th, 2014
No comments

Here is my schedule of presentations at Open World this coming week.

I most excited about my talk on Sunday. The Phoenix Project is a awesome book everyone should read, DevOps is the rising star of IT and this talk will empower DBAs to take their careers to the next level with data virtualization – virtualize, govern and deliver data efficiently boosting your companies efficiencies and bottom line much greater than any other change one could make as a DBA.

21-11-06-664_950x510

Uncategorized

Delphix trial version available for first time : #CloneAttack

September 23rd, 2014
2 comments

Screen Shot 2014-09-24 at 9.41.34 AM

 

Update:

Delphix is now hosting a community board for the hands on lab called Landshark

——

At Oracle Open World we will be leading hands on labs to install a fully operation Delphix environment on your laptop.

The labs will be hosted at the Creativity Museum, the same location as Oaktable World on Tuesday Sept 30 from 10am to 5pm. Solarwinds Confio and DBvisit will also beholding #MonitorAttack and #RepAttack in the same location.

The labs for Delphix will be led by

We will provide automated install scripts along with 3 OVA files for the following VMs:

  • Linux Source (CentOS 6.5) 1.8 GB OVA file,   19GB installed 
    • Oracle 11G R2 datafiles
  • Linux Target (CentOS 6.5) 1.2 GB OVA file, 4GB installed
  • Delphix 4.1.2  , 3.1 GB OVA file, 10GB installed
    • Oracle timeflow of a  Linux Employee WebDB
    • Application timeflow of a Linux Employee WebApp

These VMs require each 2GB memory and 1vCPU

Prerequisites

Steps

To get up and running you will need to have VMware fusion for Mac or VMware Workstation for Windows. We will provide these files if you need them and installation is a double click. You should bring the Oracle 11gR1 (11.2.0.1) install zips. With these zips, our install will automatically install Oracle on the Target and Source machine, and start up a database on the source machine. From there you can make virtual databases in minutes from the source, do rollback, refresh etc of virtual databases. The install will come on a USB stick and from there all you have to do is

  1. Import the OVAs into VMWare (right click on OVA, chose open with VMware Fusion)
  2. Note IP Address on the boot screen of each VM (via Console)
  3. Download the Oracle 11.2.0.1 install for “Linux x86-64″
  4. execute (from directory with Oracle install zip files)
    • On MAC  lsde_install_mac_v1.2.sh
    • On PC lsde_install_v1.2.sh
    • On Linux lsde_install_v1.2.sh
  5. Login to the Delphix Admin portal
  6. Go to Manage->Environments
  7. Choose the appropriate environment and then change the Host Address to the IP address from step 4
  8. Refresh Environment

Once installed we will have a set of exercises that will show you some of the power of virtualized data.

Reference

9009_03

 

Here is a video showing the lab setup. A later video will show some exercises we can do with the lab setup.

Here is a video of an exercise to do on the lab VMs after install

 

Uncategorized

Jonathan Lewis explains Delphix internals

September 22nd, 2014
No comments

Last week we had a great webinar with Jonathan Lewis as he explained his hands on experience of Delphix, how Delphix works internally and some use cases that Delphix solves for Jonathan.

Jonathan will be joining us a the Delphix booth at Oracle Open World and giving shorter version of the presentation at 10am on Monday and Tuesday and 11am on Wednesday.

Also Jonathan will be speaking at Oaktable World on Monday 1pm and both Monday and Tuesday for Ted Talks at Oaktable World between noon and 1pm.

If you are interested in trying Delphix out, we will be hosting a hands on labs for the first time ever to install Delphix trial copies on your laptops. We will be in the OTN lounge on Monday between 3:30 and 5pm and Tuesday between 10am and  5pm at Oaktable World Labs.

Below are Jonathan’s slides and recording of the webinar:

 


Screen Shot 2014-09-22 at 7.18.15 AM

Uncategorized

Oracle Open World: Oaktable speakers at Delphix booth

September 19th, 2014
1 comment

Screen Shot 2014-09-19 at 2.16.51 PM


Planning to attend Oracle OpenWorld this year? 

If so, stop by to visit Delphix at booth 821 and hear from Oracle industry luminaries such as Jonathan Lewis, Tim Gorman, Kyle Hailey, Ben Prusinski and the Oracle Alchemist, Steve Karam.

  • Taking Back Your Time: The Power of Virtual Databases, Jonathan Lewis
  • Virtual Data Platform: Revolutionizing Database Cloning, Kyle Hailey
  • Virtual Data for the High Performance Warehouse, Steve Karam
  • Transforming IT Infrastructure, Tim Gorman
  • Oracle E-Business Suite Updates with Delphix, Ben Prusinski

Join your peers at #CloneAttack #RepAttack and receive a free 30-day trial version of Delphix and Dbvisit Replicate.

DATE:  Monday, September 29
TIME:  3:30-5:00 PM
LOCATION:  OTN Lounge

If you are unable to make it to the OTN Lounge, visit the Children’s Creativity Museum (upstairs from Moscone South) anytime on Tuesday, September 30 to get your demo kit and start running your own private Delphix environment.

Visit Delphix in booth 821 to view a demo of their Virtual Data Platform or to meet the team! 

 

Oracle Open World 2014

 

Delphix Booth Speaking Schedule

 

Monday, September 29, 2014
10:00 Jonathan Lewis Taking Back Your Time: The Power of Virtual Databases
11:00 Steve Karam Virtual Data for the High Performance Warehouse
1:00 Tim Gorman Transforming IT Infrastructure
2:00 Hubert Sun Agile Data + Agile Masking
3:00 Rick Caccia Delphix for Copy Data Management
4:00 Ben Prusinski Oracle E-Business Suite Upgrades with Delphix
Tuesday, September 30, 2014
10:00 Jonathan Lewis Taking Back Your Time: The Power of Virtual Databases
11:00 Ben Prusinski Oracle E-Business Suite Upgrades with Delphix
1:00 Tim Gorman Transforming IT Infrastructure
2:00 Hubert Sun Agile Data + Agile Masking
3:00 Charles Moore Public Clouds – How to Eliminate Security Risks and Decrease Costs
4:00 Steve Karam Everybody Gets a VDB – Including DBAs
Wednesday, October 1, 2014
10:00 Tim Gorman Transforming IT Infrastructure
11:00 Ben Prusinski Oracle E-Business Suite Upgrades with Delphix
1:00 Steve Karam Virtual Data for the High Performance Warehouse
2:00 Hubert Sun Agile Data + Agile Masking
3:00 Kyle Hailey Virtual Data Platform: Revolutionizing Database Cloning
4:00 Ansh Patnik Multiple Oracle EBS Environments with the Power of Delphix Technology

Uncategorized

Jonathan Lewis explains Delphix live Sept 18th

September 15th, 2014
3 comments

Join myself and Tim Gorman as we host a live webinar  and Q&A September 18th at 10am PST  with Jonathan Lewis. Jonathan will explain from his on experiences how Delphix works and what industry problems it solves.

Click here to register for our webinar.

Screen Shot 2014-05-21 at 8.08.47 AM

Screen Shot 2014-05-21 at 8.08.47 AM
Screen Shot 2014-05-21 at 8.08.47 AM
See Jonathan’s blog post on this up coming webinar
Screen Shot 2014-05-21 at 8.08.47 AM

Jonathan explains issues and obstacles to creating “thin clones” on typical industry hardware:

Screen Shot 2013-07-15 at 10.13.05 PM

how point in time snapshots work
Screen Shot 2013-07-15 at 10.12.07 PM

And from point in time snapshots, he explains how clones can rapidly be made.

Screen Shot 2013-07-15 at 10.12.37 PM

Related blog posts by Jonathan’s blog

Uncategorized

Good Blogs to follow

September 12th, 2014
No comments

Good blogs keep popping up and other blogs fade into the back ground, so it’s hard to keep track of the good stuff out there. The following is a list of blogs I have either in the past gotten a lot out of or currently do. It would be great to get comments on what the best current blogs are and then iterate on this list and keep it updated.

There use to be a cool blog aggregator site called “collected.info” where I had aggregated a bunch of blogs but that site no longer seems to work and I’ve lost the list I built up there. There must be some new blog aggregator sites out there. Welcome suggestions.

The  Oaktable aggregates the blogs of its members, many list below, on it’s site oaktable.net.

 

Oracle Blogs

SQL Server world

DevOps

Visualization

Uncategorized

5 secrets 10% of Fortune 500 use to double application development output

September 3rd, 2014
No comments

This article liberally uses sections from The Threat That Lies Within  by Yaniv Yehuda

Databases receive much attention so they will not become THE risk factor of IT. Budgeting DRPs, backups, top of the line DBAs – and yet, they still pose a major threat. Why?

Agile Development

In a fast-moving competitive market, if your competitor delivers relevant products, faster and with better quality, you’re eventually going to lose market share. This is exactly why companies need to be agile.  They need to have better control over information, make quicker decisions, accelerate software delivery, and optimize quality control.

To answer revenue driving business questions companies are constantly improving applications and creating new applications. Application development depends upon provisioning environments for developers and QA. Once developers and QA teams are up and running on it these environments, code development requires means of managing the changes and the deployment of the changes.  The slower and more costly provisioning and managing the development environments the more delays, bugs there will be in the applications and the less revenue businesses will generate.

The Database Bottleneck

One of the slowest, most difficult and costliest steps in application development is provisioning copies of and managing changes in databases for development and QA.

Code management has become straight forward with the use of source control tools such as Git, SVN and Perforce. Provisioning development environments has become efficient with Chef, Puppet and Jenkins.

But what about the database? How does one provision environments with multi-terrabyte databases and version control these databases as changes are made by multiple different developers and as multiple versions of code and database states need to be maintained? For all the advances in application development such as machine virtualization, agile development and DevOps practices, the database still stands as a huge barrier to development agility.

Database branching, development, merges and deployments are tricky; unlike code, a database is not a collection of files. Following best practices using proven file based tools often fails when dealing with the database – the container of our most valued asset – the business data. Too often the database is left behind and becomes the weakest link in the chain.

The difference between database development and application code development is so great, that in time, silos were created.

While application developers are moving forward, adopting great new tools and practicing Agile, automation, and continuous delivery, database development is done using a less controlled process. More craft than engineering, database development is often disconnected from the entire SDLC process. Tools, processes, and best practices are not shared.

The database, being such a valued asset, can very easily become that wobbly wheel that destabilizes the whole car.

Database Agility: Key to Fast Development

Databases can be managed just as efficiently as code.

In order to minimize the risks databases pose during the development cycle, the following should be addressed:

  1. Agile  – implement database changes as part of shorty cycle task-based development. Deploy code changes and database changes  hand-in-hand  based on change requests. To accomplish use tools such as Jira
  2. Virtual –  Virtualize your  application stack and databases. Data virtualization can be accomplished with Delphix.  Virtualized data and databases can be created in minutes no matter the size, can be branched and can be made via a self service interface or with by automated systems using APIs. A virtualized copy of a production environment will allow you to test production deployments, true to production’s latest data, and allow data to be developed and tested in parallel with with multiple environments. With this change, companies have doubled their application development output. Delphix also includes data masking in their solution to insure that each virtual database to insure data security.
  3. Change Management – Implement database tools to make sure database changes are properly managed as part of SDLC .  By using DBmaestro to enforce version control and track and merge all changes, you’ll always have full control over who is doing what, where, and why.  Once a development cycle has concluded, relevant changes can be automatically deployed into integration environments, identifying change conflicts and merging them, or pushing them to production.
  4. Testing automation –  Follow change-focused testing and make sure nothing breaks as a result of changes will provide a solid safety net.  Running unit tests with Oracle SQL Developer or Microsoft-focused tSQLt is a cost-free way to introduce unit testing for the database. Yet another way to test your database along with the application code, as one unit by using TestComplete to validate your common –  and later less-common – scenarios will provide great confidence in your ability to deliver releases .
  5. Release Automation – The more you automate, the more accurately you can reproduce the changes introduced in development, test in testing environments, and repeat safely when going to production. A healthy SDLC with minimum risk and maximum efficiency can be achieved once you automate its processes and address its challenges on daily basis.  Using IBM Urbancode Deploy can help manage your release activities and your configurations, and orchestrate the overall process.

Best of all,  these types of solutions play very nicely with each other. So creating a virtual development branch with Delphix and masking its confidential content, managing development tasks with Jira, version controlling changes and packaging a release with DBmaestro, automatically testing this release with tSQLt or SQL Developer, and orchestrating the release process with uDeploy can all be combined into one slick, automated, and safe process.

Summary

The database presents a real challenge when it comes to following best practices. This is exactly how silos are created. A development department might follow different processes when dealing with code development vs. database development, or follow best practices for only some of its change efforts.

The best way to eliminate major risks and bottlenecks is to virtualize and automate and using the above virtualization and automation tools companies have doubled their application development output while at the same time eliminating bugs and increasing quality.

 

Businesspeople Running Towards Finish Line

 

 

Uncategorized