How to send data to the SQL editor in Toad Data Point
How to send data to the SQL editor in Toad Data Point
Learn how to send data to the SQL editor in Toad Data Point....
Why Some SQL Tuning Rewrites are not always Correct ?
Why Some SQL Tuning Rewrites are not always Correct ?
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 server
How to publish automation scripts from Toad Data Point to Toad Intelligence Central server
How to publish automation scripts from Toad Data Point to Toad Intelligence Central....
Cross Platform Query – X Query – Insert into a table on a 3rd Platform
Cross Platform Query – X Query – Insert into a table on a 3rd Platform
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...
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...