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
Many organizations today cannot use public cloud solutions because of security concerns, administrative challenges and functional limitations. However, they still need a centralized platform where end users can conduct self-service analytics in an IT-enabled environment....More
It is crucial to move away from data and analytics stored on individual desktop computers. Today’s solutions must promote holistic, collective intelligence. The strong, continued alliance between Microsoft and Pyramid Analytics helps make all this possible....More
To become a truly data-driven enterprise, many business leaders recognize that they must extend the capabilities of self-service business intelligence (BI) and analytics to more of their business users. Many BI tools tackle part of this need, but they don’t offer a complete enterprise solution....More