|
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 ...
|
 |
|
Comments (2)
|
Read More...
|
|
|
How Data Modeling Can Save Money |
|
Bert
|
Wednesday, April 30, 2008 4:46 AM
|
|
|
|
It’s not uncommon to discover databases that have simply evolved over time rather than having been built according to some overall design or “master plan”. And there seem to be no shortage of answers as to why this occurs. Sometimes DBA’s are just far too busy with a myriad of other tasks. Sometimes developers are under th ...
|
|
|
|
Comments (0)
|
Read More...
|
|
|
Why Can’t Johnny Use BMF? |
|
MikeA
|
Tuesday, April 29, 2008 8:05 AM
|
|
|
|
As many of you are aware Quest provides a tool known as Benchmark Factory, BMF for short. BMF is a load generation tool that also allows you to install small databases for testing. The tools out of the box can provide TPC-B, TPC-D, TPC-H, AS3AP and many other standard benchmarks as well as allowing goal and scalability tests from your own code, either manually entered or scanned from text or, in the case of Ora ...
|
|
|
|
|
Read More...
|
|
|
|
Need Help Fixing Tables with Duplicate Values? |
|
JeffSmith
|
Thursday, April 24, 2008 7:45 AM
|
|
|
|
Despite the best intentions of the DBA or the person who designed the data model, the collection of primary keys, unique indexes, constraints, and triggers are not a foolproof method of keeping duplicate records creeping into your tables and views. Any business rule in the database can be disabled. An even more likely scenario is the business rule changing after the fact. So ...
|
|
|
|
Comments (0)
|
Read More...
|
|
|
Keep It Under Control With Approvals |
|
JohnWeathington
|
Thursday, April 24, 2008
|
|
|
|
As a follow on to last week’s blog about controlling with reconciliation, in this blog we look at another common control – approvals. Here are some key tips for designing systems that demonstrate control with approvals.
|
|
|
|
Comments (0)
|
Read More...
|
|
|
Landmines |
|
MikeA
|
Wednesday, April 23, 2008 6:20 AM
|
|
|
|
Introduction
At the peak there were an estimated 65 million landmines planted in killing fields world wide. In the 1990’s it was estimated that while 2.5 million landmines were being deployed per year only 80,000 were being removed. According to current estimates this may have turne ...
|
|
|
|
|
Read More...
|
|
|
Toad Can Reduce Waits |
|
Bert
|
Wednesday, April 23, 2008 3:46 AM
|
|
|
|
When using either Toad’s Stats Pack Browser or AWR Browser screens (both part of the optional DBA module and/or bundle), the plethora of graphs can sometimes be a wee bit overwhelming – as shown in the screen snapshot below. So how is any DBA in an urgent situation or hurry to both successfully and expediently interpret such database activity?
...
|
|
|
|
Comments (0)
|
Read More...
|
|
|
Testing and refreshing data from production |
|
StevenFeuersteinTW
|
Thursday, April 17, 2008 9:21 AM
|
|
|
|
As many of my readers likely know by now, I have been working for the past several years on the Quest Code Tester development effort.
Code Tester is the most powerful PL/SQL test automation tool available. You describe the expected behavior of your programs and Code Tester generates your test code, which can then be run from the UI or via a script. With Code Teste ...
|
|
|
|
Comments (0)
|
Read More...
|
|
|