 |
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: |
Bert |
Created: |
Monday, October 30, 2006 2:02 PM |
 |
|
Bert Scalzo is a product architect for Quest Software and a member of the Toad™ team. He has worked with Oracle databases for well over two decades; his key areas of interest are data modeling, database benchmarking, database tuning and optimization, "Star Schema" data warehouses and Linux. Bert is the author of several books and has written articles for many online outlets and publications, including Oracle’s Technology Network (OTN), Oracle Magazine and PC Week (eWeek), and has presented at numerous Oracle conferences and user groups.
Bert was recently added to the list of Oracle ACEs. Oracle ACEs are known for their strong credentials as Oracle community enthusiasts and advocates, with candidates nominated by anyone in the Oracle Technology and Applications communities.
Bert's blog provides useful “how to” and “tips and tricks” covering topics such as database admin and d |
|
Toad + Excel = Easy Data Access |
|
Bert
|
Wednesday, December 17, 2008 6:27 AM
|
|
|
|
Many business analysts rely heavily upon Microsoft Excel as one of their primary tools for manipulating and reporting upon their business data. Sometimes they will send data extraction requests to their information systems (IS) people to perform and then deliver, sometimes they’ll instead access it themselves in place via the external data interface within Excel, and sometimes they’ll extract the data ...
|
 |
|
|
Read More...
|
|
|
Virtual Paranoia? |
|
Bert
|
Wednesday, December 10, 2008 7:24 AM
|
|
|
|
Lately I’ve been seeing what I think might be an interesting yet disturbing new trend: whenever there’s a problem that initially seems unusual and/or unexplainable, it’s not uncommon to quickly question virtualization as a potential source of the issue. I fully understand that virtualization adds a new variable to the basic equation – and represents greater complexity due to more moving parts. But it seems to b ...
|
|
|
|
|
Read More...
|
|
|
Oracle + VMware = Success Part IV |
|
Bert
|
Wednesday, December 03, 2008 10:47 AM
|
|
|
A few weeks ago I wrote Part III of this series – and fortunately (or unfortunately for my poor ego) an astute reader wrote to ask for some clarification on my Excel chart. Ends up my Excel formula had a mistake – so many than ...
|
|
|
|
|
Read More...
|
|
|
|
Run Toad off a USB Flash Drive |
|
Bert
|
Wednesday, November 19, 2008 1:32 PM
|
|
|
Lot’s of people have asked “How can I setup Toad to run off a flash drive?” The reason for this question varies in nature and intent by requestor – but the general concept is that some users need the ability to carry Toad with them. Some are contractors who must use whatever computer and/or desk is open that day. Some are database developers who must travel around their company to perform or assist w ...
|
|
|
|
|
Read More...
|
|
|
Speeding-Up Oracle on Your Notebook PC |
|
Bert
|
Wednesday, November 19, 2008 7:29 AM
|
|
|
|
Just a quick blog this week – some relatively easy suggestions on how to make Oracle run as fast as possible on minimal computer setups such as a notebook PC. My goal is simply to squeeze as much performance blood from the Oracle turnip as possible when deployed on limited capacity equipment. The suggestions below should work for most operating systems, including Windows, Mac-OS and Linux – simply interpret and ...
|
|
|
|
|
Read More...
|
|
|
Just Make Oracle Go Faster |
|
Bert
|
Wednesday, November 12, 2008 8:25 AM
|
|
|
|
Catchy title – huh? But don’t laugh, in today’s hectic world many database professionals (whether DBA’s or developers – and sometimes even end users) just wish that the Oracle database would go faster. That may seem self evident – but let’s just accept that premise for now. So what does this mean for Toad users?
Toad offers numerous database monitoring, ...
|
|
|
|
|
Read More...
|
|
|
|
|
Oracle + VMware = Success Part II |
|
Bert
|
Wednesday, October 22, 2008 2:40 AM
|
|
|
Last week I wrote about how simply adjusting various virtualized infrastructure default settings that a database could perform up to 440% better. Of course “ your mileage” will vary, but the key point is ...
|
|
|
|
|
Read More...
|
|
|
|
|
|
|
|
|
|
|