A Review of Postgres version 12
Postgres version 12 is here. Did you miss its introduction like me? My excuse is the year-end holidays (what's yours?). Well, version 13 isn't planned for release until the fall, so there's plenty of...
Predict the future performance of your Oracle databases
Predict the future performance of your Oracle databases
Did you know that you can predict the future performance for individual SQL statements and use these predictions to mitigate future performance issues using the Toad® for Oracle Spotlight® on Oracle f...
Raiders of the “Lost” Toad: Undiscovered Gems—Cameras and Watches
Raiders of the “Lost” Toad: Undiscovered Gems—Cameras and Watches
Just a reminder that this blog series is all about helping Toad users find those “hidden” gems in the product’s graphical interface… gems that will increase your productivity. In my first blog of ...
Toad® for Oracle: Historical and future space usage
Toad® for Oracle: Historical and future space usage
Did you know that Toad® for Oracle can allow you to track Tablespace Usage historically and even forecast how much space you’ll need going forward? Knowing this information is critical for planning pu...
(Another) Foglight Countdown!
( * This blog has been updated from last year's.... ) We have all done it. We think we know the lyrics to a song. We sing them passionately….and incorrectly. Here are a few classics. “Excuse me whi...
The Object of My Affection – Litespeed’s Object Level Recovery
All is well. Megan is having a good day. She’s a SQLServer DBA and her environment is humming along. Then…. someone drops a critical table bringing efficient data retrieval to a screeching halt. Now w...
Mitigate Risk with SQLServer Differential Backups Using Litespeed
SQLServer Differential Backups make a lot of sense...they backup only what has changed. However, it seems that many Database Administrators choose not to leverage them. When digging into reasons for t...
Introducing user level access with Spotlight 13.0
Spotlight 13.0 introduces a brand new feature of managing access to monitored connections at the user level. It provides the ability to assign or deny a user access to a set of connections that have b...
Can you believe this Administration?!
What’s that you say? You think it may not be appropriate that a technology blog dive into politics? Agreed. Instead, this blog highlights the breadth of Administration capabilities available in Foglig...
We Put It On Our Tab – Complementary Oracle Monitoring with Foglight Pt 3 (of 3) – CRS and Exadata
This blog series discusses each of the ‘tabs’ that can be found on the Database Home page in Foglight for Oracle. These monitoring options come included at no additional cost and illustrate how broad ...
Identify Long Running Queries with Foglight
April 15, 2019.....Let’s give a shout out to all those men and women running the Boston Marathon today. Man, running for that long must be taxing. Taxing…..wait…what day is it again? So, as my way of ...
We Put It On Our Tab – Complementary Oracle Monitoring with Foglight Pt 2 – ASM
This blog series discusses each of the ‘tabs’ that can be found on the Database Home page in Foglight for Oracle. Part 1 of the blog covers Foglight’s monitoring for Oracle’s Data Guard. https://www.q...