Posts

Get Organized With My Day-by-Day Guide For #oow18

Image
It’s  not long until the doors open at the Moscone Center in San Francisco for the biggest and most exciting tech conference in the calendar. Looking at the online content catalog it’s hard to know where to start because there are so many sessions and just not enough time!Which is here my Must-See Guide comes to the rescue. It lists all the most important data warehouse, big data, analytics, machine learning sessions and labs at #oow18 is now available as a comprehensive Day-by-Day version:My Day-by-Day guide for OpenWorld 2018 is available in both old-fashioned PDF format as a free download from here and the more useful Apple Book format as a free downloadfrom here(open this link in a browser and then click on the blue “View in iBooks” button below the cover-picture).As usual, all feedback is welcome and if I have missed a session or a hands-on lab that you think should be included in this guide then send me a quick email with the details: keith.laker@oracle.com.Have a great OpenWorl…

Get Organized With My Must-See Google Calendars for #oow18

Image
There are so many sessions at this year’s OpenWorld it’s hard to know where to start when trying to pick which sessions to attend! To help you get your personal calendar organized and totally focused on THE most important sessions here is my pick of the very best sessions and labs that you definitely won’t want to miss! Simply cut & paste the links below into your calendar app and then sit back and relax because all you need to do next is turn up at Moscone and enjoy the best tech conference ever :-)...so if you have a calendar app on your computer then just use the iCal links to subscribe to my calendars. Your calendar app should allow you to color-code each calendar to make life easier and more colourful!For data warehousing and cloud-focused sessions+labs use these links:iCal format: https://calendar.google.com/calendar/ical/31pd442io213d7n1o44rstlqno%40group.calendar.google.com/private-5fc5e75a3b08e9ab2f2f0a3a16b839ef/basic.icsWeb page: https://calendar.google.com/calendar/emb…

Autonomous Data Warehouse is LIVE!

Image
That’s right: Autonomous Data Warehouse Cloud is LIVE and available in the Oracle Cloud.
ADWC Launch Event at Oracle Conference Center We had a major launch event on Thursday last week at the Oracle Conference center in Redwood Shores which got a huge amount of press coverage. Larry Ellison delivered the main keynote covering how our next-generation cloud service is built on the self-driving Oracle Autonomous Database technology which leverages machine learning to deliver unprecedented performance, reliability and ease of deployment for data warehouses.

As an autonomous cloud service, it eliminates error-prone manual management tasks and, most importantly for a lot readers of this blog, frees up DBA resources, which can now be applied to implementing more strategic business projects.

The key highlights of our Oracle Autonomous Data Warehouse Cloud include:

Ease of Use: Unlike traditional cloud services with complex, manual configurations that require a database expert to specify data d…

Demoing ADWC+OAC Querying Massive Data Volumes

Image
If you missed all the major announcements from OpenWorld 2017 about Oracle Autonomous Data Warehouse Cloud then take some time to review this blog post Review of Big Data Warehousing at OpenWorld 2017 - Now Available. Take a look a Chapter 2 - YOUR ORACLE DATA WAREHOUSE IN THE AUTONOMOUS CLOUD.Once you have fully digested the powerpoint presentations and videos included in Chapter 2 you will then be ready to watch this exciting new video:Below is an excerpt of Thomas Kurian’s Keynote session at Oracle Cloud World in Feb 2018. In this video, George Lumpkin, VP of Product Management, shows how easy it is to create an new data warehouse inside the Oracle Autonomous Data Warehouse Cloud, how fast and elastic it is and how quick and easy it is to integrate with other parts of Oracle's Cloud portfolio - in this case Oracle Analytics Cloud.This demo will take you from zero-to-dashboard in around 10 minutes! For the full-length video of Thomas Kurian's keynote at Oracle CloudWorld, Ne…

SQL Pattern Matching Deep Dive - the PDF Version

Image
Those of you with long memories might just be able to recall a whole series of posts I did on SQL pattern matching which were taken from a deep dive presentation that I prepared for the BIWA User Group Conference. The title of each blog post started with SQL Pattern Matching Deep Dive...and covered a set of 6 posts:

Part 1 - Overview
Part 2 - Using MATCH_NUMBER() and CLASSIFIER()
Part 3 - Greedy vs. reluctant quantifiers
Part 4 - Empty matches and unmatched rows?
Part 5 - SKIP TO where exactly?
Part 6 - State machines

There are a lot of related posts derived from that core set of 6 posts along with other presentations and code samples. One of the challenges, even when searching via Google, was tracking down all the relevant content.

Therefore, I have spent the last 6-9 months converting all my deep dive content into a book and I have added a lot of new content based discussions I have had at user conferences, questions posted on the developer SQL forum, discussions with my development…

SQL Pattern Matching Deep Dive - the book

Image
Those of you with long memories might just be able to recall a whole series of posts I did on SQL pattern matching which were taken from a deep dive presentation that I prepared for the BIWA User Group Conference. The title of each blog post started with SQL Pattern Matching Deep Dive... and covered a set of 6 posts:


Part 1 - OverviewPart 2 - Using MATCH_NUMBER() and CLASSIFIER()Part 3 - Greedy vs. reluctant quantifiersPart 4 - Empty matches and unmatched rows?Part 5 - SKIP TO where exactly?Part 6 - State machines

There are a lot of related posts derived from that core set of 6 posts along with other presentations and code samples. One of the challenges, even when searching via Google, was tracking down all the relevant content.

Therefore, I have spent the last 6-9 months converting all my deep dive content into a book - an Apple iBook. I have added a lot of new content based discussions I have had at user conferences, questions posted on the developer SQL forum, discussions with my deve…

Review of Big Data Warehousing at OpenWorld 2017 - Now Available

Image
Did you miss OpenWorld 2017? Then my latest book is definitely something you will want to download! If you went to OpenWorld this book is also for you because it covers all the most important big data warehousing messages and sessions during the five days of OpenWorld.

Following on from OpenWorld 2017 I have put together a comprehensive review of all the big data warehousing content from OpenWorld 2017. This includes all the key sessions and announcements from this year's Oracle OpenWorld conference. This review contains the following information:

Welcome - an overview of the contents.

Let’s Go Autonomous - containing all you need to know about Oracle’s new, fully-managed Autonomous Data Warehouse Cloud. This was the biggest announcement at OpenWorld so this chapter contains videos, presentations and podcasts to get you up to speed on this completely new data warehouse cloud service.

Keynotes - Relive OpenWorld 2017 by watching the most important highlights from this year’s OpenWor…