Parsing full physical file names for information is one of those tasks a database administrator (DBA) finds they do on a semi-frequent basis; from looking up SQL Agent Job output paths or reviewing database file metadata....More
Itzik discusses two T-SQL challenges: replenishing quantities and depleting quantities. He presents an efficient solution for replenishing quantities and challenges you to find an efficient solution for depleting quantities....More
GenesisOne has released version 2 of its T-SQL Source Source Code Unscrambler—the industry's first tool to read SQL code and automatically create professional, data-flow documentation without altering the code in any way....More
Are you leveraging all of Toad’s powerful features? In this on-demand webcast, Oracle ACE and Toad Product Architect Bert Scalzo discusses Toad’s hidden functionality, and how it can make your job easier.
Watch it today....More
In this on-demand webcast, Oracle ACE and Toad Product Architect Bert Scalzo discusses 10 powerful and hidden features in Toad® that help increase your productivity and DB performance.
Watch this webcast today....More
Are you dealing with national and international records? The more expansive your records are in territory, the more problems you will face when it comes to verifying addresses. Not only are you dealing with language differences, but you are also dealing with different address formatting for different countries....More
Your contact data is valuable, but is it up to its full potential? Without the proper maintenance, the quality of your data quickly decreases--so quickly that 50% of databases deteriorate after only two years. It is an absolute necessity to maintain your data in order to decrease costs and increase profits....More