Editorials Kathi Kellenberger in Editorials Buying an SSD card for a grandchild We recently ordered a tablet for our 8-year-old grandson. We ensured that it would support a decent-sized SSD card, 128 GB, for storing all the... 10 May 2022 3 min read
Oracle Jonathan Lewis in Oracle Transformations by the Oracle Optimizer To troubleshoot poorly performing SQL in Oracle, you must understand which transformations the optimizer has made. Jonathan Lewis demonstrates several possible optimizations for one query.… 14 January 2022 16 min read
CI/CD Sebastian Meine Liz Baron in CI/CD How to successfully deploy databases with external references Database objects often have references to external databases which makes continuous integration problematic. In this article Liz Baron and Sebastian Meine demonstrate a solution.… 29 September 2021 8 min read
BI Sanil Mhatre in BI Text Mining and Sentiment Analysis: Oracle Text Oracle has built-in functionality to analyze text. Sanil Mhatre demonstrates how to perform a sentiment analysis on data stored in a table using Oracle Text.… 30 August 2021 12 min read
Oracle Jonathan Lewis in Oracle Oracle sequences – 12c features including “identity” Oracle added several enhancements to the sequence object in version 12c, including an “identity” column feature. Jonathan Lewis explains how to work with these new... 19 August 2021 16 min read
Oracle Jonathan Lewis in Oracle Typical uses of Oracle sequences Oracle sequences supply unique numbers that can be used when populating tables. In this article, Jonathan Lewis explains the typical uses of Oracle sequences.… 14 July 2021 17 min read
Azure Dennes Torres in Azure How to query blob storage with SQL using Azure Synapse How do you include blob storage in reports? In this article Dennes Torres explains how to query blob storage with SQL using Azure Synapse.… 01 July 2021 17 min read
Oracle Jonathan Lewis in Oracle Oracle Sequences: RAC Using sequences when scaling up with Oracle RAC presents more issues with contention. In this article, Jonathan Lewis explains how to avoid the problems.… 11 May 2021 19 min read
Database DevOps Carlos Robles in Database DevOps Database version control: Getting started with Flyway Flyway is a multi-platform, cross-database version control tool. Carlos Robles explains Flyway’s history and shows how it works.… 06 January 2021 14 min read
Culture Robert Sheldon in Culture Ten tips for attracting and retaining DevOps talent To stay competitive and bring value to customers, organisations are adopting DevOps, but finding people experienced in DevOps can be challenging. Robert Sheldon has ten... 07 December 2020 10 min read
Database DevOps Kendra Little in Database DevOps Feature branches and pull requests with Git to manage conflicts Feature branching and pull requests are two important concepts when using Git. In this article, Kendra Little explains these patterns and even provides a video... 07 December 2020 14 min read
Oracle Jonathan Lewis in Oracle Are your Oracle archived log files much too small? Oracle sometimes generates smaller archived redo logs than you might expect based on the size of the online redo logs. In this article, Jonathan Lewis... 30 November 2020 12 min read
Oracle Srinivasan Suresh in Oracle SQL Developer – A great tool and better ways to use it SQL Developer is a popular free tool for working with Oracle databases. In this article Srinivasan Suresh explains several features of SQL Developer that can... 19 November 2020 14 min read
Editorials Kendra Little in Editorials Three ways that taking the State of Database DevOps Survey helps the community Redgate has recently opened the 2021 State of Database DevOps Survey. Whether or not your organization does DevOps, I would love for you to take... 16 November 2020 2 min read
Tools Dino Esposito in Tools Git in action Dino Esposito continues his series on git. In this article, he explains how to initialize a repository, track files, and revert to a specific revision.… 09 November 2020 13 min read
Database DevOps Robert Sheldon in Database DevOps 10 DevOps strategies for working with legacy databases The database is often left behind as organisations embrace DevOps. In this article, Robert Sheldon explains how to successfully bring databases into DevOps, especially when... 29 October 2020 11 min read
CI/CD Siddharth Rao in CI/CD Continuous deployment at scale More organisations are adopting DevOps, but what happens as the codebase grows? In this article, Siddharth Rao gives advice on how to implement continuous deployment... 20 October 2020 6 min read
Editorials Kathi Kellenberger in Editorials Is communication always important? Conventional wisdom says that communication is the critical for success in just about any aspect of life, be that personal relationships or within teams or... 20 October 2020 3 min read
Containers and Virtualization Michael Sorens in Containers and Virtualization Checking the pulse of Kubernetes In this article, Michael Sorens describes the many ways that you can monitor Kubernetes.… 08 October 2020 10 min read
Tools Dino Esposito in Tools Git anatomy In this article, Dino Esposito gives an overview of git explaining repository, commit, and branch.… 05 October 2020 11 min read
