|
How to Help Your Company with Financial Risk |
|
JohnWeathington
|
Thursday, July 31, 2008
|
|
|
|
The new SEC standards for SOX compliance have made it clear that your company should spend more time focused on financial risk. In this article, we’ll explore what’s driving this, how you as a database professional can help out, and some design considerations for a Financial Risk Compliance Data Mart.
|
 |
|
Comments (0)
|
Read More...
|
|
|
Toad Executing Scripts against Multiple Databases (Part 1) |
|
Bert
|
Tuesday, July 29, 2008 3:15 PM
|
|
|
|
One of the more frequent questions people ask me is why can’t Toad run scripts or commands against multiple databases at once? Of course as usual the answer is Toad already can – so I’m going to dedicate the next couple weeks’ blogs to this topic.
This week I’ll highlight the first method of running scripts for multiple databases using the “Toad Script Manager”. It ...
|
|
|
|
Comments (1)
|
Read More...
|
|
|
Automated Storage management |
|
JimWankowski
|
Tuesday, July 29, 2008 12:30 PM
|
|
|
Continuing on with my discussions on autonomic computing in DB2 is the concept of self managing space. Proper space allocations are another critical factor when it comes to optimizing the performance of your database. Inadequate space allocations can result in application ...
|
|
|
|
Comments (0)
|
Read More...
|
|
|
Coping with Disaster |
|
JohnWeathington
|
Thursday, July 24, 2008
|
|
|
|
This article wraps up the series on the types of controls and our discussion of architectures, by taking a look at the adaptive control. We’ll explore how you can support your business deal with the impact of risks, when there is no contingency plan.
|
|
|
|
Comments (0)
|
Read More...
|
|
|
Toad Data Modeler Generates Best SQL |
|
Bert
|
Wednesday, July 23, 2008 5:11 AM
|
|
|
|
When you go through the entire exhaustive process of doing an effective (i.e. accurate) logical model so that you have properly captured all the true business rules and requirements, you sure don’t want your data modeling tool to compromise those findings as you move into the physical model – which is database platform dependent. Yet most data modeling tools do a very poor job of translating ...
|
|
|
|
Comments (0)
|
Read More...
|
|
|
Toad...and Java??!! |
|
JohnPocknell
|
Tuesday, July 22, 2008 10:09 AM
|
|
|
|
I thought that’d grab your attention!
We know there are a lot of PL/SQL developers out there who are looking to make (or have already made) a break into application development using a more popular programming language like Java as well as many Java developers who use Toad to make access to Oracle easier.
< ...
|
|
|
|
Comments (0)
|
Read More...
|
|
|
Oracle Open World Presentations |
|
StevenFeuersteinTW
|
7/22/2008 8:41 AM
|
|
|
|
Hey folks,
For anyone attending Oracle Open World this year, here is my schedule of presentations:
Session ID: S300184
Session Title: Weird PL/SQL
Track: Oracle Develop: Database
Room: Golden Gate C3
Date: 2008-09-21
Start Time: 15:45
|
|
|
|
Comments (0)
|
Read More...
|
|
|
10 Things You Must Know about Toad’s Editor |
|
JeffSmith
|
Tuesday, July 22, 2008 8:06 AM
|
|
|
|
The editor window is probably where most users spend a majority of their time. In this blog, I’ll try to highlight the 10 features that will save you the most time when it comes to writing your SQL queries, SQL*Plus scripts, anonymous blocks, and PL/SQL stored procedures. Please note that all of these features are available in the standard edition of Toad for Oracle, version 9.6.
...
|
|
|
|
Comments (1)
|
Read More...
|
|
|
3 Key Tips for Surviving a Firefight |
|
JohnWeathington
|
Thursday, July 17, 2008
|
|
|
|
Nobody likes a firefighting effort, but unfortunately it’s a fact of life that we need to deal with as database professionals. In this article I share my 3 favorite tips for getting through without getting burned.
|
|
|
|
Comments (0)
|
Read More...
|
|
|
Only Toad can debug SQL Scripts |
|
Bert
|
Wednesday, July 16, 2008 3:45 AM
|
|
|
|
I have been doing Oracle work for just over two decades – and I’ve probably written thousands of SQL scripts. Many of those were DBA oriented in their task nature, but even application development presents times where SQL scripts are used. For example, the need may arise for the operating systems’ or third party schedulers to invoke a shell script to execute a SQL script to execute ...
|
|
|
|
Comments (2)
|
Read More...
|
|