Posts

Showing posts from 2017

Webinar: Version Control for the Oracle Database

Image
Version control of tables and PL/SQL code in the Oracle Database has always been challenging. Database programmers lack the tools that make version control easy for developers who code with file based programming languages such as Java and JavaScript. In fact, this is one of the primary reasons why large software teams avoid schemas and writing code in the database.

In this presentation you will learn how Gitora 3 can help you use Git, the prominent open source version control software, to manage every database object including tables and PL/SQL source code.

Sign up now.


Every attendee will receive a discount offer to purchase Gitora 3 developer licenses. :-)

About the Webinar:

In this presentation you’ll learn how to:

Manage any database object including tables and packages in Git.Implement agile development best practices for database developmentExecute commonly used version control commands in the Oracle Database and how executing these commands can change the source code in the Orac…

Version Control for Oracle Database

Image
Today, we’re happy to announce the general availability of Gitora 3. Gitora 2 enabled developers to manage database objects that support the CREATE OR REPLACE command, namely PACKAGES, PROCEDURES, FUNCTIONS, TRIGGERS, VIEWS, SYNONYMS and TYPES in a Git repository. (In Gitora terminology, we call these “Soft Objects”). Gitora 3 goes a step further and enables developers to manage every database object in an Oracle Database with Git even if the object does not support the CREATE OR REPLACE command. (In Gitora terminology, we call these “Hard Objects”.) Specifically, Gitora 3 allows developers and DBA's  to manage TABLES, INDEXES, SEQUENCES, CONSTRAINTS, TABLESPACES, MATERIALIZED VIEWS and every other schema or non-schema objects with Git.
Learn more about how Gitora 3 helps developers, DBA's, DevOps people and managers to improve their database development workflow at this link.

How Does Oracle's Core RDBMS work?

Image
Attend the free webinar by the Oracle ACE Director Martin Widlake and learn how Oracle works under the hood.
About the Webinar: Despite the complexity and capability of the Oracle database, at it's heart there are a relatively small number of key activities and processes. If you understand them, you will get a lot more out of the database and advanced topics make a lot more sense. In this presentation I explain the key things the database does and how they work together. If you know what a SELECT statement is, you will understand this talk. And by the end of it, you will know some things that even many experienced developers and DBAs don't know.
In this webinar, you will learn: The two ways Oracle reads data from disc and how it writes it back.That REDO is actually the most important part of the database. What happens when you COMMIT.Why Oracle data blocks are key to the buffer cache.What a "Consistent Get" really is.Why indexes are so powerful and what "balanced B…

Free Webinar by Craig Shallahamer on Oracle Performance

Image
Attend the free webinar presented by the Oracle ACE Director Craig Shallahamer and learn how to choose the best strategy when analyzing a Oracle Database performance problem.
About The Webinar.  The Oracle Database provides amazing application performance opportunities. But sometimes there are still unhappy users. So, what is your best analysis strategy? As Oracle DBAs we have two fundamental strategies: time based and active session sample based (ASH). Knowing their differences and how to exploit them gives you the optimization edge. In this webinar, I introduce each strategy, highlight how they work, contrast their differences and demonstrate live each strategy. This webinar will teach you how to begin your analysis in the best direction. Takeaways and value: You will know the differences and advantages between an ASH and AWR (time-based) analysis strategy.You will know which analysis is best in any given situation.You will learn how to use an AWR report to analyze performance and der…

LIVE TODAY! (August 8th) Six Hour Event on New Features of Oracle 12cR2

Image
Six hour live stream of two ACE Directors, Rich Niemiec and Nitin Vengurlekar talking about their favorite new features of Oracle 12c Release 2. We are at 332 signups already. Register at this link.


Oracle 12c Release 2 Summer Event Live Stream

Image
Join our live stream on August 8th and watch two ACE Directors, Richard Niemiec and Nitin Vengurlekar talk about their favorite new features of Oracle 12c Release 2, Oracle DBaaS, RAC, ASM, partitioning and encryption. Register at this link.


Below is the agenda of the live stream. All times are in PST:


7:30 - 8:30 Understanding 12cR2 Grid Infrastructure, RAC, and ASM/ACFS.
In this session, Nitin Vengurlekar will take a deep-dive into the new features of 12cR2 Grid Infrastructure, RAC, and ASM/ACFS.8:30 - 9:30 Oracle 12cR2 Multi-Tenant Options.
Learn to leverage all the latest features of Oracle 12cR2 that enable the journey to a private, hybrid, or public cloud environment with Nitin Vengurlekar.10:00 - 11:00 Taking advantage of Oracle 12cR2.
In this session, Rich Niemiec will tackle Partitioning, encryption, object names, and Monitoring with OEM/APM.11:00 - 12:00 Oracle Cloud Structure on 12c Release 2.
Learn how to set up your first Cloud database and DBaaS with Rich Niemiec.12:00 - 1…

Cloud Wars: Who Will Win the Battle for IT's Future?

Image
Attend the free webinar by Oracle's former Chief Communications Officer Bob Evans and learn how to prepare a better cloud strategy for your organization.
As cloud computing surges into the mainstream and becomes the backbone of enterprise IT, hundreds of cloud vendors are fighting for customer dollars. Which ones are framing their cloud services in terms of what businesses want and need, versus pounding their chests over how wonderful their technology is? Will the big incumbents such as IBM, SAP and Oracle be able to pivot to the cloud with enough capability and urgency to meet the intense requirements of modern digital businesses? Which top cloud vendors are positioning cloud in a silo, and which are blending cloud vision with AI, cognitive, machine learning, and more? This discussion will address these and other high-priority issues for IT buyers and decision-makers. Registration is free but space is limited. Sign up now.

Agile Development with PL/SQL

Agile Development gives us the ability to work on multiple features at the same time and change which ones to ship at any point in time, quickly. This might be challenging for PL/SQL teams to accomplish, to say the least. This short video shows how Gitora, version control tool for PL/SQL, helps Oracle PL/SQL developers solve this problem.





If you prefer reading a step by step guide instead of watching a video, please click here.

Version Control for PL/SQL

Image
We are hosting a live webinar for IOUG on June 8th at 10:00am PST. Attend and learn how you can manage your PL/SQL source code with Git. We have a new cool demo to show off. :-)

Sign up at this link.

The sign up page as 12 mandatory questions. :-) We are sorry for the inconvenience. We had no control over it. But please bear with us. Bite the bullet. Take a leap of faith. It'll be worth your time. We promise. :-)


DevOps and the Agile DBA

Image
The esteemed ACE Director alumna Kellyn Pot'Vin Gorman is hosting our next webinar!

Attend the free webinar by Kellyn on June 13th and learn how agile best practices and virtualization can help you become better at DevOps.


About the Webinar:
This session discusses common database challenges and how they can be solved with newer DevOps practices without impacting the DBAs “safe zone”.

Development, testing, provisioning, patching, upgrading and managing will become easier with agile tools, virtualization and collaboration.

The take-aways from this session are to embrace DevOps basics with a “DBA twist” such as: Develop, Rinse, RepeatTest Until Your Five Year Old Can Do ItHuman Intervention Creates Human Error- Automate EVERYTHING.How the shorter development cycle build business success.How the DBA can do more with less.Discover the power of virtualization and agile development practices providing more value to even the most senior database expert.

We’ll demo different scenarios surrounding…

Smart Database Architecture for Software Development

Image
We are incredibly excited to announce that the amazing Toon Koppelaars from Oracle Real World Performance Team is hosting our next webinar: Smart Database Architecture for Software Development. Register at this link.





About the Webinar

Is the database a processing engine or a persistence layer? In this presentation we'll first go through a bit of history demonstrating how the database has been used in the past 30 years: at times it was a processing engine, and at other times it was just a persistence layer. 

Having witnessed many application development projects, we are convinced that the database ought to be used as a processing engine. The persistence layer approach, where all business logic is implemented outside the database has serious drawbacks in the areas of initial application development, ongoing maintenance, and most notably in the area of performance and scalability.

We'll discuss these drawbacks, in particular the last one: We'll debunk once and for all that movin…

Arup Nanda on Big Data

Image
Attend our free webinar and learn from the legendary Oracle DBA Arup Nanda about the Big Data ecosystem and how it compares to Oracle solutions.

Register at this link.


About the Webinar

Big Data is the future of database computing and knowing about it not just a luxury you can avoid anymore; it's necessary for survival and growth. But Hadoop, Spark, Hive, Map/Reduce, Flume - if these terms hit you more often than you have the time to pause and think about them, look no further. Learn about these and more in this informative session on this Big Data components explained from the perspective of an Oracle professional, how they are same or different and how they compare with RAC or parallel query.

Register today.

Apache Spark for Oracle Developers

Image
In the last few years, business problems that have been traditionally solved using databases are now being solved using other technologies. Apache Spark is one of the emerging technologies which is used for large scale data processing.

Attend the free webinar by Ivan Lokicand learn how you can use Apache Spark in Big Data applications.  


About the Webinar: Apache Spark is a general computing engine designed for large-scale data processing. Many well-known companies use it to process petabytes of data on 8000+ nodes with long running jobs measured in weeks.

In this webinar, you will learn about: Apache Spark and how Spark relates to (traditional) Hadoop MapReduce technologyWhat makes Spark so fastHow to use the rich set of Spark API’s to design and run your ETL jobsApache Spark streaming capabilities for near real-time updates and its role in Big Data processing scenariosStructured Streaming, a scalable and fault tolerant stream processing engine which makes near real-time processing scena…

Best Way to Write SQL in Java

Image
Many of us struggle writing SQL in Java. ORM tools such as Hibernate often generate SQL statements that result in poor application performance. Surely, there must be a better way to write SQL in Java.



Attend the free webinar by Java Champion Lukas Eder to learn the best way to write SQL in Java. Find out how you can use SQL as a type safe domain specific language in Java.

Sign up for the free webinar.

How to Upgrade an Oracle-based Application without Downtime

Image
One of most common reasons IT departments avoid database development is the belief that an application upgrade in the database causes downtime. However, nothing can be further from the truth. On the contrary, Oracle Database provides one of the most bullet proof ways to upgrade an application without any downtime: Edition Based Redefinition (EBR)

EBR is a powerful and fascinating feature of Oracle (added in version 11.2), that enables application upgrades with zero downtime, while the application is actively used and operational.

Attend the free webinar by Oren Nakdimon on February 16th to learn how to use EBR, see many live examples, and get tips from real-life experience in a production site using EBR extensively.

The webinar is free but space is limited.

Sign up for the free webinar.


Version Control for PL/SQL

Image
Let's get this straight:

It is possible to put PL/SQL in proper version control. It is possible to have developers work on the same logical code unit (package, procedure, function etc...) at the same time without co-ordinating first. It is possible to merge these changes at a later time automatically. It is possible to eliminate all the errors resulting from manual preparation of deployment scripts. It is possible to build an automated continuous delivery pipeline for PL/SQL.
If you'd like to know how, attend our free webinar. Register at this link.


Demo: Version Control for PL/SQL in 30 Minutes

Hi Everyone! We prepared a 30 minute demo video to show you how Gitora can help you manage your PL/SQL code base. Check it out below:

PostgreSQL for Oracle Developers and DBA's

Image
PostgreSQL is not very well known among Oracle developers and DBA’s. Yet, the skill set of an Oracle developer or a DBA is easily portable to PostgreSQL. There is no one better than Joshua D. Drake to teach you PostgreSQL and show you how you can migrate from Oracle to PostgreSQL. Attend Joshua's free webinar and earn how you can benefit from PostgreSQL, the leading free and open source alternative to the Oracle Database. Sign up for the webinar
About The Presenter:
Joshua D. Drake is an Open Source Consultant specializing in Linux and PostgreSQL. He has been consulting on PostgreSQL since 1996. Throughout his PostgreSQL career he has performed a variety of functions within the community including submitting a patch or two, releasing an O'Reilly book on PostgreSQL as well as being part of the sysadmins and advocacy teams. Further he ran a biannual conference series dedicated to PostgreSQL between the years of 2007 - 2011. He is former Director (2008-2016) for SPI (the non-profit fo…