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
High-quality data is key to uncovering meaningful insights and new opportunities. Melissa Data has recently released a new tool, Data Profiler, to help companies that are dealing with large quantities of data and need a full spectrum of solutions that work....More
Don't forget to migrate Power BI for Office 365 content before you leave for the holidays. Deprecation of Power BI for Office 365 starts at the end of December 2015. Here is what you need to know to successfully move your business intelligence content to the latest and greatest version of Microsoft Power BI....More