Tag: dba

Oracle Service Secrets: quiesce tactically

In the second post in this series, Bjoern Rost, Principal Consultant at Pythian, explains how to temporarily disable connections during maintenance with the help of services.

Read More >

GNU Screen Utility for DBAs

Gleb Otochkin, Principal Consultant and Certified Oracle Expert at Pythian, explains how to use the GNU Screen utility for DBAs.

Read More >

Redshift Table Maintenance: Vacuuming

Michael Taluc, Big Data Consultant and Solutions Architect at Pythian, details the process of vacuuming in overall Redshift Table Maintenance.

Read More >

GoldenGate 12.2 Big Data Adapters: part 1 – HDFS

Gleb Otochkin, Principal Consultant and Certified Oracle Expert at Pythian, discusses the HDFS adapter for the newest version of GoldenGate.

Read More >

New ORAchk 12.1.0.2.6 beta

Gleb Otochkin, Principal Consultant and Certified Oracle Expert at Pythian, discusses Oracle’s recently released new beta 12.1.0.2.6 version for the Orachk utility, and why Oracle DBAs should be using it.

Read More >

Is the DBA Career Dead?

Felipe Ferreira, Pythian Database Expert and Microsoft MVP, explains how embracing the cloud as an emerging technology doesn’t necessarily mean the end of the DBA role.

Read More >

SQL 2016 – Improve Performance with the Query Store feature: Part 1

  After playing with this great new feature for some time and speaking about it during a SQL Saturday in Montreal, I can say that I am very excited about Query Store in SQL 2016! Performance tuning is our bread and butter…

Read More >

Log Buffer #444: A Carnival of the Vanities for DBAs

This Log Buffer Edition covers some blog posts of Oracle, SQL Server and MySQL from this past week.

Read More >

Log Buffer #443: A Carnival of the Vanities for DBAs

This Log Buffer Edition finds and publishes blog posts from Oracle, SQL Server and MySQL.

Read More >

Oracle 12c – Adaptive Query Optimization

Scenario: A user complains that a batch job that is critical for the month end business processing is taking more time than expected. As a DBA you quickly check and identify the sql statement that is running, compare the current execution…

Read More >
Page 1 of 3123