|
|
 |
Blogs
Toad and Database Commentaries |
Toad World blogs are a mix of insightful how-tos from Quest experts as well as their commentary on experiences with new database technologies. Have some views of your own to share? Post your comments! Note: Comments are restricted to registered Toad World users.
 Do you have a topic that you'd like discussed? We'd love to hear from you. Send us your idea for a blog topic.
|
|
|
|
|
|
|
Author: |
dnorwood |
Created: |
4/30/2008 9:43 AM |
 |
 |
Daniel Norwood is a Product Manager for Quest Software. Daniel brings over 8 years experience in the software industry specializing in RDBMS and related technologies. In addition to product management, Daniel has worked in support, testing and project management.
Daniel's blog provides useful “how to” and “tips and tricks” on Toad for Data Analysts as well as his thoughts on topics relevant to data analysts.
Recent postings on Toad for Data Analysts:
|
|
|
|
Reverse Engineer a SQL Query |
|
dnorwood
|
8/24/2009 8:30 PM
|
|
|
|
Have you considered switching to Toad for Data Analysts but have too much invested in your old query builder? Have you ever looked at a query with a complex join clause and wished that you could see it mapped out visually? You're in luck - Toad for Data Analysts can help! Toad for Data Analysts can take your SQL statement and reverse engineer it into a visual Query Builder. In this blog post, I’ll show you how to do it quickly and easily!
|
 |
|
|
Read More...
|
|
|
Configure your Toad! |
|
dnorwood
|
7/29/2009 12:21 PM
|
|
|
|
We all come from different backgrounds... some of us are old Toadies, and some of us are used to different tools. Did you know that Toad for Data Analysts can be configured to act and look much like Toad for Oracle and many other tools? Even down to the keyboard shortcuts? I'll show you how.
|
|
|
|
|
Read More...
|
|
|
|
Update your Excel reports... automatically! |
|
dnorwood
|
5/29/2009 3:02 PM
|
|
|
|
If there's one thing we hear people asking about it's "How can I use Toad for Data Analysts to automatically update my Excel report?" This blog entry is dedicated to just that. I'll show you how you can get your Excel reports to update from the database in just a few steps - and automate the process for next time!
|
|
|
|
|
Read More...
|
|
|
Creating multiple XLS files through Automation |
|
dnorwood
|
3/27/2009 4:30 PM
|
|
|
|
If you’re like many of the analysts I speak with on a regular basis, then you use Microsoft Excel. It’s a staple of the Information Age, right!? It seems like you can do everything but wash your car with Excel. But what if you want to get that data out of your database and into a series of worksheets… on a regular basis…? Unless you have lots of free time, this is probably something that you don’t look forward to. Let’s take a look at how Toad for Data Analysts can make your Excel-life even easier!
|
|
|
|
|
Read More...
|
|
|
Getting to know the Query Builder in Toad for Data Analysis |
|
dnorwood
|
11/5/2008 3:04 PM
|
|
|
|
Query Builder is the heart and soul of Toad for Data Analysis. We've spent lots of time and effort working to make it very useful and intuitive. Recently, in version 2.0 of Toad for Data Analysis, we introduced a few new features including reverse engineering SQL to a Query Builder model, creation of DDL scripts and better connection awareness. The linked doc is a very nice write up that Shawn Pickett (Senior Developer) and Alan Bala (Development Team Lead) have put together.
|
|
|
|
|
Read More...
|
|
|
|
Writing Better Queries Starts With Understanding |
|
dnorwood
|
6/23/2008 6:52 AM
|
|
|
|
For those of you who may not come from a super-technical background, the term “ER Diagrammer” may sound strange or unfamiliar. Well, for the record, the term “ER Diagrammer” stands for “Entity Relationship Diagrammer” – a fancy name for a tool that displays the relationships between objects (like tables) in the ...
|
|
|
|
|
Read More...
|
|
|
Changing the look and feel of Toad for Data Analysis |
|
dnorwood
|
5/20/2008 1:44 AM
|
|
|
|
We’ve done a lot in Toad© for Data Analysis to make it user friendly and intuitive. Naturally, what’s user friendly to one person may be a bit confusing to someone else. This post will show you how Toad for Data Analysis can be changed to something more comfortable or familiar.
|
|
|
|
|
Read More...
|
|
|
Working With Date Ranges in Toad for Data Analysis |
|
dnorwood
|
4/30/2008 10:13 AM
|
|
|
|
Often when writing a query you need to get data from a range of dates; when you start thinking about automating the SQL query it’s even more important. In this post I’ll show you a quick trick to let Toad for Data Analysis figure it out for you!
For this example I’ll be working with Oracle though it’s no different for other ...
|
|
|
|
|
Read More...
|
|
|
|
|
|
|
|
|
|
|