July 27: Meet Me in Dallas, Get Excited about Oracle 12cR2!

I’m excited and honored to announce that I’ve been asked to speak again at the Dallas Oracle User’s Group (DOUG) at their coming July 27th meeting. Registration is now open for this event, so be sure to sign up soon!  I’ll be reprising two of my most requested topics:

DBA 3.0: Transform Yourself into a Cloud DBA, or Face a Stormy Future

I’ll 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.

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 have graciously agreed to sponsor this event … and that means there will be some decent raffle prizes and “swag” on hand. Please be sure to join us, my Texas colleagues!

 

Advertisements

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.