Catch 12cR1 RAT By the Tail, and Learn More About Security Risks

IOUG_LogoOnce again,  I’m honored and excited to have an article in IOUG SELECT Journal’s 3rd Quarter 2016 edition. This time, I’m delving deeply into the latest features of Oracle 12cR1 Real Application Testing in the first part of a two-part series entitled Regression Analyzed, Tout de Suite: Leveraging Oracle 12c Database Real Application Testing (RAT) Suite. I’ve recently leveraged that tool to experiment with multiple scenarios for evaluating Oracle Database 12.1.0.2’s Database In-Memory Features … which I’ll explain in the second part of the series, of course! If you don’t have an IOUG membership, you can still browse a copy of my article in PDF format … but seriously, shouldn’t you have membership in one of the best Oracle User Groups in North America?

I also enjoyed interviewing my able colleague Der’ly Guiterrez from OnX Enterprise Solutions for his article entitled The Wolf Is Always at the (Hospital) Door: Reducing Information Security Risks for Health Care Organizations.  Der’ly’s role as OnX’s Security Practice lead gave us a chance to explore some of the typical challenges that security breaches of IT organizations can cause, especially when that organization is responsible for sensitive PHI or PCI data.

 

Don’t Miss My 9-28 Webinar on New Features of Oracle Database 12.2.0.1

onx-black-200I’m especially excited to tell everyone about my upcoming webinar – the fifth in this year’s bimonthly webinar series on all things Oracle Database 12c – on Wednesday, September 28, 2016 at 1:00 PM CST (2 PM EST, 11 AM PST) – because my brain will be near to exploding after nearly eight days of intense immersion into the world of Oracle at Oracle OpenWorld 2016.

This time, I’ll be looking at the most significant features of the very latest Oracle Database Release (12.2.0.1). We’ll look at 12cR2’s significant upgrades to Database In-Memory, Sharded Databases and Big Data, and – most impressively – Pluggable Database 2.0, including the ability to migrate PDBs between different CDBs without incurring any downtime.

I’m also adding something new into the mix: real-time polling to find out what features are most interesting to all of you attending, so that you can find out what our fellow Oracle DBAs and application developers are the most compelling features!

As always, registration is free but it’s filling up especially quickly for this webinar. Our July 29th webinar had 500 open slots, and we ran out of openings days before, so this time I’ve asked OnX to offer a few hundred more slots. I look forward to hearing your feedback after you attend!

Let Me Help You Find Your Oracle Roots: POUG, 7-8 October, Warsaw, Poland

POUG_LogoAt the invitation of Kamil Stawiarski, my good friend and fellow Oracle ACE, I am thrilled to announce that I’ll be returning to the country of my grandparents to speak at the Polish Oracle Users Group (POUG)’s  1st International Oracle Conference in Warsaw, Poland on 7-8 October.

I noticed that my POUG colleagues have already created an avatar that reflects my passion about All Things Oracle. I’ll be presenting two of my favorite topics:

DBA, Heal Thyself: Five Diseases of IT Organizations and How to Cure Them

I’ll spend some time discussing my viewpoints on the state of IT today, how the role of Oracle DBA has changed over the past 15 years, and how those roles need to evolve as well, especially when using Oracle 12c.

Analyze This! Practical Examples of Oracle Analytical Functions

We’ll look at some neat tricks that leverage lesser-known 12c Database analytical functions to quickly answer difficult queries with only minimal coding, including some slick techniques to analyze unseen patterns in data.

Even more exciting: As far as I know, I am the first of the branch of the Czuprynski extended family in America to reach out to my (presumed) cousins in Poland. Indeed, I may be the very first to return there since my grandfather, Jozef, left there in the early 1890s to seek his fortune in Chicago, Illinois.

After several years of fruitless searching for my family’s roots, I located Jakub Czuprynski, who it turns out is my second cousin – and he should know, because he’s a professional genealogist. I’m hoping to meet my long-lost family in Poland and find out more about their trials and tribulations since my grandfather’s emigration over 125 years ago.

To paraphrase Alex Hailey: “I have found you, Jozef Czuprynski! At last I have found you.”

8/23/16 Forecast, Southern Florida: Hot. Sunny. Oracle 12c!

SOUG._LogoMy colleague and fellow Oracle ACE, Troy Ligon, has graciously asked me to share my knowledge of Oracle Database 12c with members of the SunCoast Oracle Users Group (SOUG) on August 23rd in St. Petersburg, Florida. Registration is now open for this event, so feel free to sign up. I’ll be presenting two of my most requested Oracle Database 12c topics:

Analyze This! Practical Examples of Oracle Analytical Functions

I’ll show you some powerful techniques to leverage some of the lesser-known 12c Database analytical functions to quickly answer difficult queries with a lot less coding, including some neat code examples and techniques to analyze unseen patterns in data.

Migrating and Upgrading to Oracle Database 12c Quickly with Near-Zero Downtime

Many IT shops are waiting for 12c Release 2 to complete their migration from earlier releases. But whether you’re migrating just your current data to Oracle Database 12c or trying to figure out how to best upgrade an existing pre-12c database, I’ve found it’s really helpful to know all of your options. I’ll be discussing the obvious as well as lesser-known techniques to migrate and databases – either in whole, or just chunks at  a time! – quickly, effectively, and with confidence.

And since my employer, OnX Enterprise Solutions, is sponsoring this event, you can be sure there will be some great “swag” and probably even a few signed copies of my recent books on Oracle Database Administration as raffle prizes. Looking forward to seeing you all there, my Floridian colleagues!

OOW16: Migrate to 12c Faster, and Leverage PDB 2.0

OOW2015_LogoI’m honored to be asked to present at IOUG’s “SunDay of Training” at Oracle OpenWorld 2016. This marks my fourth consecutive year participating in this event, and I’m going to make sure this year’s presentation is an excellent one. I’ll be reprising one of my best-attended presentations from COLLABORATE16, Migrating and Upgrading to Oracle Database 12c Quickly with Near-Zero Downtime (UGF6541). It’s currently scheduled for 08:00 AM on Sunday, September 18th, so bring your coffee and come along for an exciting early-morning ride!

A little later in the week, I’ll be joining a veritable cornucopia of of Oracle ACEs and ACE Directors – my esteemed colleagues Kai Yu, Andy Colvin, Deiby Gomez, and Anuj Mohan – for a deeper dive into the latest features of Pluggable Databases (PDBs) in the upcoming release of Oracle Database 12c. Our topic, Leveraging Oracle Database 12c Release 2 Multitenant Features (CON3075), will focus on how to clone PDBs faster than ever, limit PDBs to specific SGA and PGA targets, apply resource and I/O limits to PDBs, leverage new ADO and Heat Map features, and much, much more. This session is currently scheduled for Thursday, September 22nd at 12:00 PM noon – a bit later in the week, but a great way to close off your learning at OOW16.

So be sure to check out the session catalog for these presentations, as you are guaranteed to come away with a plethora of new ideas on how best to leverage Oracle 12cR2 features for your databases, your community, and your career. I’m looking forward to seeing you all there!

My Kind of Town: Chicago! Join Me for MOUG’s 2016 Conference on August 12th

MOUG_LogoI’m excited to be presenting at the Midwest Oracle User Group’s (MOUG) 2016 Conference this coming August 12, 2016. This marks the very first time that my schedule has aligned with MOUG’s premier technical event. And I’m especially humbled to be invited by one of my personal heroes in the world of Oracle: Chicago’s very first Oracle ACE Director, the renowned Rich Niemiec. Rich always draws a crowd whenever he speaks because of his deep IT industry expertise as well as his unique perspective on the future of computing.

I’m honored to be a part of an effort to expand the Oracle Database knowledge of everyone in attendance. The meeting fee is just $50. My two topics focus on Oracle Database 12c:

Analyze This! Practical Examples of Oracle Analytical Functions

I’ll discuss some of the hidden gems of 12c Database analytical functions and features that make short work of answering difficult queries, including some neat code examples and techniques to analyze unseen patterns in data.

Migrating and Upgrading to Oracle Database 12c Quickly with Near-Zero Downtime

Whether you’re migrating data to Oracle Database 12c or deciding how to best upgrade an existing pre-12c database to 12cR1, it’s important to know all of your options. Join me as I discuss some of the obvious as well as lesser-known techniques to migrate and databases – either in whole, or just chunks at  a time! – quickly, effectively, and with confidence.

 

Finding Dory in Denver on July 29th: RMOUG Summer QEW

RMOUGIf you’re in the Denver, Colorado area on Friday, July 29th, be sure to join me at the downtown Denver Aquarium for the Rocky Mountain Oracle User Group (RMOUG) Summer Quarterly Educational Workshop (QEW). OnX Enterprise Solutions will be sponsoring the event’s morning session, and I’ll be presenting two Oracle Database 12c topics:

Analyze This! Practical Examples of Oracle Analytical Functions

I’ll discuss some of the hidden gems of 12c Database analytical functions and features that make short work of answering difficult queries, including some neat code examples and techniques to analyze unseen patterns in data.

Migrating and Upgrading to Oracle Database 12c Quickly with Near-Zero Downtime

Whether you’re migrating data to Oracle Database 12c or deciding how to best upgrade an existing pre-12c database to 12cR1, it’s important to know all of your options. Join me as I discuss some of the obvious as well as lesser-known techniques to migrate and databases – either in whole, or just chunks at  a time! – quickly, effectively, and with confidence.

The Denver Aquarium is a fantastic, family-friendly venue for this summer event and it usually draws a considerable crowd, so please be sure to register as soon as possible. I’m thrilled and honored that RMOUG has finally asked me to present on behalf of their organization. I look forward to seeing you all there – it’s going to be a fantastic gathering!