A junior developer came to me recently and asked me a SQL transformation question. He gave me an example of a SQL statement similar to this one: select * from TableA A where A.KeyCol/10 = 12345 The p...
How to publish automation scripts from Toad Data Point to Toad Intelligence Central....
One of the really cool things that you can do with X Query in Toad Data Point is take data from disparate data sources and join them together in one view utilising the X Query builder. You can howeve...
Learn how to make a native connection to an Oracle database using Toad Data Point....
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...
Learn how to publish data from Toad Data Point to Toad Intelligence Central....
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...
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...
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...
