BrandPost: How Database Administrators Can Keep (or Improve) Their Jobs in the Cloud Era

Kristin Burnham - CIO

Database administrators (DBAs) have been the gatekeepers to a business’s most valuable asset: its data. They design, implement, and maintain the business’s database systems; establish policies and procedures for managing, securing, and maintaining them; and train employees in their management and use. Ask Oracle CEO Mark Hurd, who in May announced a new cloud-based autonomous database. If all of that moved to the autonomous database, that number would change to zero.”

BrandPost: How Database Administrators Can Keep (or Improve) Their Jobs in the Cloud Era

Kristin Burnham - CIO

Database administrators (DBAs) have been the gatekeepers to a business’s most valuable asset: its data. They design, implement, and maintain the business’s database systems; establish policies and procedures for managing, securing, and maintaining them; and train employees in their management and use. Ask Oracle CEO Mark Hurd, who in May announced a new cloud-based autonomous database. If all of that moved to the autonomous database, that number would change to zero.”

It’s About Location: 4 Keys Every Database Administrator Needs For Smart Data Discovery

The New Stack

John is responsible for developing and evangelizing solutions-based stories for Quest’s extensive portfolio of database products worldwide. He has been with Quest Software since 2000, working in database design, development and deployment.

The Impact of DevOps on Database Monitoring and Management

DevOps.com

The rise of DevOps has broken down silos and brought database administrators (DBAs) and application developers closer together to deliver software faster and in a more agile manner. The post The Impact of DevOps on Database Monitoring and Management appeared first on DevOps.com.

DevOps 103

Database Administration: Oracle’s Exceptional Journey

Datavail

To Larry Ellison , one of the founders of the ‘Oracle’ company, the label was an apt one for the relational database product it had developed in 1977. From that original Oracle database administration product to today’s powerful Oracle 19c, the software giant has continued to lead the way in harnessing and managing data so it can solve almost any sized problem for virtually any entity. Retirement Coming Soon: Oracle Database 11.2

Tech Careers of the Future

I'm Programmer

Programming Funny Images Programming Jokes Database Administrator machine learning engineer Network administratorThe post Tech Careers of the Future appeared first on I'm Programmer.

Removing Advanced Compression from Large Tables with DBMS_REDEFINITION

Datavail

Created separate undo tablespace for process, to prevent impacting other database transaction undo usage. Blog advanced compression compression tables database administration DBA Oracle database Oracle DB

Do I Still Need a DBA When I Move to MongoDB Atlas?

Datavail

Many people read about Databases as a service (DBaaS) and think “My prayers are answered!” ” or “I will have no need for additional database help” But is this true? You neither “own” the infrastructure, nor the database engine.

SOC Audit Results

Apps Associates

Apps Associates, LLC is proud to announce the successful completion of its annual Type 2, SOC 1 and Type 2 , SOC 2 examinations, for its Remote Database Administration and Hosted Managed Services. The resulting reports, issued by Schellman & Company, LLC, cover the period of January 1, 2018 through December 31, 2018. The SOC … Continue reading "SOC Audit Results". The post SOC Audit Results appeared first on Apps Associates. Corporate soc audit reports

Cloudera Navigator Optimizer Graduates from Beta, is Now Generally Available

Cloudera Engineering

Cloudera Navigator Optimizer enables database architects and database administrators (DBAs) to gain in-depth understanding of their SQL workloads running in data warehouse environments or on Apache Hadoop.

4 Ways to Optimize Database Operations

Datavail

Much of this information is structured data that must be contained in highly complex databases, perhaps reaching hundreds of tables and dozens of attributes for each one. In this article, we’ll explore four ways to optimize your database operations. Improving Database Visibility.

2019 PostgreSQL Trends Report: Private vs. Public Cloud, Migrations, Database Combinations & Top Reasons Used

High Scalability

PostgreSQL is an open source object-relational database system that has soared in popularity over the past 30 years from its active, loyal, and growing community. For the 2nd year in a row, PostgreSQL has kept the title of #1 fastest growing database in the world according to the DBMS of the Year report by the experts at DB-Engines.

Boost Your Career by Getting Oracle Associate Certified – 1Z0-052 Exam Review from PrepAway

The Crazy Programmer

In order to achieve a very reputable Oracle Certified Associate, or OCA credential, an aspiring database administrator has to pass the Oracle 1Z0-052 certification exam. The Oracle Database professionals can get more salary hikes simply by becoming certified by the company.

Why the Self-Adapting Data Warehouse Is the Future

The New Stack

The amount of data businesses process today would seem unfathomable to a database administrator only a decade ago. Kent Graziano. Kent Graziano is the Chief Technical Evangelist for Snowflake Inc.

Reasons to Upgrade to MongoDB 3.6

Datavail

Database upgrades are a concerning thought for many database administrators. Security is almost always going to act as the primary motivator for upgrading your databases. If you stick with an older MongoDB database, then you could end up on their list.

What Types of Support Can You Get for MongoDB

Datavail

Your in-house database specialists may not have experience with NoSQL solutions. These service providers are also useful in getting your IT team used to working with a NoSQL database, which can difficult if they’re only experienced with relational databases.

Postgres and superuser access

The Citus Data

If you run on a managed service provider you are not going to be affected by this, and if you’re managing your own Postgres database all chances are you are equally as safe. A few days ago a CVE was announced for Postgres. To say this CVE is a bit overblown is an understatement.

Understanding User Story

SCRUMstudy

User Story Format: As a <role/persona>, I should be able to <requirement> so that <benefit> User Story Example: As a Database Administrator, I should be able to revert a selected number of database updates so that the desired version of the database is restored.

SQL Database Performance Tuning for Developers

Toptal

Database tuning can be an incredibly difficult task, particularly when working with large-scale data where even the most minor change can have a dramatic (positive or negative) impact on performance. In mid-sized and large companies, most database tuning will be handled by a Database Administrator (DBA).

Changes to Oracle’s Professional Database Certification

Datavail

Previously, the OCP name was associated with the release of the database, e.g. 11g OCP or 12c OCP. Now the name is Oracle Database Administration 2019 Certified Professional. Oracle Database Administration I – 1Z0-082. Oracle Database Administration II – 1Z0-083.

Couchbase’s Ravi Mayuram on the Future of Databases

The New Stack

The Couchbase data platform is a unique NoSQL Engagement database, designed for using data to connect customers, employees, and machines. Kubernetes orchestration allows the platform to automate administrative processes and speeds up data management.

9 trends to watch in systems engineering and operations

O'Reilly Media - Ideas

Reliability will be key to ensuring always-on, always-available performance so we’ll see more engineers and administrators adding reliability to their titles. From artificial intelligence to serverless to Kubernetes, here’s what on our radar.

Trends 104

DataOps and the Problem with ‘Ops’ Terminology

The New Stack

Yet, managing databases and other data platforms have been a core component of IT’s responsibilities for years. Unfortunately, the study does distinguish between database administrators, data engineers, storage professionals or a variety of other positions.

Survey 103

Better Together: Why Datavail is Partnering with Continuent for MySQL and MariaDB Database Solutions

Datavail

MySQL and its sister solution MariaDB are two of the leading options for relational database management systems. By spinning up database clusters in the cloud or in private data centers, users can guarantee the availability of their data, even in the event of a system failure.

Is “Free” Good Enough for Your MySQL Environment?

Datavail

If you run it using managed MySQL cloud services, you won’t need a database administrator. Datavail and Continuent established a partnership to provide solutions for continuous and highly available MySQL and MariaDB database operations. Continuent’s Tungsten Clustering is an economical one-of-a-kind software solution that allows enterprises running business-critical MySQL and MariaDB database applications to achieve continuous operations.

Representative Line: Classic WTF: The Backup Snippet

The Daily WTF

It's not just because database administrators tend to be a unique breed (his colleagues were certainly no exception), but because of the "things" that he'd heard about the team. It turned out that one of DBA's had recently updated their database backup script, but Thom wasn't really sure who did it, why it was done, or what it looked like before.

Attending Oracle’s CodeOne? Here Are 15 Sessions Everyone Will Be Talking About

OverOps

Don’t Stay Restless; Enable Your Database for REST: A QuickStart Guide [BOF5501]. Don’t Stay Restless; Enable Your Database for REST: A QuickStart Guide [BOF5501]. This QuickStart guides you from 0 to hero with simple steps for REST-enabling your database in the cloud.

DevOps 207

DataOps and the Problem with ‘Ops’ Terminology

The New Stack

Yet, managing databases and other data platforms have been a core component of IT’s responsibilities for years. Unfortunately, the study does distinguish between database administrators, data engineers, storage professionals or a variety of other positions.

Free Courses at Linux Academy – November 2019

Linux Academy

Database Administration and SQL Language Basics . We also provide an overview of the most popular Big Data technologies including core Hadoop, the Hadoop ecosystem (Hive, Pig, Sqoop, Flume, Kafka, Storm, Ambari, Oozie, Zookeeper), NoSQL databases, and Apache Spark.

Data engineers vs. data scientists

O'Reilly Media - Data

That's primarily the job for system administrators or DevOps. Or will machine learning engineers be the database administrator reborn? The two positions are not interchangeable—and misperceptions of their roles can hurt teams and compromise productivity.

Solved! Kubernetes Operators for Clustered Database Deployments

The New Stack

However, they fall short when it comes to deploying complex, stateful database components in a distributed, clustered environment. Most often, database deployments require complex scripts to ensure that the interdependencies are configured, deployed and operated in the correct order. Fundamentally, they allow complex, interdependent, distributed services (like clustered databases) to describe how they should be deployed, operated and managed via simple YAML configuration files.

Context: Amazon’s Elastic Distribution, the Business of Quantum Computing

The New Stack

the open source Grafana analytics visualization software now supports the Flux query language for time-series data, initially as a plugin, but soon as the default query language for the InfluxDB time-series database. Welcome to the new edition of The New Stack Context podcast.

Weekly Update 5-20-2019

Linux Academy

Several involve MySQL, which is a popular database management system used by Facebook, Twitter, YouTube, and many more. Creating databases. Database Administration and SQL Language Basics have three new labs: Creating Indexes in MySQL.

How to Build Web, Mobile and Chat Apps That Connect to Oracle?

Progress

Learn about how Kinvey's app platform works well with Oracle databases, improving your app's performance and making it easy to connect to chat applications. Oracle database is a relational database management system built by the Oracle Corporation.

The Ballad of Bart

The Daily WTF

Bart knew how to do everything from desktop support to software development to database administration to IT security. One day an entire metrics database suddenly became a bunch of null values, which is not very helpful for metrics.

5 Questions Database Admins Should Ask About Compliance Regulations

The New Stack

John is responsible for developing and evangelizing solutions-based stories for Quest’s extensive portfolio of database products worldwide. He has been with Quest Software since 2000, working in database design, development and deployment. DDL — structural changes to database objects.

Connecting to Actian Avalanche via JDBC

Actian

Requires minimal setup, provides automatic tuning to reduce database administration effort and enables highly-responsive end-user BI reporting. More information about the Looker IP addresses is available at Enabling Secure Database Access. Go to Admin > Database > Connections. Type db for the Database. Enter you database username and password in the Username and Password fields. • Create a new database connection.

Bringing DevOps to the Full Stack at Colonial Life

The New Stack

Colette Casey is a technical architect at Colonial Life, where she is responsible for 32 applications and five databases. The database side was even worse, as SQL Server database administrators (DBAs) had to manually deploy SQL scripts to each environment. Colette Casey.

Connecting to Actian Avalanche?from Pentaho?via JDBC

Actian

requires minimal setup, provides automatic tuning to reduce database administration effort and enables?highly-responsive?end-user Go to Tools > Wizard > Create database connection…. Provide a name for the database connection, e.g. Actian Avalanche JDBC. Select Generic database for the type of database and Native (JDBC) for the type of access. . Go to the Pentaho User Console and login as administrator. .

The Role of Agile Managers: Why Job Titles Are Dangerous

Agile Pain Relief Notes from a Tool User

Can a Developer contribute to database administration? Managers transitioning from waterfall to Agile will need to renegotiate their relationship with their teams if they are to succeed. A manager cannot simply become an Agile Manager – a big part of a transition requires a rethinking of how job titles are assigned and the leadership responsibility that comes with them. I was recently approached by a client who asked about effective Agile Organizational Structure.