Meetup with Monty Widenius (MySQL/MariaDB founder)
Filed under: Uncategorized
Join us for a Fireside Chat with Monty Widenius, MySQL and MariaDB founder
One of the most important developers in Open Source will be in Colorado this month and is joining us for an evening to discuss the latest trends in databases and open source development.
Please join us for an in-depth conversation with Monty Widenius, a leader in open source development for more than 20 years, and a founder of open source projects MySQL and MariaDB. This is an exciting chance to engage with a living legend in software development. Don’t miss this opportunity!
Monday, November 14
Innovation Lounge, Commons on Champa, 1245 Champa St, Denver CO (map)
- 6:30 p.m. – Networking, snacks, drinks
- 7:00 p.m. – Fireside chat with Monty
More details and RSVP at the Colorado MySQL Meetup event page.
FollowSummer 2016 Quarterly Educational Workshop
Filed under: Uncategorized
|
|
|
|
|
|
|
|
Summer 2016 QEW Presentations:
8:45am – 9:45am “Analyze This! Practical Examples of Oracle Analytical Functions”
– Jim Czuprynski, Onx Enterprise Solutions
Session Abstract: If you’ve ever struggled with a particularly complex reporting request from an applications developer – for instance, returning just a specific set of rows from a subset of rows already extracted, or creating the equivalent of a Microsoft Excel pivot table, or producing a report with subtotals and subsections just like a spreadsheet – then this session is just right for you. We’ll demonstrate the basics of how to produce these complex output matrices with just a few calls to Oracle 12cR1 analytic functions and discuss how you applications developers (as well as Oracle DBAs) can leverage them for deeper insights into your database, and the performance of its application workloads. The presentation will offer real-world examples of how best to deploy these features, including detailed sample code that you can put to immediate use.
Objective #1: The attendee will understand how to leverage 12c Database’s analytic functions to create complex reports with less tortuous SQL, thereby potentially improving statement performance.
Objective #2: The attendee will discover how to apply analytic functions to obtain new viewpoints from the data hidden within the data, using everything from Big Data to database performance metrics as a target.
Click here to access the presentation.
9:50am – 10:50am – “Migrating and Upgrading to Oracle Database 12c Quickly With Near-Zero Downtime”
– Jim Czuprynski, Onx Enterprise Solutions
Session Abstract: While many IT organizations appear to still be waiting for Oracle Database 12c Release 2 (12cR2) to migrate their pre-12c databases to the next version, it’s never too early to begin planning the best way to make that transition a reality. This session will therefore demonstrate real-world examples of how to use the latest database migration and upgrade techniques to quickly and safely move your pre-12c Oracle databases to Oracle 12cR1 … with some hints on even easier methods that are likely to be available in Oracle 12cR2.
Objective #1: The attendee will understand how to plan for an effective migration for pre-12c databases to a 12c database environment with minimum appropriate application down time – the “window of inopportunity” -while guaranteeing against the loss of any data during the migration process.
Objective #2: The attendee will be able to choose which migration mechanism – RMAN+TTS, XTTS, or CPT – is the best choice for migration her pre-12c database to Oracle Database 12c, and how to leverage each migration technique for an effective, safe migration regardless of differences between source and destination platform, database version, or OS.
Click here to access the presentation.
Jim Czuprynski – Strategic Solutions Architect, OnX Enterprise Solutions
Jim Czuprynski has over 30 years of professional experience in his career in information technology, serving diverse roles at several Fortune 1000 companies in those three before becoming an Oracle DBA in 2001. He was awarded the status of Oracle ACE Director in March 2014 and is a sought-after public speaker on Oracle Database technology features, presenting topics at Oracle OpenWorld, IOUG’s COLLABORATE, Hotsos Symposium, Oracle Technology Network ACE Tours, and Oracle User Group conferences around the world. As of August 2015 Jim has joined OnX Enterprise Solutions as their Strategic Solutions Architect focusing on Oracle Database technology, especially Oracle Database 12c as well as Oracle’s Enterprise Systems, especially Exadata, SPARC Supercluster, and Oracle Database Appliance, and ZS3/4. Jim has authored over 100 articles focused on facets of Oracle Database administration to his credit since 2003 at databasejournal.com and ioug.org. Jim’s blog, Generally … It Depends (http://jimczuprynski.wordpress.com), contains his regular observations on all things Oracle. His first book, Oracle Database Upgrade, Migration and Transformation Tips & Techniques, was published in June 2015 through Oracle Press.
10:55am – 11:55am “Is Oracle 12c Making You Wait? Discover How to Identify, Prioritize and Solve the Most Important Wait Events” – Janis Griffin, SolarWinds
Session Abstract: There are over 1200 wait events in Oracle 12c, but there are only 10 (in my experience) that are seen often. If you can learn these 10 wait events, what causes them and their solutions, you will be ahead of the performance analysis game. The list of 10 wait events to be discussed came from over 100 consulting engagements with customers, so come find out what they are and improve your performance troubleshooting skills.
Objective 1: Learn the top 10 wait events
Objective 2: What are the causes of these events
Objective 3: How do you fix these waits
Click here to access the presentation.
12:00am – 1:00pm – “Oracle’s Adaptive Optimizer, Finally Learning from Its Mistakes!”
– Janis Griffin, SolarWinds
Session Abstract: With each new release of Oracle, the optimizer undergoes changes usually for the better, but sometimes there are unexpected side effects as well. This presentation will explore all of the new optimizer features, adaptive plans/statistics, and the changes to SQL plan management. Several case studies will show how it works, so you can quickly take advantage of the changes while making sure you remain stable in the transition.
Does your performance tuning need a 12-step program?
Performance tuning can be complex. It’s often hard to know which knob to turn or button to press to get the biggest performance boost. In this presentation, Janis Griffin, database performance evangelist, SolarWinds, will detail 12 steps to quickly identify performance issues and resolve them. Attendees at this session will learn how to:
- Quickly fine tune a SQL statement
- Identify performance inhibitors to help avoid future performance issues
- Recognize and understand how new Oracle features can change and/or support different execution plans
Click here to access the presentation.
Janis Griffin – Database Performance Evangelist / Sr. DBA, SolarWinds
Janis Griffin has over 25 years of Oracle DBA experience including design, development and implementation of many critical database applications. Before coming to SolarWinds, Janis held DBA positions primarily in the Telecom / Network Industries, working with both real-time network routing databases and OLTP business to business applications. As an Oracle ACE, Janis has mentored other DBAs on best practices in database performance tuning. As a highly successful liaison between management and technical staff, Janis has proven to be an effective collaborator implementing cutting-edge Oracle solutions.
Watch for Email from SurveyMonkey Containing Your Online Ballot to Vote for the 2016-2017 Board of Directors!
Filed under: Uncategorized
If you haven’t received the email already, then please check your “junk” folder, otherwise contact us ASAP? Deadline for voting is Friday 06-May 2016 at 08:30am MDT.
-
Volunteer for RMOUG!
-
RMOUG Membership
Connect with RMOUG
-
Contact RMOUG
- Rocky Mountain Oracle
Users Group (RMOUG)
P.O. Box 10142
Scottsdale, AZ 85271-0142
peggy.king@rmoug.org
Training Days 2018
