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
Even if SQL Server database developers are totally committed to using ORMs, it's still worthwhile to assume that once you start storing lots of data, you’ll start running into performance problems....More
An option when creating new AlwaysOn Availability Groups is to specify Backup Preferences.
It’s also something you can easily configure once the Availability Group has been set up as well – by simply right-clicking on the Availability Group and selecting Properties – then navigating into the Backup Preferences tab. ...More
The quest for the Golden Record to achieve a single, accurate and complete version of a customer record is worth the pursuit to attain survivorship. Record matching and consolidation are only the beginning. Melissa Data takes a new approach. Learn how to apply intelligent rules based on reference data to make smarter and better decisions for data cleansing....More