In this fun, interactive session, SQL Server experts Richard Douglas and Tim Ford will share their tricks and tips for keeping up with growing information demands. Plus, Richard and Tim will reveal ea...
One of the challenges that a DBA team encounters is keeping all of the DBAs up-to-date on connection changes. When a new database is created or an existing database has been changed, the DBAs need to ...
In my last couple of blogs for Spotlight on Oracle I have highlighted a couple of features that may not be well known but are very useful. I would like to continue that theme here with another great s...
In this blog, I am going to talk about one of the features of Spotlight on Oracle that may not be very well known or understood – Calibration. One of the reasons that Calibration may not be well known...
One of the great things about Spotlight is that it's easy to take a quick look at the screen and know immediately if there is a problem that needs your attention. I have had a number of Spotlight user...
There can be various reasons why all primary key attributes in your database structure should be named identically. The most typical name is “ID”. But what if you start creating relationships? In Toa...
If you wish to generate localized HTML, RTF or PDF reports, download dictionaries from the following section: Run Toad Data Modeler and click Settings | Dictionaries. New tab Dictionaries opens. Mak...
The email activity in Automation is a very important activity. Most automation scripts end with an email deploying a report or confirmation that the script is complete. To start using Email you ...
As shown in other videos, variables can be very useful in automation. In this video let’s discuss how to use variables with the LoopDataset activity. This activity allows you to take a result set and ...
An Oracle explain plan is very much like a Google map of directions to drive from point-A to point-B (in the old days, before the web, we used to go to a local AAA to get a “Trip Tik” map). However a ...
Scan SQL helps you identify problematic SQL statements in your database environment by automatically extracting statements embedded in database objects, stored in application source code and binary fi...
Not all reports are repetitive. Perhaps you have a situation where you only want to produce a report when a set of circumstances arise. Here is a simple example. Clerks enter orders and at the e...
