Author: jczuprynski

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.

So you are your company’s newest (or oldest) Oracle DBA, and that means you’ve just finished getting back up to speed after the 2016 holiday season (which probably meant scads of patches and upgrades to your systems while everyone else was enjoying eggnog with their families). You’ve spent your spare time between crises to be ready to move to Oracle 12c Release 2 as soon as it’s out … and now your CIO and CTO are bugging you about moving everything to the Cloud to help reduce costs, and you’re still trying to figure out what the difference is between CAPEX and OPEX. It’s enough to make you wonder if your Oracle DBA role will still be around in 2017!

If this sounds even a little bit like your career today, then be sure not to miss my upcoming webinar on Wednesday, February 15, 2017 at 1:00 PM CST (2 PM EST, 11 AM PST). My presentation – DBA 2.0 Is Dead. Long Live DBA 3.0! – will present my vision for the future of the Oracle DBA role in 2017 and beyond.

Registration is free but filling up quickly. And don’t forget to send me some feedback on my forecast!

Once again,  I’m honored and excited to have an article in IOUG SELECT Journal’s 3rd Quarter 2016 edition. This time, I’m delving deeply into the latest features of Oracle 12cR1 Real Application Testing in the first part of a two-part series entitled Regression Analyzed, Tout de Suite: Leveraging Oracle 12c Database Real Application Testing (RAT) Suite. I’ve recently leveraged that tool to experiment with multiple scenarios for evaluating Oracle Database 12.1.0.2’s Database In-Memory Features … which I’ll explain in the second part of the series, of course! If you don’t have an IOUG membership, you can still browse a copy of my article in PDF format … but seriously, shouldn’t you have membership in one of the best Oracle User Groups in North America?

I also enjoyed interviewing my able colleague Der’ly Guiterrez from OnX Enterprise Solutions for his article entitled The Wolf Is Always at the (Hospital) Door: Reducing Information Security Risks for Health Care Organizations.  Der’ly’s role as OnX’s Security Practice lead gave us a chance to explore some of the typical challenges that security breaches of IT organizations can cause, especially when that organization is responsible for sensitive PHI or PCI data.

IT Central Station recently interviewed me at COLLABORATE16 in Las Vegas and asked me for my professional opinion of Oracle Database 12cR1’s feature sets, especially Database In-Memory and Multitenancy. I also provided a glimpse of coming attractions – some (already public) information on how DBIM and Multitenant is going to work in 12cR2 – and how I believe those features will make short work of transitioning to a Hybrid Cloud environment in the coming months after 12cR2 finally moves out of beta testing mode and into general availability.

If you have a few spare minutes, please take a look and let me know what you think!

In my latest IOUG SELECT Journal article – DBA, Heal Thyself: 5 Diseases of IT Organizations
and How Oracle DBAs Can Cure Them – I mentioned a specific ailment that I call Idiomyopia. (It’s my term for IT organizations that tolerate incompetent Oracle DBAs.)

It’s not unusual for an Oracle DBA’s incompetence to be identified well after they’ve been hired because of inadequate HR screening policies, or because of inadequate technical interviews. Sometimes, however, a candidate has simply pulled the wool over everyone’s eyes because their CV, resume, and educational background seems to be a virtually perfect fit for the job. It only becomes painfully obvious after the DBA has been asked to do something relatively simple – say, set up a database backup, or perform complete recovery, or even tune a troublesome SQL statement for better performance – that we discover we’ve been the victim of our own Idiomyopia.

And what happens to the newly-discovered incompetent DBA? Usually … nothing. They simply become relegated to simpler, less-demanding tasks, even though they’ve essentially perpetrated fraud against their employer. No legal action is taken;  perhaps they even saunter off to another job where the masquerade continues.

So I have a modest proposal for my brethren competent Oracle DBAs. Whenever we discover this type of fraud, let’s try a novel approach: shaming. My inspiration for this idea is an ongoing anti-corruption campaign being waged in India by those appalled by the audacity with which they are regularly approached for bribes on a daily basis. The idea is simple: Instead of offering money when asked for a bribe, a zero-rupee note emblazoned with the image of  Mahatma Gandhi is tendered instead.

In that same spirit, I’ve produced a facsimile of a zero-dollar bill. It carries my disapproving visage and is suitably emblazoned in Latin phrases, so feel free to print some off and have them ready for your next round of technical interviews with a suspected “exaggerator.” (Oh, and just in case your Latin is rusty … Mendax Mendax Braccae Igni roughly translates to Liar, Liar, Pants on Fire.)

At long last, I’m honored to announce that my second book has been published!

I labored intensely alongside my co-authors – Mike Ault, Tariq Farooq, Guy Harrison, Mohammed Houri, Syed Jaffar Hussain, and Paulo Portugal – to bring our years of experience to bear on some of the more common (and not-so-common!) problems that an Oracle DBA is likely to encounter during her career and provide common-sense, practical solutions to solving those problems in short order.

So feel free to take a look inside at our new book. It’s available in soft-cover as well as Kindle format. And please let us know what you think – don’t be afraid to write a quick review if you’ve found the common-sense strategies and techniques have been helpful to your career or just in your day-to-day Oracle DBA activities.

I recently had the honor of participating in an intensive week of Oracle 12c Release 2 (12cR2) beta testing during the week of April 25-29 at Oracle HQ in Belmont, CA. I joined an elite team of ten Oracle ACEs and ACE Directors to explore the latest features of Oracle 12cR2. It was a most intense experience, as we tested 12cR2 (quite literally!) from sun-up to sun-down for four straight days. We focused our combined attention on installation and upgrade tasks that any Oracle DBA would normally conduct as they’d transition from earlier releases to 12cR2; we also experimented with many of the latest features of 12cR2, including Database Sharding, Multitenancy, and Database In Memory.

What amazed me personally was the responsiveness of the Oracle development team, who were on hand to help us document and research any unexpected behavior, blips, and documentation consistency. Punctuating our testing efforts were several in-depth briefings on the various new features of Oracle 12cR2 from key Oracle senior product managers including Penny Avril, Maria Colgan, Andy Rivenes, Patrick Wheeler, and Markus Michalewicz.

Our beta testing team presented our findings on the final day. Most of the 12cR2 development team and many of the corresponding senior product managers attended. It was also humbling to see Andy Mendelsohn stopping by briefly to hear our reports. With over 200 years of Oracle database experience between us, our beta testing group was quite pleased with what we discovered about 12cR2 in terms of its numerous new features, its stability, and its ease of use. I’d love to tell you more … but if you’re not in the beta testing program, you’ll have to wait just a little bit longer to experience 12cR2 for yourself.

Along with four other Oracle ACEs, I was recently honored to have a chance to express my opinions on Oracle’s Public Cloud offerings during a series of interviews with PROFIT magazine. It was a fantastic (and humbling!) opportunity to speak my mind on how IT organizations in general – and Oracle DBAs in particular – can take advantage of Oracle Public Cloud’s unique solutions to application scalability, security, and capacity enhancement.

I’m excited that PROFIT quoted me on the future state of Oracle database administration: “DBAs aren’t going away. We’re going to finally do what we should be focused on.” Give it a read, and let me know what you think!

I’m excited to announce that the renowned publication Database Trends and Analysis (DBTA) has chosen to print my latest article on Oracle Database 12c In-Memory features entitled Tips for Accelerating Analytics with Oracle Database In-Memory. It was quite humbling to have my colleagues at Oracle, especially Maria Colgan (whom I think of as the Goddess of All Things DBIM) thoroughly vet my understanding of IMCS. I hope you find it an interesting read that drives you to consider leveraging the unique advantages of In-Memory Column Store for speeding up your analytic queries and decision support workloads. There’s more in-memory magic coming in the next few months when Oracle 12c Release 2 finally arrives, but this is a great time to start familiarizing yourself with IMCS features and benefits.

Of course, I’m also excited about my most recent article in IOUG SELECT Journal’s 2nd Quarter 2016 edition entitled DBA, Heal Thyself: Five Diseases of IT Organizations and How Oracle DBAs Can Cure Them. As its title suggests, I’ve summarized five typical maladies of IT organizations today that I’ve seen in the past 15 years as an Oracle DBA, Oracle University instructor, consultant, and pre-sales associate. For the first time ever, a publisher has seen fit to print something from me without [… drum roll …] a single line of code in it.  I’m sure it will cause some raised eyebrows, some heads nodding in agreement, and perhaps even a flash of anger and frustration, but that’s what I intended because if you’re an Oracle DBA today, I share your pain (and your organization’s as well). If you don’t have an IOUG membership, you can still browse a copy of my article in PDF format … but seriously, shouldn’t you have membership in one of the best Oracle User Groups in North America? I look forward hopefully to your amusement, await your comments, and apologize in advance if I’ve stirred your passion. Please enjoy!