January 26: Shake Off Cabin Fever in Indianapolis, Courtesy of INOUG

I’ll be the first to admit it: I’m embarrassed that I’ve never connected with my Oracle colleagues in Indianapolis. Well, the good news is that I am finally going to have a chance to fix that: I’ll be speaking at the next INOUG quarterly meeting on January 26 at the Eli Lilly Auditorium near the Indiana State Capitol.

My colleagues at ViON Corporation will be sponsoring the event as well, so you can be sure we’ll have some neat “swag” on hand and maybe even a few signed copies of my two latest books ready as door prizes.

Here’s what I’ll be talking about; you can get a feel for what my presentations will discuss from my Presentations page:

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.

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

For the past two years 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!

 

Advertisements

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!

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!

 

June 6th: Putting the DBA in D-Day at NATCAPOUG

At the invitation of my friend and colleague Erik Benner, I’m thrilled to present one of my favorite Oracle 12cR2 topics at a brand-new Oracle User Group – the National Capital OUG (NATCAPOUG) – on this coming June 6th. So if you are in the Reston, VA or Washington, DC area that evening, please be sure to register for that event and I hope to see you there!

Here’s a summary of what you’ll learn:

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.

#C15LV: It’s On In Vegas, Baby!

I’ve just confirmed that I’ll be presenting yet again this year at IOUG’s COLLABORATE15 (#C15LV) this coming April 12-16, 2015 in Las Vegas, NV. C15LV is once again packed with excellent content from scores of fantastic speakers, and I’m honored to have been included for a third straight year. My three sessions at this year’s conference  include:

#140: The Best of Both Worlds: In-Memory Column Store and Advanced Index Compression in Oracle Database 12.1.0.2

I’ll review the results of my experiments with the new In-Memory Column Store (IMCS) features of Oracle Database 12.1.0.2, including a look at the new In-Memory Aggregation feature set. I’ll also discuss how Advanced Index Compression can help lower index access times even when indexes may still be needed.

#147: Precisely My Point: Leverage Attribute Clustering and Zone Mapping in Oracle Database 12.1.0.2

I’ll explain how to use the brand-new Attribute Clustering and Zone Mapping features for improved query performance in Oracle Database 12.1.0.2.

#149: A Smart Optimizer Gets Even Smarter: New Histograms in Oracle 12cR1

I’ll be demonstrating how Oracle Database 12c’s two new histograms – Top Frequency and Hybrid – can dramatically improve the accuracy of cardinality estimates, construction of better execution plans, and speedier access to skewed data sources.

I’m looking forward to another fantastic IOUG experience at C15LV this coming April. I hope to see you all there!