Tag Archives: DBA

Is the DBA Dead?

No, he’s busy migrating to the Cloud!

No, he’s busy modelling data!

No, he’s busy integrating!

No, he’s still alive and kicking!

easy-server-manageability-in-oracle-data-base-administrator

Are DBA’s really dead, or have they shifted from one organization to another? We see posts and articles with regards this same topic as to whether the DBA is dead, whether he/she is still relevant in today’s world.

I was at a customer meeting and they were adopting a 100% cloud strategy, they all but had one DBA left in the organization as the burden from managing the legacy systems had shifted to the cloud vendors.

Let’s start with breaking down what a DBA would be doing today; a day in the life of a DBA.

A typical set of DBA tasks would include, lifting and shifting databases for off-line reporting, setting up high availability clusters, implement security, maintain integrity, perform upgrades, backups and not to forget performance tuning and troubleshooting.

Continue reading Is the DBA Dead?

Advertisements

WEBINAR: Real-Time Data Ingestion and Streaming Analytics with Oracle and Hortonworks

November 24th, 2016 at 10am BST / 11am CEST

REGISTER HERE

Organizations today are looking to exploit modern Data Architectures that combine the power and scale of Big Data Hadoop platforms with operational data from their Transactional Systems. In order to react to situations in an agile manner in real-time, low-latency
access to data is essential.

Hortonworks and Oracle can provide comprehensive solutions that allow organisations to respond rapidly to data events.

https://i2.wp.com/hortonworks.com/wp-content/uploads/2014/09/Oracle_MDA.png

REGISTER HERE

During this webinar we will cover:

  • How Oracle GoldenGate empowers organisations to capture,route, and deliver transactional data from Oracle and non-Oracle databases for ingestion in real-time to HDP :registered:.
  • How GoldenGate complements HDF providing optimised delivery to Hadoop targets such as HDFS, Hive, Hbase, NoSQL, Kafka, to support customers with their real-time big data analytics initiatives.
  • How Oracle GoldenGate enables uses cases for analysis of data in motion

Attend this webinar to learn how Hortonworks and Oracle can help you with your real-time big data analytics and streaming initiatives!

REGISTER HERE

The Always-On Business Requires Oracle GoldenGate (OGG)

By Sandrine Riley-Oracle on Oct 05, 2016

“Always-on, data-driven, and real-time have truly become table stakes for enterprises in today’s global economy. The challenges for getting a consistent, up-to-date picture are compounded as enterprises embrace cloud deployments.” Tony Baer states it plainly.

To succeed in today’s competitive environment, you need real-time information – it really is that simple. This requires a platform that can unite information from disparate systems across your enterprise without compromising availability and performance. Oracle GoldenGate provides real-time capture, transformation, routing, and delivery of database transactions across heterogeneous systems. Oracle GoldenGate facilitates high-performance, low-impact data movement with low latency to a wide variety of databases and platforms while maintaining transaction integrity – and that is the key. With the help of Ovum’s Tony Baer, we have further explored how businesses value their data in this changing environment. Businesses need to continuously innovate, but execute at the same time. This whitepaper explores the realities of today, and those coming tomorrow. Real-time is crucial and an essential ingredient to driving key advances in everyday business.

Image result for Oracle GoldenGate

Read this newly released whitepaper for key insights into how:

  • Real-time is driving service-level expectations, even for offline workloads
  • With enterprises embracing hybrid cloud deployment, the need to keep data in sync, in real time between cloud and on-premise systems becomes table stakes
  • Real-time data integration is not simply a technology argument; it is essential to the ability to execute faster, which can lead to bottom-line cost reductions and top-line creation of new business and revenue opportunities
  • Supporting real-time business requires a data-replication technology that is flexible, scalable, performant, and platform-independent, with little to no overhead.

Tony interviews a handful of Oracle GoldenGate customers, and found valuable insights into the uniqueness and flexibility Oracle GoldenGate provides to today’s market.

To learn more about Real-Time Data Integration & Replication – Oracle GoldenGate – visit us here. This short video: Chalk Talk: Boost Big Data Solutions with Oracle GoldenGate might be of interest as well.

We hope you find this research exciting! Click for the WHITEPAPER.

Original Post

About the Author:

Sandrine Riley

Product Management – Data Integration Solutions at Oracle

Sandrine Riley

Webinar: Register Now for “Help! My Indexes Need a Tune-Up!”

We have all have spent a lot of time tuning indexes – it can be frustrating and time consuming. Adding indexes often seems like the right solution at the time – until no good result is achieved.

Join Martin Hubel, Database Consultant- DBA Evangelist, and Embarcadero’s Scott Walz as they discuss best practice strategies and techniques for avoiding index tuning pitfalls.  Learn and see the best techniques to tune and optimize indexes.

Register for the webinar to learn:

  • Which indexes to drop
  • 3 Main “Truths” when tuning applications
  • How to avoid index tuning from going awry

Tuesday July 29, 2014
7:00 AM PDT / 9:00 AM CDT / 10:00 AM EDT
11:00 AM PDT / 1:00 PM CDT / 2:00 PM EDT

Webinar presentation by Martin Hubel – Database Consultant & DBA Evangelist, MHC Inc.

About the presenters:

Martin Hubel – Database Consultant & DBA Evangelist, MHC Inc.

Martin Hubel has both extensive and intensive experience in database design, application architecture, and system administration for relational database management systems.  For the past 20 years, Martin has consulted and taught more than 400 clients worldwide to use database management systems more effectively.

Scott Walz

Scott Walz has more than 20 years of experience in the area of database development and currently serves as the Director of Software Consultants for Embarcadero Technologies.  Prior to joining Embarcadero 12 years ago, Scott served as a development lead for Louisville Gas & Electric. He holds a bachelor’s degree in computer information systems from Western Kentucky University.

DB Optimizer – Database Performance and SQL Tuning

DB Optimizer – Database Performance and SQL Tuning

DB Optimizer is a database optimization tool that maximizes database and application performance, reliability, and availability by profiling, tuning, and load testing SQL code.

DB Optimizer – Introduction

Part 1 of 5 | 3 min 46 sec
Get started with a brief introduction to DB Optimizer’s features and capabilities, an overview of the GUI and how to get started by adding data sources.

DB Optimizer – SQL Editing

Part 2 of 5 | 1 min 29 sec
Take a look at the SQL editing capabilities in DB Optimizer’s IDE. Organize the result sets, scroll through value and rewrite queries.

DB Optimizer – Tuning

Part 3 of 5 | 10 min 24 sec
Learn how to use DB Optimizer to tune SQL. Generate cases and perform detailed analysis with visual cues to quickly optimize SQL code. Also, watch how Visual SQL Tuning gives DBAs an advantage when it comes to tuning!

DB Optimizer – Profiling

Part 4 of 5 | 5 min 16 sec
See DB Optimizer profile databases to quickly identify bottlenecks and other problem areas. This video shows how DBAs can capture profiling details, address wait times and report via XML files.

DB Optimizer – SQL Loading

Part 5 of 5 | 3 min 54 sec
Watch the demonstration around conducting load testing for performance optimization. Load testing helps makes sure any SQL code is able to handle the rigors of the most hectic database environments.

DBArtisan, the tool of choice for DBA’s around the world.

Embarcadero® DBArtisan® is the premiere database administration toolset helping DBAs maximize availability, performance and security across multiple DBMSs. This essential toolset consistently boosts productivity, streamlines routine tasks, and reduces errors. DBArtisan provides an easy-to-use, single view across all enterprise data sources featuring comprehensive capabilities for all core data management tasks.