How to make a native connection to an Oracle database using Toad Data Point
How to make a native connection to an Oracle database using Toad Data Point
Learn how to make a native connection to an Oracle database using Toad Data Point....
100% Correct Cost Estimation Leads to the Best SQL Optimization – 10 Common Misconceptions in SQL Tuning #10
100% Correct Cost Estimation Leads to the Best SQL Optimization – 10 Common Misconceptions in SQL Tuning #10
This blog is the finale in this series about common misconceptions surrounding SQL tuning. I selected this topic as my last one because it is a very common misconception in a DBA or developers mind. I...
How to publish data from Toad Data Point to Toad Intelligence Central
How to publish data from Toad Data Point to Toad Intelligence Central
Learn how to publish data from Toad Data Point to Toad Intelligence Central....
Integrating Spotlight on SQL Server Enterprise with Your Enterprise Monitoring Tool
Integrating Spotlight on SQL Server Enterprise with Your Enterprise Monitoring Tool
I very frequently come across DBA's that that are either overwhelmed with the complexity of their organizations enterprise monitoring platform, or underwhelmed with its out of the box monitoring and d...
Shrinking Database Maintenance Windows With SQL Optimizer
Shrinking Database Maintenance Windows With SQL Optimizer
Many databases have, as part of their daily workload, batch updates or maintenance processes that run during off-hours. For example, a database that supports an accounts receivable function may have a...
Twitter Chat: The Top “Gotchas” of SQL Server Administration and Development
Twitter Chat: The Top “Gotchas” of SQL Server Administration and Development
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...
Tips and Tricks – Spotlight Connection Sharing
Tips and Tricks – Spotlight Connection Sharing
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 ...
Tips and Tricks – Spotlight Alarm Views
Tips and Tricks – Spotlight Alarm Views
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...
Tips and Tricks – Spotlight on Oracle Calibration
Tips and Tricks – Spotlight on Oracle Calibration
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...
Tips and Tricks – Spotlight Display Modes
Tips and Tricks – Spotlight Display Modes
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...
How to add Parent Table Name to FK columns at once
How to add Parent Table Name to FK columns at once
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...
How to generate localized reports
How to generate localized reports
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...