Tag: sql

Data preparation with dbt and BigQuery

Raw incoming data needs to go through a series of data preparation steps before it can be used for analysis. These steps include tasks such as type casting, renaming columns, cleaning values and identifying duplicates. Writing code to perform these…

Read More >

Select vs Assign – How To Assign PL/SQL Variables

When writing PL/SQL, should you use ‘select from dual’ to assign variable values? The answer may surprise you.

Read More >

Reducing Contention on Hot Cursor Objects (Cursor: Pin S)

First, let me offer a little explanation about the wait event “cursor: pin S.” Oracle states: “A session waits on this event when it wants to update a shared mutex pin and another session is currently in the process of…

Read More >

How to determine RMAN backup size

A time long ago, I wrote a SQL query to determine RMAN backup size. Here is another validation for the SQL query. Why is this important? Because, as part of a backup review, it’s good to know the growth for the backup…

Read More >

Oracle Live SQL revised

If you’re not familiar with the Oracle Live SQL environment, then you should definitely try it. I wrote a blog some time ago on what it is and how to work with execution plans there. Here I will provide an…

Read More >

Oracle SQL Developer – now in web!

For some time, I was trying to use a Google Pixelbook for my work. It was kind of a challenge and among other things, I struggled to work without a good web-based SQL client or tool. I used a jump…

Read More >

Tackling time troubles – how to use dates correctly in Oracle

For the Oracle Code series of events I have delivered an older but still relevant talk called “Tackling Time Troubles.” Half of it is nice-to-know geek trivia and the other half is a few points on how to avoid very…

Read More >

How to display database statistics for all objects used in a SQL statement

When my current task is to optimize a particular SQL statement, I find it quite useful if I can determine if the statistics are up-to-date for all objects that are used in the execution plans. There are a number of…

Read More >

Log Buffer #517: a carnival of the vanities for DBAs

This Log Buffer Edition covers Oracle, SQL Server and MySQL.

Read More >

Log Buffer #512: a carnival of the vanities for DBAs

This Log Buffer Edition covers Oracle, SQL Server and MySQL.

Read More >
Page 1 of 212