Gerger Consulting

Subscribe to Gerger Consulting feed
Gergerhttp://www.blogger.com/profile/17583607349097506453noreply@blogger.comBlogger198125
Updated: 13 hours 36 min ago

Your DBA Career in the Age of Oracle Cloud

Wed, 2017-10-18 11:48
Attend the free webinar by Oracle ACE Director Craig Shallahamer and learn how the Oracle Cloud and the Oracle 18c autonomous database changes your role as an Oracle DBA.
About the Webinar
The cloud is a change that all Oracle DBAs must face. The cloud is here stay, and that means Oracle DBAs need to adapt or get out of the game. It makes no difference if you are a new Oracle DBA or retiring in five years, before us is one of the most significant changes you will ever face.

In this webinar, you'll learn what has happened, what is happening, what you can expect, and what you can do today to ensure you are positioned to thrive in a cloud world full of surprising and exciting opportunities.

Register at this link.
Categories: Development

Webinar: Version Control for the Oracle Database

Wed, 2017-09-20 14:36

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 development
  • Execute commonly used version control commands in the Oracle Database and how executing these commands can change the source code in the Oracle Database automatically.
  • Get the differential script between two Oracle Database source code repositories automatically.
  • Minimize any errors such as accidental overwrites of packages, procedures and functions.
  • Prevent anyone from editing source code in the database outside of a version control system
  • Have multiple teams change the same logical packages, procedures and functions and merge their changes automatically.

About the Presenter:

Yalim Gerger is the founder of Gerger, the company behind Formspider, the application development framework for PL/SQL Developers. Gerger’s new product Gitora helps Oracle developers manage their source code with Git just like any developer using a file based programming language.

Yalim is one of the founding members of Turkey Oracle User Group and a frequent speaker at conferences and webinars.





Categories: Development

Version Control for Oracle Database

Thu, 2017-09-07 12:05
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.

Categories: Development

How Does Oracle's Core RDBMS work?

Tue, 2017-09-05 13:19

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-tree index" actually means.
  • What Oracle does when you give it a SQL statement to run.
  • How Oracle ensures you see the correct data, even as it is changing.

About the Presenter:


Martin Widlake is an independent Oracle consultant based in the UK. An Oracle ACE Director and member of the OakTable Network, he regularly presents internationally on Oracle performance, database design and PL/SQL. He co-wrote the book “Real World SQL and PL/SQL . Martin has provided consultancy to several large financial organisations and FTSE 500 companies as well as much smaller companies. For several years he was the database services manager for the UK side of the Human Genome Project, combining his I.T. skills with his background in Genetics.
Categories: Development

Free Webinar by Craig Shallahamer on Oracle Performance

Mon, 2017-08-21 14:28
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 derive multiple solutions.

Categories: Development

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

Tue, 2017-08-08 08:33
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.


Categories: Development

Oracle 12c Release 2 Summer Event Live Stream

Wed, 2017-08-02 08:14
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 - 12:45 Basics of Bare Metal Cloud Service Offering.
    Nitin Vengurlekar discusses the Basics of the BMCS offering and features.
Categories: Development

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

Tue, 2017-07-18 07:27
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.
Categories: Development

Agile Development with PL/SQL

Mon, 2017-06-19 13:12
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.
Categories: Development

Version Control for PL/SQL

Wed, 2017-06-07 14:23

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. :-)


Categories: Development

DevOps and the Agile DBA

Wed, 2017-05-31 13:38
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, Repeat
  • Test Until Your Five Year Old Can Do It
  • Human 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 DevOps, virtualization and how to make the DBA pivotal to DevOps success.

Sign up for the free webinar.

About the Presenter:



Kellyn Pot’Vin-Gorman is a member of the Oak Table Network and an Oracle ACE Director alumna. She is the Technical Intelligence Manager for the Office of CTO at Delphix, a company recognized for it's impressive virtualization and data masking environment capabilities. Kellyn is known for her extensive work with multi-database platforms, cloud migrations, virtualization, the command line interface, environment optimization tuning, automation and architecture design. Her blog, http://dbakevlar.com and social media activity under her handle, DBAKevlar is well respected for her insight and content.

Registration is free but space is limited.
Sign up now.
Categories: Development

Smart Database Architecture for Software Development

Wed, 2017-05-17 13:00

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 moving business logic out of the database benefits performance and scalability.



About the Presenter

Toon has been part of the Oracle eco-system since 1987. He is currently a member of Oracle's Real World Performance Team. The RWP-team troubleshoots application performance issues in and around the Oracle Database. The way applications currently use (or rather, abuse) the DBMS, is often at the root of these performance issues. Prior to joining the RWP team, Toon has been mainly involved in database application development. His special interests are: architecting applications for performance and scalability, database design, and business rules / constraints modeling. He is a long-time champion of using the database in a smart way, i.e. using the database as a processing engine.

Registration is free but space is limited.


Categories: Development

Arup Nanda on Big Data

Thu, 2017-05-04 14:45
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.
Categories: Development

Apache Spark for Oracle Developers

Tue, 2017-04-11 01:27
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 Lokic and 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 technology
  • What makes Spark so fast
  • How to use the rich set of Spark API’s to design and run your ETL jobs
  • Apache Spark streaming capabilities for near real-time updates and its role in Big Data processing scenarios
  • Structured Streaming, a scalable and fault tolerant stream processing engine which makes near real-time processing scenarios even easier
The webinar is free but space is limited.

Categories: Development

Best Way to Write SQL in Java

Wed, 2017-03-15 01:17

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.

Categories: Development

How to Upgrade an Oracle-based Application without Downtime

Wed, 2017-02-08 11:32
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.


Categories: Development

Version Control for PL/SQL

Tue, 2017-01-24 12:14
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.


Categories: Development

Demo: Version Control for PL/SQL in 30 Minutes

Mon, 2017-01-16 12:38
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:

Categories: Development

PostgreSQL for Oracle Developers and DBA's

Tue, 2017-01-03 16:16
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.

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 for PostgreSQL.org). He is also a Founder, and current Director of United States PostgreSQL. Lastly, he is a core member of PgConf US.

About The Webinar:

Even if your organization is an Oracle customer. there are many use cases where PostgreSQL can be an affordable alternative to the Oracle Database. In this webinar, Joshua will discuss the in and outs, ups and downs of migrating from Oracle to PostgreSQL.

The presentation will include PostgreSQL differences, limitations and discussion of commercial needs such as custom features and support.

Attendees should plan on walking away with a comprehensive understanding of the differences of the two products and how to make PostgreSQL work best for their projects.

The webinar is free but space is limited.

Categories: Development

Success Story: Version Control for PL/SQL

Mon, 2016-12-26 15:43
It’s been a little over three months since we released Gitora 2.0 and the first success stories have started to emerge. Here is one of them:


Rhenus Logistics, the leading logistics company from Germany uses Gitora to manage their Oracle Database.
Problem
Rhenus IT uses both Java and PL/SQL to serve their users and customers. They have a team of about 10 PL/SQL developers. The team manages more than 20,000 database packages, views, functions, procedures, object types and triggers spread over 30+ database schemas.
Rhenus IT wanted to move to a continuous delivery environment in which they can be more agile and deliver solutions to the business faster. Managing the PL/SQL code was the hardest piece of the puzzle.
Solution
After experimenting with other solutions in the market, Rhenus decided to move forward with Gitora.


Gitora enabled Rhenus Developers to:
  • Use Git, the prominent open source version control system used by millions of developers.
  • Move their database code between development and various staging databases automatically.
  • Move code between source and target databases very fast because Gitora only executes differences between source and target databases, without comparing the code bases in both databases first (which can be very time consuming).
  • Enforce check-in, check-out of database objects at the database level.
  • Automate build process for the database code using Gitora API’s.
  • Implement an affordable continuous delivery solution compared to alternatives.
Michiel Arentsen, the System Architect at Rhenus who implemented the solution at Rhenus has started an excellent blog in which he writes about his Gitora implementation. We highly recommend you to check it out. Below are the list of blog posts he wrote which should be very useful to anyone who is currently implementing Gitora at his/her company:
Categories: Development

Pages