Spotlight on SQL Server Enterprise 11.6 is here! So what’s new? Spotlight introduces Federation architecture A Spotlight Client can now monitor connections from multiple Spotlight Diagnostic Servers i...
Test Driven Design The adoption of agile development is clearly on the rise and with it comes–at least the consideration for–Test Driven Design (TDD). Although the decision to embrace TDD in your deve...
We are pleased to announce the release of Toad for SAP Solutions v3.1. Toad for SAP Solutions is a comprehensive solution to improve DBA and development effectiveness and productivity across all of SA...
We are pleased to announce the release of Toad for DB2 v6.2. This new version is now available for customers to download at our Toad for DB2 product page. Toad for DB2 is a comprehensive solution to ...
For most people troubleshooting SQL query performance problems is a necessity rather than a preference. Very often they are using a trial and error strategy to overcome those frustrating situations. U...
Expert Advice Whose advice are you listening to when building your requirements? Sure, your end users think they know what they want, but are they the right people to assist you in designing a solutio...
This article explains how to create service, managing services and close view of service failover to the preferred databases and various other options related to services, The GDS introduction and the...
SAP HANA stands for SAP’s High-Performance Analytic Appliance(HANA); it enables the processing of massive quantities of data in the main memory of the server in real time. SAP is one of the largest...
This article explains how to configure Data Guard between RAC primary and standby alone (Oracle restart) Standby database with easy and all advanced methods to achieve Oracle maximum availability arch...
Overview In typical data warehousing environment existence of huge partitioned tables is very common, gathering statistics on such tables is challenging tasks. For partitioned tables there are two typ...
Why End Users Don't Like Their Solution One of the biggest problems facing your job as a business analyst is unhappy end users. Sometimes it feels like you're more of a therapist than a business analy...
Oracle 12c has introduced the multi-tenant architecture for Oracle database, where a single container database (CDB$ROOT) can have multiple pluggable databases (PDBs). This new architecture is introdu...
