Maria Colgan shared, “The longer an application has been successfully run, the more likely you are to have indexes that are no longer used or beneficial. Removing these indexes not only saves space but can also improve the performance of any DML operations. But knowing which indexes can be safely…
Tag: sql
Analytics
Read more
Monthly Round Up
This blog by Federico Venturin links to his article ‘Handling Fine-Grained Data Visualization Permissions in Oracle Analytics Cloud.’ It goes through: In his conclusion, he writes, “Until now, the all-or-nothing approach for handling permissions in Data Visualization posed a significant hurdle to its widespread adoption since administrators understandably preferred to…
Analytics
Read more
News from May 2022
Blogs of the Month qgis with Oracle Cloud Database “One of these complex situations is the connection to an Always Free Autonomous Database. Oracle tries to secure the database access, so by default it does not allow a simple connection with host, port, service_name and username/password. Instead a wallet is provided…
APex
Read more
Best of last year
Here is my take on the good reading stuff from last year. Obviously there is a bit of a covid theme to a lot of the blogs I read, but also some great tech updates. Learn how Oracle used APEX to quickly launch its COVID-19 therapeutic app Read about how…
APex
Read more
End of Summer…
Today is the last working day of August (It’s a UK Bank Holiday Monday on 31st August…) next week we will be into the beginnings of September and Autumn. Slow down over the Bank Holiday and read some of the latest blogs and articles or watch some videos…. Blogs of…
APex
Read more
An early July blog…
Blogs of the Week 1. Announcing SQL Developer, SQL Developer Data Modeler, & SQLcl versions 20.2 Jeff Smith says, “However, there are bug fixes that we need to get into your hands, and our developers have never stopped working on new features, so we ARE releasing version 20.2, TODAY.” He…
Weekly News
Read more
A bit of light reading…
Blogs of the week 1. Copying a SQL Plan Baseline from one database to another Martin Bach starts by saying, “Hopefully this post saves you a few minutes looking the procedure up. I know it’ll save me some time 😉 In this rather lengthy article I’d like to cover how I…