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!

Advertisements

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.

2017: [Belated] Thanks, ODC, For All You Do!

ManyTanksJust a quick shout-out to all the folks at Oracle Developer Central (the new name for Oracle Technology Network) for all the excellent assistance over the years as I’ve done my best to spread the word about all things Oracle Database.

I’ve been in IT for 35+ years now, and I’ve got to admit that I’ve never had more fun, been more professionally challenged, and given more opportunities to expand my knowledge about Oracle Database without the tireless efforts of Laura Ramsey, Jennifer Nicholson, and Lori Lorusso. If I’ve left anyone out … well, you know who you are! Thanks for all you have done, continue to do, and will do in the future to help me tell the Oracle story.

Denver In Autumn: Join Me on November 1, Get 12cR2’d!

It’s long overdue, but I’m finally returning to Denver to share my knowledge with the folks at RMOUG on November 1. I’m sure that I’ll still be pumped up from Oracle OpenWorld 2017, so please be sure to register for this event – I hope to see you there!

Here’s what I’ll be talking about:

DBA 2.0 Is Dead. Long Live DBA 3.0!

Cloud. DevOps. Agile. Offshoring. 12cR2. Autonomousness. 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.

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

If you’re either an Oracle DBA or an applications developer who works with data warehouses, you already know that answering complex business questions often require building extremely complex, n-dimensional queries against fact tables and dimensions stored within Oracle databases. Often, the toughest aspects of any business intelligence endeavors involve establishing accurate business rules about the relationships between data. What if there was an easier way? Fortunately, Oracle 12cR2 offers a brand-new answer: Analytic Views, an entirely new set of database objects aimed at making short work of these analytical tasks. If you attend this session, be prepared to leave with practical examples of how to leverage these powerful new features.

Sweet Home, Chicago! Join Me on October 26th, Upgrade to DBA 3.0

Trust me – early fall in Chicago is one of the best times to see my hometown. Join me and a whole bunch of top Oracle talent at the Midwest Oracle User Group (MOUG) for an all-day session that will be chock-full of new information from OOW17 from the mouths of some of the best speakers in the US.  So if you are in the Chicagoland area on October 26th, please be sure to register for this event – I hope to see you there!

DBA 2.0 Is Dead. Long Live DBA 3.0!

Cloud. DevOps. Agile. Offshoring. 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.

October 12: Join Me in Minneapolis, Courtesy of TCOUG

At the invitation of my colleagues in Minneapolis, I’ll be presenting on several Oracle 12cR2 database topics on this coming October 12th. If you are in the Minneapolis region that day, please be sure to register for that event and I hope to see you there! Here’s a summary of what you’ll learn:

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

For the past 28 months I’ve been working closely with Dominic Giles, the original author of SwingBench, to bring to fruition a new version of that venerable benchmark generator tool that now includes the ability to generate a simulated TPC-DS workload. We’ll harvest the fruits of our labor during this session as I demonstrate 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. This session offers a great way to dive into the deep end of the 12cR2 DBIM pool, so be sure not to miss it!

 

9/13: Mark Your Calendars for IOUG Master Class on Oracle 12cR2

Exciting news! The fine folks at IOUG have just opened registration for its first-ever Oracle Database 12cR2 master class! I’ll be joining my fellow ACE Directors Rich Niemiec and Charles Kim from Viscosity NA for our very first event in Herndon, VA – just outside Reston, VA and close to Washington, DC and Baltimore, MD – on Wednesday, September 13, 2018.

Viscosity NA and ViON Corporation are the prime sponsors for this all-day event, which will feature two different learning tracks for Oracle 12cR2: a hands-on lab on 12cR2 multitenant features hosted by Charles and myself, and a second track devoted to discussing and demonstrating the latest features of Database In-Memory, hosted by our special guest speaker, Oracle’s Andy Rivenes, the Product Manager for all things Database In-Memory.

Rich Niemiec will be our keynote and lead-off speaker, so be sure to get there early to hear Rich’s unique perspectives on the future direction of IT, as well as his insights on several other aspects of Oracle Database 12cR2.

We’re also coordinating a schedule of future IOUG Master Class events in the upcoming months that will feature the same core team of ACE Directors (Rich, Charles and myself) but with a rotating group of speakers from Oracle and other ACE Directors based on geography and availability.

Registration is now open, so if you are in the Washington DC – Baltimore, MD – Reston, VA area, be sure to sign up for this free event.  It’s a rare chance to get some hands-on, in-depth about Oracle 12cR2’s complex yet elegant features so that you can help make the case to transition to 12cR2 in the immediate future with confidence. I look forward to seeing you there!