Blog

Oracle Community Participation: Easy, No. Worth It? Yes.

Tim Hall’s recent blog post on his decade of experience as an Oracle ACE Director (and now as a Developer Champion) prompted me to think over my own experiences as an ACE Director since 2014. My perspectives are a bit different because of my different roles since I was awarded that status to my surprise in March of that year, but I’ve got a lot of similar experiences to share.

The Grind

For example, I recently took part in the far southern leg of the 2018 Latin America Oracle Developer Champion (LAODC) tour:

  • I flew from Chicago to Sao Paolo, Brazil and then to Asuncion, Paraguay – an 11-hour journey – in standard coach seats, with a lengthy, unexpected delay that delayed my arrival until late that evening.
  • I presented the next day, met with the user groups there, and then jumped on a plane with my colleagues to Santiago, Chile the next morning … except that meant flying east to Buenos Aires at 3 AM to fly back west to Santiago.
  • The rest of the trip – 11 days, five cities, nine presentations – left very little time to really get more than a taste of these marvelous countries and cities. I’m not complaining – I’m just explaining these aren’t vacations, they’re deeply serious exchanges with our colleagues to help explain some of the finer points of Oracle application and database technology, and a chance to mentor our younger colleagues as they traverse their careers as IT professionals.
  • Yes, we do celebrate a bit at our speakers’ dinners, and there’s a lot of camaraderie and shared stories, but after 11 days I was glad to take an afternoon off, take a break from talking about anything related to technology, and just catch up on a bit more sleep.

And that’s just one extended conference I attended this year. I just added up my scheduled events for 2018 and by mid-December, I will have presented at four major regional conferences in the USA (COLLABORATE, KSCOPE, GLOC, and ECO), two in Europe (DOAG and UKOUG), and close to a dozen smaller regional Oracle user groups and conferences.

  • As Tim mentioned, ACE Directors do receive some limited compensation for these events, but trust me, we’re not traveling in business class unless we pay for it ourselves or use accumulated miles. I’ve only done that when I need to arrive in fighting shape and ready to present the next day. Think more RyanAir and Southwest than Emirates or British Airways, and you’ll get the picture.
  • Before I was an ACE Director, I funded almost all of my conference attendance and travel on my own dime; a major conference can cost as much as $2000 once airfare, hotel, and other travel expenses are accounted for – but that doesn’t include the lost billing time if you are working as an independent contractor, or have to take vacation time to attend.
  • Full disclosure: As the Oracle SME for ViON Corporation, based out of Herndon, VA, my employer has sponsored my participation at many of these conferences, so I don’t have to pay for most of my travel to those events. However, that also means I often have to do double-duty at the company’s vendor table to help salespeople decode Oracle DBA tech-speak, and so I often miss out on conference content and chances to learn alongside the event’s attendees.

TANSTAAFL

As the saying goes, “There ain’t no such thing as a free lunch.” Presenting at these events demands a commitment to experimenting with the technology that underlies the presentations, mastering how it works well enough to present it effectively, and spending time with other professionals – ACEs and Oracle Master Product Managers and technology experts like Bryn Llewelyn, Maria Colgan, Anil Nair, Dominic Giles, Gerald Venzl, Marc Sewtz, and Steven Feuerstein, just to name a few! – to understand precisely why something is working the way it does.

As Tim has already mentioned, this simply takes a lot of time, especially in the run-up to major conferences like COLLABORATE, KSCOPE and OpenWorld. And since my employer doesn’t pay me to experiment on their time, that means I’ve got to either dedicate some of my non-billable time to design tests that demonstrate what I’m presenting about. So that means it’s not unusual in January and February to kiss my wife goodnight at 9:30 PM and toddle down to my chilly basement home office for several hours of exploration, testing, frustration, success, and hopefully some sleep usually in the wee hours of the morning.

It doesn’t end there, of course; with Oracle’s new release schedule, there are significant new features coming out every few months, and that means I’ve got to tweak, re-tweak, and rebuild at least a few slides between conferences and user group events. As I like to remind people, at most events you can usually find an ACE Director at the end of the hotel bar typing madly on his keyboard until the presentation is as close to perfect as possible.

So Why Do I Do It?

If this sounds a lot less glorious than you imagine, you’re right. So why do I keep doing it? For several reasons:

  • I absolutely love presenting. I am in the fortunate position of doing something I love: standing in front of a crowd (the bigger the better), talking about technology I understand pretty well, telling stories about what I’ve been through – especially the mistakes and disasters! – and even pontificating about what I believe the future holds for our industry. It’s unbelievably edifying to see a light go on above someone’s head when they learn something new, see something in a completely different light, or even disagree and debate a bit.
  • I stand on the shoulders of giants. My mentors – Arup Nanda, Kerry Osborne, Tom Kyte, Daniel Morgan, Maria Colgan, Penny Avril, Tim and Kellyn Pot’vin Gorman, Jeff Smith, Charles Kim, Connor McDonald, and dozens of other presenters and Oracle ACEs too numerous to mention – gave me a boost up, helped nurture me as a presenter and writer, encouraged me to try for ACE – and it would be shameful not to pay that support forward.
  • It’s time to give back. Most of all, I’ve spent almost four decades in IT, and I’ve seen a lot of stuff happen. If I’ve learned anything, it’s figuring out that sometimes it’s more important to know what not to do in a sticky situation that can save a database, a project, and even a whole team. There’s a whole new generation of DBAs and developers coming into our industry that could really benefit from my experiences, and the only way our industry – indeed, our civilization! – gets better is by transferring that knowledge and uplifting our colleagues. That’s my passion and my purpose.

Note: These observations are entirely my own, and are not endorsed by Oracle Corporation, the Oracle ACE program, or my current employer.

LAODC 2018: Time for a [Late] Wrap-Up!

I know, I know … it’s been weeks since I finished participating in the 2018 Latin America Oracle Developer Champion (LAODC) tour, but I have an excuse: I’ve also been on vacation in the Galapagos and Ecuador for ten days, and then I took a brief break for some remedial surgery. This tour was one of the most intense ACE Director travel experiences of my life – nine presentations in five different cities over 11 days! – but I appreciated every moment of the opportunity.

My part of the tour got off to a rousing start in Asuncion, Paraguay at the PYOUG event with a visit from their internationally-famous Recycled Orchestra. The 30+ students constructed their instruments completely from recycled materials and presented several numbers to get our attendees revved up to learn all about Oracle technology, especially Cloud – which is ironic because Paraguay has just recently upgraded its national internet infrastructure sufficiently to allow their DBAs and developers to take advantage of Cloud offerings.

Next, it was time to scale the mighty Andes and head to Santiago, Chile, by way of Buenos Aires. (Just like in the USA, sometimes the shortest distance between two points … isn’t.) My newfound friend Marc Sewtz from Oracle – a wizard of all things APEX! – was my able traveling companion for an early-morning flight to Santiago.

We teamed up there with CLOUG, Anil Nair (master product manager for RAC), Connor MacDonald (of AskTom fame), and plenty of the local ACEs – nice meeting you, Alexis and Otavio! – for several excellent Oracle presentations, excellent company,  and some great Chilean wines and local beers. (Speaking is tougher work than it looks. We stayed thirsty, my friends.)

Next stop: Sao Paolo, Brazil, one of the true megacities of the world. We had a little extra down time upon arrival, so we joined up with ACE program commander Jennifer Nicholson at the magnificent Museu de Arte de São Paulo (MASP) to view their collection of medieval and modern art.  A brief evening rainstorm didn’t cloud our spirits as we presented the next day on behalf of the GUOB and and their team to several hundred attendees.

Then it was time to head for the airport again and make the journey to Montevideo, Uruguay. I’ve dreamed of visiting Montevideo since I was in high school, and I was not disappointed – marvelous beaches and skylines, great company (nice to see you “at home,” Edelweiss Kammermann and Nelson Calero!), and a fantastic speakers’ dinner at the old Ferry Building that’s been converted to an open-air restaurant locus. Jennifer, Anil, and Marc even tried their hand at being cocineros for a few minutes. Montevideo had numerous squares scattered across the city on our way to our UYOUG hosts as well – a pleasant reminder of what I like about my native Chicago too.

Finally, I ended my part of the tour with a visit to Buenos Aires, Argentina. The Buquebus ferry across the Rio de la Plata speedily delivered us to our hotel just down the street from the famous and magnificent Obelisco in the Plaza de Republica, a tribute to Buenos Aires’ founding in 1812. We spent a long day with ACEs and speakers at AROUG, and after another marvellous dinner at an Argentinian steakhouse, I set my sights towards my trip to Quito, Ecuador to join my wife to celebrate our 40th wedding anniversary aboard ship bound for the Galapagos.

This trip was the culmination of a dream I’ve had since my teenage years – to actually see the cities and countries of America del Sur Australes that I’d only read about. I encountered vibrant Oracle User Groups and ACEs in every country I visited, as well as DBAs and developers that were hungry for the knowledge that I and my fellow ACEs and Oracle team members delivered. Thanks so much for the opportunity to present within your marvelous side of the world, my friends and colleagues!

Oh, and one more thing: I discovered that the Spanish word for developer in South America is desarrollador. How sexy is that?

It’s almost Winter. Time for deep learning at DOAG 2018!

I’m getting all geared up for the upcoming and prestigious DOAG 2018 conference next week (November 20-23) in Nuremburg, DE. The folks at DOAG patiently reminded me year in and year out since I became an ACE Director to attend, but since DOAG almost always lines up with American Thanksgiving, I demurred. Not this year!

I’ll be joining a cavalcade of excellent speakers on all things Oracle technology, and serendipitously, I’ll be presenting two of my favorite topics:

  • Get Smart! Embrace #SmartDB & Put Code In Its Place explains how DBAs and developers can leverage the #SmartDB paradigm to build applications and how that model can revolutionize your IT organization’s approach to DevOps.
  • Saving Your Database from Alzheimer’s: Oracle 12cR2 DBIM looks how the latest features of Database In-Memory, Analytic Functions, and Analytic Views – including a preview of some of 18c’s newest DBIM features – can make some incredible differences in application performance.

If you haven’t already registered for this event, please do! I’m looking forward to joining you there, learning from you, finding new colleagues, and meeting old friends. Prost!

UKOUG Tech Days 2018: Yule Want to See My Presos in Liverpool!

For the first time ever, I will be speaking at UKOUG Tech Days this coming December 5-8 in Liverpool, UK. I’ve wanted to carve out enough time to visit England during the Christmas holiday season ever since I explored the eastern edge of the UK a few years back, so it’s serendipitous that I’ll be joining a team of some of the best and most knowledgeable speakers on Oracle technology.

I’m also thrilled that two of my favorite topics were chosen for me to present:

  • Session #51: Everything You Know Is Wrong: DBA Intuition, Meet Hard-Core Metrics explores what goes through a DBA’s head when she’s trying to find the root causes of a particular problem, and how easy it is to let one’s intuition take control when she should be looking at the dashboard instead.
  • Session #47: Caveat Nuba Emptor: Matching Your Organization’s Needs To the Best OPC Database looks at two of Oracle’s Public Cloud offerings and explores the innards of how Exadata Express might make a great addition to a DBA’s capabilities to help her customers – her application developers! – quickly build new applications without fear of overusing critical resources.

Please do check out the schedule here; it could change, of course! – and don’t forget to register for the event. I promise I’ll see you there!

2018 Is Halfway Gone … But Not Forgotten!

It’s hard to believe that 2018 is half over already. I’ve had an incredibly busy six months traveling to and speaking at Oracle user groups events and conferences across the country, so it’s been another exhilarating six months for me … and that means you all have access to some great collateral and code!

I’ve added all four of my most popular presentations as PowerPoint slide shows for download. They’re chock-full of interesting insights into where our world as Oracle DBAs and applications developers is headed, plus some great code samples to boot.

Don’t forget to check out my overview of #SmartDB because it’s got some great examples of how to leverage Edition-Based Redefinition (EBR) and cross-edition triggers to make it simpler to handle application migrations and upgrades with no application downtime. And because everything I’ve shown you is a mere soupcon of how #SmartDB works, don’t forget to take at the links I’ve included in that presentation to (much!) deeper dives on #SmartDB by my colleagues and mentors Bryn Llewelyn and Toon Koopelars.

And the rest of 2018 will be equally busy: I’m headed off to South America to participate int the 2018 Latin America Oracle User CODE events in August, then heading over to ECOUG in September, and wrapping up my October with presentations and learning at OOW18. I hope to see you soon at an upcoming event!

Este Agosto, No Te Pierdas Mis Sesiones En LAOUC!

I am embarrassed to admit that I’ve ignored my dear colleagues just a few thousand kilometres to the south of Chicago for much too long … so it is a great honor to return to South America as part of the 2018 Latin American Oracle User Group (LAOUC) Developer Community Tour conference series this coming August 2018!

For now, here’s the schedule of where I will be presenting … but be sure to check the official LAOUC web site or the links below for the most up-to-date information on registering for these upcoming sessions:

July 31: Asuncion, Paraguay

August 2: Santiago, Chile

August 4: Sao Paolo, Brazil

August 6-7: Montevideo, Uruguay

August 9: Buenos Aires, Argentina

I’ll be talking about several topics that focus on some of the newest tools we can take advantage of for our developers, including how to choose the right Oracle Cloud for your development tasks at hand, with some really neat examples of how easy it is to use APEX in concert with Exadata Express for Oracle 12cR2 as well as DBaaS with Oracle 18c. I’ll also offer my viewpoints and code examples of how best to bring our developers’ application code back inside the Oracle Database in a sensible fashion through the #SmartDB paradigm.

So if you are going to be near any of these venues this August, I hope to see you there! Hasta luego, mis amigos y amigas!

Oracle DBAs Weigh In: Fear Not the Autonomous Database!

I’ve had the honor to share a page in Fortune Voice with some of my most esteemed and respected colleagues – including Michelle Malcher, Nitin Vengurlekar, Russ Lowenthal, and Dan Vlamis – on the topic of what the Oracle Autonomous Database (or what I like to call AuDB) means for Oracle DBAs as they continue to upgrade their careers from DBA 2.0 to DBA 3.0.

Michelle, Nitin, Russ and Dan all offered different viewpoints on what AuDB offers to the common DBA, and I concur heartily! I can’t wait to see what the OLTP version of AuDB will bring for us DBAs who are often tasked with keeping hundreds of different databases up and running in good health. It will be an interesting voyage!

 

2017 Is [Almost] a Wrap: Sample Code, Ruminations, & Portents for 2018

2017 has been an incredibly busy year! Besides speaking at half a dozen different Regional Oracle User Groups this year, I co-authored two new books, experimented in depth with Oracle Public Cloud, and helped my latest employer, ViON Corporation, build out their Oracle Gold partnership from the ground up, one customer at a time. It’s been an exhilarating experience for me, but for you, it means access to some great collateral and code:

  • I’ve added all three of my most popular presentations as PowerPoint slide shows for download. Many folks have asked me for the sample code in the two most technical presentations on Oracle 12cR2 Database In-Memory feature explorations and Analytic views. Just in case you missed out on seeing me present at one of my numerous conference engagements this past year, I hope these presentations help you with your experimentation.
  •  I’ve also added a link to all of the code examples for my most recent book, PDB Me to Oracle Cloud Pocket Solutions Guide: A Lazy DBA’s Guide to Mastering Multitenant Features on Oracle Cloud, that I co-authored with good friend and fellow Oracle ACE Director Charles Kim from Viscosity NA. It’s a great little handbook that explores some of the neatest features of Oracle 12cR2 multitenancy, including the ability to move a PDB between different CDBs without ever facing any application downtime. Oh, and by the way – it’s all done in the Oracle Public Cloud!
  • Check out my most recent article on IOUG SELECT that include my impressions from Oracle OpenWorld 2017. I review what Larry Ellison’s keynotes revealed for the future of Oracle and what those revelations most likely mean for the role of Oracle DBA in the coming months and years.
  • Finally, Oracle Technology Network just published my latest article that explores the unique advantages of leveraging Oracle Public Cloud’s Exadata Express features for a robust, automatic, and powerful Cloud-based platform, especially for experimenting with Oracle 12cR2 Database In-Memory features at a reasonable cost before investing in it for your on-premises databases.

Enjoy, my colleagues! Here’s to a 2018 that’s full of surprises. Only good ones!

SANGAM17: India, Here I Come At Last

At the request of my colleagues in India – especially the ever-persistent Oracle ACE Director Sai Janakiram – I have at last found a window of time during which I can attend the annual SANGAM17 event in Hyderabad. (It helped that Sai apparently recruited our fellow ACE Director Bjoern Rost to call me out as a wimp for not being willing to travel halfway around the world 24+ hours to India and to provide some much-needed mentoring for our younger colleagues there. Hint: Don’t ever call a guy from Chicago a wimp.)

I’ll be presenting three of my favorite topics, plus a brand-new one tailored specifically for my brother and sister Oracle colleagues in India:

DBA 2.0 Is Dead. Long Live DBA 3.0!

Cloud. DevOps. Agile. Big Data. 12cR2. So much to worry about if you’re an Oracle DBA who hasn’t made the transition from DBA 2.0 to DBA 3.0! Let me help you make the transition with a brief presentation – no code samples, just my viewpoints! – about the the future history of the DBA role in the USA.

Oracle 12cR2 Database In-Memory: Adventures with SwingBench TPC-DS

I’ll discuss and demonstrate what I’ve discovered about several aspects of Oracle Database 12cR2’s newest Database In-Memory features, including In-Memory Expressions, ILM ADO Policies for In-Memory Objects, and improvements to In-Memory Joins and In-Memory Filtering.

Stop Guessing, Start Analyzing: New Analytic View Features in Oracle Database 12cR2

I’ll discuss and demonstrate how to leverage the unique features of Analytic Views in 12cR2 that can save an Oracle DBA and application developers from writing inordinately complex code to solve multi-dimensional analytic queries.

Want to Be Successful In IT? Follow the PRIYA Principle.

As SANGAM17 draws to a close, I’ll be speaking at some length about the essential qualities of a true Information Technology professional. I’m honored to have a chance to present my observations from my 35+ years in IT and explain what I believe you’ll need to do to stay ahead of the curve in the coming years as the demand for professional resources increases.

My Next Book: Oracle Database 12c Release 2 Testing Tools and Techniques for Performance Stability

I am excited to announce the pre-release of my third co-authored book in as many years: Oracle Database 12c Release 2 Testing Tools and Techniques for Performance Stability.

My extremely talented and loquacious co-authors include database performance benchmarking expert and Oracle ACE Dr. Bert Scalzo,  and Oracle ACE Director Deiby Gomez, the youngest Oracle ACE in the world. We are leveraging our combined years of experience working with Oracle Databases to provide a new look at the testing tools that are built into Oracle Enterprise Edition.

Our book will be looking closely at the myriad different tools available for Oracle 12cR2 SQL performance tuning techniques, but we’ll also be diving deeply into the rich feature sets of Real Application Testing Suite and Database In-Memory. We’re also focusing our efforts on getting everyone ready to tune application workload performance in an Oracle Cloud environment; we have actively leveraged the same environments that any Oracle DBA can use on either a free or subscription basis to prove out techniques that measure the impacts of switching from on-premises hardware to Cloud-based data centers.

Our book won’t be available until just before Oracle OpenWorld 2017, but you can pre-order it via Amazon.com or just stay posted on its release date here. And while you’re at it, be sure to check two other books that I’ve co-authored, Oracle Database Upgrade, Migration & Transformation Tips & Techniques from Oracle Press, and Oracle Database Problem Solving and Troubleshooting Handbook. All three of these books are available in either soft-cover and Kindle format.