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.

KSCOPE17: San Antonio. June 25-29. Get Your 12cR2 On!

I’m honored and humbled to announce that I’ll be presenting at KSCOPE17 for the very first time. ODTUG will be hosting several thousand IT professionals for one of the largest and best Oracle conferences in North America on June 25 – 29 in San Antonio. As Oracle Database 12cR2 is finally available, I’m hoping that I can lend my perspective on several of its facets to the advantage of everyone attending.

There’s still time to register – I’ll see you there! Here’s a summary of what you’ll learn:

PDB Me, ASAP! Oracle Database 12cR2 Multitenant Workshop

Monday, June 26   10:30 AM – 12:45 PM  Goldenrod

My colleague Charles Kim from ViscosityNA and I will be hosting a hands-on lab on Oracle 12cR2 Multitenant features. ViscosityNA has generously provided the computing infrastructure for your edification; just bring your laptop and prepare to have your skills strengthened and brain expanded on some mind-blowing new features of 12cR2 multitenancy, especially hot cloning, refreshable PDBs, lockdown profiles, resource limits, and much more.

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

Wednesday, June 28   8:30 AM – 9:30 AM  Begonia

For the past year, 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. This session offers a great way to dive into the deep end of the 12cR2 pool, so be sure to mark this one on your calendar.

Regression Analyzed, Tout de Suite: Leveraging Oracle 12c Database’s Real Application Testing (RAT) Suite

Wednesday, June 28   3:00 PM – 4:00 PM  Begonia

If you’re tired of not knowing exactly how your applications will perform once you’ve upgraded to Oracle Database 12cR1, or if you’re exhausted from tuning SQL after your developers have released their latest version of code without really testing it to destruction, then this session is for you. I will explain RAT Suite’s newest functions in 12.1.0.2, including Workload Intelligence, Workload Scale-Up, and Consolidated Database Replay, as well as its original key features – Database Workload Capture and Replay (DBWC/R) and SQL Performance Analyzer (SPA) – to avoid unnecessary application performance regression before applications are deployed.

July 25: Join Me In St. Pete for Oracle 12cR2 Knowledge Upgrade!

SOUG._LogoGreat news! I’ve been asked by my fellow Oracle ACE, Troy Ligon, to present at the SunCoast Oracle Users Group (SOUG) on July 25th in St. Petersburg, Florida. Registration is now open for this event, so feel free to sign up. I’ll be reprising two of my most requested Oracle Database 12cR2 topics from COLLABORATE17:

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

For the past year, 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. This session offers a great way to dive into the deep end of the 12cR2 pool, so be sure to mark this one on your calendar.

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.

Oh, one more thing: My colleagues at ViON Corporation are sponsoring this event, and that means there will be some decent “swag” on hand. Please be sure to join us, my Floridian colleagues!

June 22nd in Chicago: Hot 12cR2 Topics On Tap

Summer in Chicago can be unpredictable, but our colleagues at the Chicago Oracle Users Group (COUG) are certain of one thing – it’s time to plan your transition to Oracle Database 12cR2 before winter arrives. So be sure to join us for a special Oracle-sponsored event on Thursday, June 22, 2017.

Oracle has graciously granted us access to an excellent guest speaker: Willie Hardy, Vice President of Oracle Database Product Management, will share his unique perspective on all things Oracle Database 12cR2 with his presentation, What’s New in Oracle Database 12c Release 2.

To round out our evening, I’ll be presenting one of my favorite Oracle Database topics, Oracle 12cR2 Database In-Memory: Adventures with SwingBench TPC-DS, a reprise of my presentation at our first-ever 12c SIG Virtual Seminar.

And we have a new venue as well – the Addison Hampton Inn & Suites – that’s central to the Western Chicago suburbs and easy to reach right after work. Be sure to join us – you can register for this free event here. I look forward to seeing you there!

May 9-10, Atlanta: Get Your Tech On, Courtesy of GAOUG!

If you are ready to find out more about Oracle 12cR2 – or if you’re even just worried about the future of Oracle DBA-dom – please mark May 9-10 on your calendar and plan to join me and an illustrious group of Oracle ACEs in Atlanta when the Georgia Oracle Users Group convenes their 2017 Tech Day conference.

My first presentation is DBA 3.0: Transform Yourself into a Cloud DBA, or Face a Stormy Future, will offer up my viewpoints on how five key trends in the IT industry – Cloud, Big Data, IoT, Security, and Reshoring – are having an impact on the role of the Oracle DBA within their IT organizations, and how it’s crucial to transform yourself into a Cloud DBA in 2017.

My second presentation, Stop Guessing, Start Analyzing: New Analytic View Features in Oracle Database 12cR2, will take a look at 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.

If you attended this event last year, you already know how much talent was on stage and the level of technical detail that was presented. Please tell your colleagues all about this event – it’s one of the best in the Southeastern US, and supported by an extremely robust Oracle User Group. So if you are planning to be in the Atlanta area during the 2nd week of May 2017, don’t miss this event!

If you want to learn more about GaOUG Tech Days and the other impressive speakers, check out the blog hop posts below. If you’ve never heard of a blog hop, it’s a group of bloggers who all get together to blog on a similar topic, giving you a lot of useful information from different perspectives, but in one stream. Enjoy your “hop” between blog posts and register for GaOUG Tech Days today!

Stewart Bryson, RedPill Analytics

Jim Czuprynski, OnX Enterprise Solutions

Chris Lawless, Dbvisit Software

Bobby Curtis, Oracle Corporation

Danny Bryant, Accenture Enkitec Group

Eric Helmer, Mercury Technology Group

 

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.

Oceans 17: Heist Some Knowledge At C17LV In Vegas

c17lvThe days are getting longer, the evening shadows shorter, and that can mean only one thing: it’s almost time for COLLABORATE17! IOUG will be hosting over 5,000 IT professionals from every corner of the earth for one of the best Oracle conferences of 2017 on April 2 – 6 in Las Vegas at the Mandalay Bay Resort.

Last year’s event was the best I’ve ever attended, so my expectations for this year are even higher – especially with the recent announcement of Oracle Database 12cR2’s general availability. Like any good movie about heists, there will be a resolute cast of characters who overcome every technical challenge that’s thrown in their way … and this year, that’s us, your humble team of presenters. My four sessions at C17LV are focused on several new features of 12cR2, so if you’re struggling to get your head around what the latest release will mean for your IT organization, be sure not to miss any of them. And don’t forget to attend the 12c Database SIG meeting as well, which I’ll be overseeing alongside my able colleague and ACE Director Anuj Mohan – more on that in a later post.

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

Monday, April 3 2:45 PM – 3:45 PM

Palm C

Session# 368

For the past year, 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. This session offers a great way to dive into the deep end of the 12cR2 pool, so be sure to mark this one on your calendar.

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

Tuesday, April 4 11:00 AM – 12:00 PM

Palm A

Session # 369

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.

Cloud DBA Transformation: Futuristic TomorrowLand, or Desolate Wasteland?

Tuesday, April 4 4:15 PM – 5:15 PM

Banyan C

Session # 196

Unless you’ve been trapped under a rock for the past 18 months, you must have already heard all about Oracle Cloud and its many possible configurations – Public, Private, or Hybrid and the wonderful joy and happiness it will bring to the civilized world. But if you’re an Oracle DBA, you may have more of a jaundiced view about the implications of Oracle Cloud for your databases, your IT organization, and – perhaps most crucially – your career. Join me and my colleague Gary Gordheimer as we employ our unique self-deprecating style and distinctly different perspectives to probe what Oracle Cloud will mean in the immediate future from both utopian and dystopian viewpoints. Warning: There will be laughter – so be sure to bring a sense of humor.

Oracle 12cR2 Expert Panel

Wednesday, April 5 4:15 PM – 5:15 PM

Palm A

Session # 518

With the release of Oracle Database 12cR2 barely a few weeks before this session, the dozens of new features will be a daunting task for any Oracle DBA to navigate. So – don’t! Join me and a panel of experts – Oracle ACEs all! – as we review several key feature sets that we find most compelling for today’s DBAs, including the latest buzz on Multitenancy, Database In-Memory, Big Data, Sharding, and many others.