Heavy Lifting Most of time, the workload on business analyst is pretty reasonable; however, sometimes a massive amount of requirements must be gathered in a short amount of time. I've helped many comp...
In SQL Server models you can define Extended Properties to various objects manually. In case you wish to add extended properties to multiple objects at once, download a small macro from here. Extract...
As a Developer or DBA it is important to understand the dependencies and relationship of your database objects. In this short video, Toad for DB2 development manager, Jeff Podlasek, demonstrates how T...
As a DBA it is important to closely manage your space usage and understand the benefits that DB2’s architecture provides. This includes keeping data in partitioned tables equally distributed to gain t...
I was talking to a customer this week about the process of generating a Change Script when they are ready to deploy their changes and they were concerned about the fact that the script generation alwa...
This video provides an overview of Toad for SAP Solutions. If you want to try Toad for SAP Solutions, download a 30-day free Trial...
One of the more common requests that I get from Benchmark Factory users is to provide them with a list of best practices for using Benchmark Factory and for database benchmarking in general. Even for ...
A frequent question that I have received from many DBAs is: my undo tablespace is almost full, how can I be sure that the space will be reused? Well, First you have to know that there are two kind of...
When Push Comes to Shove Gathering requirements seems like a straightforward process, but sometimes it's hard to figure out the relative importance of the requirements. If you're running an agile proj...
In this article I will show you how undo retention time is set when we have an Undo tablespace with autoextend enabled and also disabled. I will give you rules in order to remember this easily: Rule-...
If you want to find the minimum salary among all employees, you may issue a SQL statement like this: select min(emp_salary) from employee Plan 3 SELECT STATEMENT 2 SORT AGGREGATE ...
In this article series, we are discussing Oracle Real User Experience Insight (RUEI). Part IV was here. This is the fifth and final article in this series. We were talking about the RUEI Application ...
