Blog

At Long Last, Our Podcast Is Launched!

Six months ago, it was just a simple idea based on a few brief conversations. Today, it’s finally a reality: the Beyond Tech Skills podcast.

Some background is in order. My good friend, colleague, and fellow Oracle ACE Director Liron Amitzi and I had been talking in person over an adult beverage or three (pre-COVID, of course!) and then texting and chatting for the past few years about the state of the IT industry. We found that even with our cultural differences – he’s originally from Israel but now lives in Vancouver, BC, and 20 years younger than me – we were remarkably like-minded about the fantastic opportunities IT has to offer to so many diverse folks around the world.

But we also saw there were enormous gaps:

  • Folks often focused so much on the technology itself or their coding skills that they ignored the other two-thirds of what makes a truly great professional: the soft skills they needed to be successful, including the importance of gaining detailed business knowledge as well as how to communicate clearly and work together as a team.
  • IT organizations were spending incredible amounts of time trying to find qualified candidates for positions at all levels, mainly because they had no idea how to interview people properly. Even worse, many great candidates didn’t get connected with great companies simply because they didn’t know how to handle the interview process.
  • Finally, as we looked back over our combined 60 years of experience, we were disturbed by the ongoing lack of diversity in many IT organizations. Both of us remember a time just a few decades back when the “white bro developer” culture didn’t exist and the advantage that different backgrounds and viewpoints yielded across the entire software development lifecycle.

We decided it was time to take action. We’re leading off our podcast with a series of episodes on the interview process itself: how to find the right candidates for your IT organization – the ones with the right fit and finish to match your teams’ goals.

But we’re not stopping there! We’ve got a great series of interviews that will tackle all of the issues we’re most concerned about, including DEI (diversity, equity, and inclusion) and how we can all make a difference. We’ll be talking to many of our colleagues across multiple technologies and industries over the next several months.

We’re planning to publish a new episode every second Wednesday starting on 11 February, but for now, please check out our introductory episode – just point your favorite podcast app at Beyond Tech Skills – and you can always stay up to date on our entire list of episodes at BeyondTechSkills.com.

2020: Meteor Averted. Bring on 2021!

In a year that started with only the third impeachment in history of a sitting President of the USA, a global pandemic that has killed hundreds of thousands of people, major unrest and justifiable demands for social justice and an end to police violence in so many of our towns and cities, and an unprecedented general election campaign that saw incredible voter turnout and post-election turmoil across my fine nation, I found myself drawing dark comfort from one of the most appropriate bumper stickers I’ve seen this year: Giant Meteor 2020. Just End It Already.

So what will 2021 bring? Here’s my viewpoints on technology, human civilization, and hope for an amazing year and decade.

Everywhere, the Internet of Things (IoT). IoT shows no signs of stopping its expansion into our daily lives, and that’s not a bad thing, either. Wearable devices, real-time contact tracing, and even cybernetic implants have made news in 2020. Remember that the whole point of IPV6 addressing was to make networking available for up to some 50 trillion individual devices by 2050, and I’ll be keeping an eye on that trend in this decade.

What’s also fascinating to me is the incredibly low-cost capabilities of IoT, made possible by cheap and reliable Raspberry Pi and Arduino computing nodes, sensors, and hubs. For example, today I’m putting the finishing touches on what I believe is a pretty sophisticated home security system, all built on IoT components. I’ve been able to build that with open-source software and a lot of help from online support communities. It’s not been without frustration, but I’ve learned so much from the experience that I’m ready to move on to more challenging tasks.

Machine Learning, AI, and Decision By Digital. All these IoT data sources offer our human civilization an incredible set of amazing opportunities, including more efficient agriculture, intelligent electric vehicles, “smart cities,” closed-loop recycling, cleaner air and water, and especially electric power infrastructure. But to clear the grain from the chaff, we’ll need ever-better machine learning algorithms, artificial intelligence, and digitally-driven decision making to take advantage of these exabytes of information.

Convergence, in Databases and Applications. 2020 clearly demonstrated that just-in-time supply chains have some weaknesses during times of stress from global events like the COVID-19 pandemic as well as local catastrophes like the Australian and Californian wildfires and a horrendous series of tropical storms and hurricanes. That means we’ll need to consider where our critical databases, applications, and infrastructure is located, too, so I’ll be watching trends towards converged solutions like Oracle’s Application Express (APEX) and its emphasis on its Converged Database strategy.

Emphasis on Objective Truth. Finally, if this past year has shown us anything – from the USA’s incredibly incompetent response to COVID-19 as well as the dramatically divergent political extremes about the reliability of the results from the USA’s general election – it’s the value of objective, verifiable, trustworthy facts and information. My country’s information infrastructure has been badly damaged, not just by recent nation-state actors’ hacking attempts, but by a deliberate rejection of expertise and knowledge provided by trustworthy professionals about everything from basic principles of public heath to how elections actually work.

It’s going to take at least a few years to restore that faith and trust in public institutions so that we can move on to tackle the enormous problems facing our human civilization in everything from climate change to clean energy transformation. But I’m optimistic that we can still get there because, as Jeff Bridges says in Starman, “When things are at their very worst, humans are at their very best.”

Bring it on, 2021! We are ready to be at our very best.

My Hat’s In the Ring for ODTUG Board

As you’ve probably heard, I’ve tossed my hat into the proverbial ring for ODTUG Board membership.

This is the first time I’ve ever run for any position of this stature in my life, and hopefully my platform and vision for the future of ODTUG will help you decide if I’m worthy of this honor. (My fellow candidates’ positions are also there, so please do take the time to read through our credentials and proposals.)

One thing is for sure: We have a most excellent roster of ODTUG candidates to choose from! I’m amazed at the talent that we have attracted to ODTUG, and that’s why I firmly believe we’re the premier Oracle User Group in North America bar none. So no matter who you vote for, please do vote! It’s crucial that every member of ODTUG has their voice heard, especially in these challenging times for our families, our careers, and our industry.

So … Anything Happened Since I Last Blogged?

As we start the second half of 2020, it’s a great time to reassess where we’ve been and where we’re headed. For example, I just realized it’s been six whole months since my last blog post, but it’s not like anything happened since the beginning of the year, right?

It’s hard for me to believe that in late January, as I was getting ready to attend what turned out to be my last in-person Oracle User Group event for the year (so far), that my greatest worry was whether the conflict between the USA and Iran might erupt into a shooting war while I was speaking in Tel Aviv at ilOUG2020. That seems like such a fond memory of relative normalcy when compared to once-in-a-generation events like:

a) a Presidential impeachment that further polarized USA politics;
b) a pandemic outbreak that the USA should have tackled and defeated handily;
c) record disruption of economic systems worldwide as a result of the pandemic;
d) major civic unrest after years of brutal police violence towards people of color, and many of us have said at last “Enough!”; and finally
e) increasing tensions between several major world powers.

Through all this drama, my wife and I have spent countless hours worrying about younger family members all in possible contact with COVID-19 through their work either indirectly or directly support health care in hospitals, nursing homes, and the Veterans’ Administration. We’ve sewn face masks for them, sent messages of encouragement and thanks, and made sure they knew we loved them and honored their commitment to their professions.

And what better time could I have personally chosen to move my career in a different direction?

In mid-April, I said a fond farewell to the team at Viscosity North America, as I’ve decided to concentrate more on volunteerism for causes like Hire Heroes USA as well as helping our local US Congressman during his efforts to secure a second term during the upcoming 2020 general election. In both cases, it’s been a great opportunity to develop some real-world use cases for Oracle Application Express (APEX), Visual Builder, and Machine Learning, which I’ve been writing about since early 2020. In my role as ODTUG’s Database Community Lead, it’s been exciting to help some excellent authors publish their knowledge on our TechCeleration portal. (Don’t hesitate to contact us if you’re interested in volunteering to share what you know!)

So while I don’t know what the rest of 2020 holds for us all, I’m going to stay positive, focused, and most of all, science-based. If there’s anything positive that the COVID19 pandemic has provided, it’s the ability to learn just how many of us will decide to listen to scientific experts, follow their advice, and work together to get through these challenges. 

Stay safe, stay healthy, and most of all, don’t forget to vote in upcoming elections. It’s the only way things get better for everyone else!

The Decade’s Almost Over. What Will 2020 Bring?

Dude … Where’s My Decade? If anything sums up my IT career’s arc since 2010, I’d say it’s that phrase. Somehow, I’ve managed to keep my head above water through the transition from HDD to SSD, from custom-built servers to Exadata Database Machine, and at least five different versions of the Oracle Database. Along the way, I’ve been fortunate to fulfill a personal goal of becoming an Oracle ACE Director for the the last half of that decade. That gave me the chance to meet IT folks on six different continents at dozens of Oracle conferences and OUG meetups.

Heck, I even got to chauffeur one of my heroes, Tom Kyte, to a Chicago Oracle User Group meeting!

As I enter my fifth decade in IT, I see 2020 as full of amazing opportunity, whether you’re a total Oracle newbie or a seasoned professional. Here’s where I think we’re headed:

Autonomy: The End of Tedium for “Helicopter DBAs” 

Based on my deeper experimentation with both ADW and ATP this past year – especially with the new Autonomous Dedicated option that offers elimination of “noisy neighbors” –  it’s apparent to me that the new role of Enterprise Data Architect can leverage that autonomy to further her career. With the announcement at Oracle OpenWorld 2019 of the upcoming launch of the Autonomous JSON database projected for early 2020, it sure looks like we’re going to be able to leverage key-value stores much more effectively than we have in the past.

The new Automatic Indexing features I’ve experimented with are just the tip of the spear. (You can download and then read more about my experiments in a recent white paper I published for Viscosity North America; if you are pressed for time, there’s a neat little video on that page too.) And I’m sure there are other autonomous features planned for later in 2020 that will finally free forward-looking DBAs from the tedium of normal day-to-day activities, especially just “keeping the lights on” for their databases. 

A/I and Machine Learning: Nearing a New Singularity?

Based on the massive interest in AI and ML I’ve observed at conferences this past year, I think we’re nearing a new singularity in data-driven decision-making. I’ve spent some time recently experimenting with the Oracle Machine Learning (OML) features already built into Autonomous DB; if you’ve got a spare five minutes, be sure to take a look at this short video that shows how easy it is to leverage those features with just a little bit of SQL and a few mouse clicks.

The best thing about these ML toolsets is that they’re already built into the Oracle Database, so I don’t necessarily need to learn a completely new set of analytic functions or ML algorithms to take advantage of them. I’m going to continue my research in 2020 on several fronts, particularly in learning how to better visualize hidden patterns within my data with Oracle Analytic Cloud (OAC). If you’re interested, check out this short demo on how easy it is to leverage OAC for data visualization.

The Converged Oracle Database

Though it’s taken some time to get there, it appears we’re headed towards a new data-centric paradigm: Let’s get our business users exactly the data they need, from exactly where it’s currently stored – either intra-RDBMS, or extra-RDBMS! – exactly when they need it, with the utmost concern for its security. From the discussions I’ve had with folks at Oracle like Jenny Tsai-Smith, Oracle’s new Converged Database strategy is focused precisely on achieving these goals, so expect to hear and see a lot more about related offerings in 2020.

It’s Vegas, Baby!

Finally, if you want proof that the 2020s are going to be quite different from the past decade, I offer up this evidence: Oracle OpenWorld 2020 will be held for the first time, not in San Francisco, but in Las Vegas instead. It’s going to be quite the ride, my friends and colleagues! I look forward to exchanging knowledge with you all at upcoming OUG meetings, COLLABORATE20, KSCOPE20, and of course OOW20. Stay safe, have a great 2019 holiday season, and Happy Computing!

A [Belated] Thanks to Oracle GroundBreakers

Yes, I know I’m just a bit late … but I’d like to take a brief break between testing out Autonomous Database intensely to shout out a big thank you to all the folks at Oracle and within the Oracle GroundBreakers community – ACEs, Java Champions, and GroundBreakers – that do a fantastic job of supporting the team of technical advocates that promote the technology running in the Cloud, on premises, and in between.

Halfway through my sixth year as an Oracle ACE Director, I’ve visited some amazing places on six continents, but ultimately, it’s about the user community we support through our efforts. I’ve had a very small part in something huge, and I couldn’t have contributed that without the support of the ACE program, my fellow technology advocates, and most of all the people I’ve tried to inspire through my articles, books, blogs, and presentations.

So here’s to all of us – a toast: May our ARCHIVELOG directories never fill up; may our APEX applications keeping APEXing; and may the only Java that goes sour be the coffee we’ve left in our travel mugs over a long weekend away from work.

Say Hello to Your New ODTUG Database Community Lead.

I’m excited to finally announce that I’ve accepted the volunteer position of Database Community Lead for ODTUG. I’ll be working closely with my friend, mentor, and colleague Danny Bryant, the current Database Community Liaison on the ODTUG Board, to bring relevant learning materials, articles, blog posts, and other social media.

The evolving role of the Oracle Database Administrator and the IT industry itself is undergoing a dramatic transformation in the age of Cloud computing, data science, Big Data, the Internet of Things (IoT), and increasingly rapid application development cycles through DevOps. My hope is that my new role with ODTUG will expand the realization among us “old school” DBAs that this oncoming sea change offers immense possibilities – as long as we’re ready and able to face up to the challenges that transition offers.

And if you’re interested in making a difference as the future unfolds – either by contributing a blog post, article, white paper, or short video – just reach out to me directly via Twitter, LinkedIn, or e-mail (jczuprynski@zerodefectcomputing.com). Those who have worked with me know that I’m a demanding but fair editor, and there’s few limits on what I will accept for content as long as it’s relevant, forward-looking, and accurate.

I’m going to focus on getting this message out to our ODTUG community in the coming weeks and months, so be sure to catch me at Oracle OpenWorld 2019 and future ODTUG events, especially KSCOPE20 in Boston next year, which as we know will be wicked cool!

May 21st. The Big Apple. Oracle CODE

I’m excited to announce that I’ve been selected for my first-ever Oracle CODE event. I’ll be presenting at the New York City event on May 21st at the Jacob Javits Center on my journey as an “old-school” Oracle DBA as I learned how to leverage the power of Oracle Application Express (APEX) to build a new set of applications based on a real-life use case: constructing mobile, flexible, responsive applications to enable voter canvassing for a US Congressional campaign.

If you’d like to get a preview of what I’ll be presenting, feel free to check out my ongoing journey via my recent four-part article series in IOUG SELECT entitled A DBA’s Journey to APEX, starting with Part 1: From Napkin to Application In a Single Weekend that explains how I constructed the original specifications and data model and built the original database schema for the application. All content is free courtesy of IOUG SELECT.

In the meantime, don’t forget to register for the event. I’ll see you in New York in just a few weeks! I’m looking forward to a completely new set of questions from my audience.

Old Dog, New Tricks: A Journey From DBA To APEX Developer

I officially started my career as an Oracle DBA in 2001, but my path to that role spans two previous decades working so many different projects, organizations, and teams that I’ve often forgotten what it was like to be an applications developer. I still remember the thrill I got the first time I wrote a SQL statement and actually got back a meaningful result; I recall the first time that I successfully built a new PowerBuilder application that pulled data right out of an Oracle database gave me a similar jolt of joy.

I recently returned to my application development roots when I decided to build a new set of applications using Oracle Application Express (APEX), and I used my experiences this past summer as a volunteer for a US Congressional campaign to construct a series of use cases and requirements for a mobile, flexible, responsive application for voter canvassing. Now thanks to my editors and colleagues at IOUG, I’ve had the opportunity to chronicle those experiences from my perspective as an “old-school” Oracle DBA with a new article series entitled A DBA’s Journey to APEX. So far that journey has three parts:

All content is free courtesy of IOUG SELECT. I hope you get as much out of reading them as I did out of writing them. Happy computing!

So OOW18 Is Done. Time To Get To Work.

Me, After OOW18.

I returned from OOW18 energized and ready to enter a new phase of my IT career: Instead of fulfilling a pre-sales role, for the first time in the last four-plus years I’ll be concentrating on researching deeply the capabilities of Oracle Database technology, both in the Oracle Public Cloud and for on-premises solutions. And it looks to me like this transition is happening at the best possible time, based on what I encountered at OOW18 last week.

Front and Center: Autonomosity

Here’s my impressions of just two key takeaways from that conference:

Autonomous Database isn’t going away. Larry Ellison doubled-down on Autonomous DB at both of his keynote sessions. I wasn’t surprised by that because as Larry says, Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP) are two of the more revolutionary offerings that Oracle has produced in some time. Yet in a way, they’re simply the logical progression of the “autonomosity” (to coin a phrase) of the Oracle Database and its powerhouse enterprise systems characterized most by the Exadata Database Machine.

I could definitely tell this development has quite a few of my Oracle DBA colleagues rattled, based on the standing-room-only crowds for just about any session whose title included the words the future of the DBA role. And maybe that’s good! IMHO, plenty of us have lost touch as to what being a DBA really entails; first and foremost, we should be focused on helping our customers – our development teams and business development units – build better applications and systems, and we can’t do that treating our role like it’s a job when it’s really a career – or, even better, a profession.

Automatic Indexing. Probably the most interesting new feature – coming in Oracle 19c, but entering beta testing as I write this! –  is the ability for ATP to decide precisely which SQL statements need precisely which indexes to run better. Maria Colgan presented the basics of Automatic Indexing at our ACE Director briefing and I’m hoping to get a chance to poke it with a stick in the coming weeks. But here’s the essence of this new feature: it’s exactly what we’ve been doing as DBAs whenever a query or application malperformed – except now, it’s happening based on tireless observation and dispassionate decision-making through machine learning and artificial intelligence.

Stars On the Horizon, Rising In Prominence

And here are two topics that are definitely rising in prominence, based on interest I observed at OOW18:

Chatbots. The new technology that Ellison demonstrated in his second keynote when he submitted an expense receipt for reimbursement to the Oracle Digital Assistant was nothing short of amazing. Personally, I really enjoy doing expense reports more than most people – and I hate doing expense reports! – but the new chatbot-enabled technology made short work of submitting the request.

And that’s just a simple example of what chatbots promise. Ellison also demonstrated the ability of Oracle’s latest generation of Fusion Cloud applications to seamlessly create a mini-data warehouse with a few simple mouse clicks, and even answer verbal questions about Oracle’s ongoing efforts to hire the best and brightest candidates.

I even got a chance to experiment with the Pepper chatbot at The Hub for a few hours – one of eight new exhibits that my ACE colleagues and I manned to demonstrate the future boundaries of these new technologies. I was surprised at the flexibility of her communication interface, but not yet convinced Pepper will be taking my place as a speaker anytime soon.

Blockchain. Sessions on anything with the word blockchain in the title were heavily attended as well. That’s not a big surprise, of course; this technology, once it comes to full fruition, will offer some fascinating capabilities, especially the ability to preserve and traverse the myriad twists and turns of complex financial transactions. My colleague and fellow ACE Robert van Molken from the Netherlands – who just published a 500+ page book on Oracle Blockchain – discussed several alternative applications of blockchains, and I’m planning on diving deeply into this nascent technology in 2019.