Examining the Oracle Database 10053 Trace Event Dump File7/29 Ever wonder what the Oracle Database Cost Based Optimizer (CBO) was doing behind the scenes or how it comes up with an execution plan? While other tools or settings show us WHAT the CBO comes up with, the 10053 trace event setting tells us HOW the CBO came to its decision (the final execution plan).
Building a Data Warehouse Blueprint for Success7/28 One of the most integral components and critical success factors of any enterprise data warehousing initiative is the Solutions Architecture document, a high-level conceptual model of a data warehousing solution. Learn why this collaborative effort that addresses the needs of all major stakeholders, including both the business units and Information Technology (IT), is essential.
I/O Performance Tuning Tools for Oracle Database 11gR27/28 Oracle Database 11g Release 2 (11gR2) makes it easier than ever to isolate and identify potential root causes of poor I/O performance. This article focuses on the various Oracle and non-Oracle tools to generate sample workloads to provide sufficient metrics for detection and eventual resolution of performance bottlenecks within the database's underlying input/output (I/O) subsystem.
Five Handy Tips for MySQL's Powerful UPDATE Statement7/27 Rob Gravelle explores the MySQL UPDATE statement, which is used to modify existing records in a table. Among its many features, he looks at how to update multiple tables, avoiding mistakes, and how to limit how many rows are updated.
Implementing SSIS Package Configurations7/26 Marcin Policht demonstrates how to leverage SQL Server Integration Services (SSIS) package variables in order to modify SSIS properties without directly editing package content.
IBM DB2 pureScale: The Next Big Thing or a Solution Looking for a Problem?7/26 In October 2009, IBM announced that some rather neat technology known as data sharing would be delivered for the IBM DB2 for Linux, Unix and Windows product, in an optional facility dubbed pureScale. Julian Stuhler takes a closer look at this technology and the possible implications for the entire IBM DB2 world.
IBM DB2/400 Mobile Access with SystemObjects Tool
SystemObjects has deployed Business4Mobile, a development tool for the IBM I platform; allowing for the creation of applications that run on smart mobile devices and access System I, among others, database servers.
Connecting to Twitter Using Zend By Jason Gilmore
Published July 22, 2010
This screencast introduces you to the Zend Framework's Twitter component, which makes it trivial to perform tasks such as posting updates to your Twitter account and retrieving the latest updates from your contacts.
Integrating Office Applications with Silverlight 4 By Jani Jarvinen
Published July 8, 2010
This screencast shows you how you can work with Microsoft Office applications such as Word and Excel from a Silverlight 4 application. Watch this screencast to get started with out-of-browser applications and the COM interoperability features.
Storing Blobs in Microsoft Azure with the Zend Framework By Jason Gilmore
Published June 23, 2010
This screencast discusses the fundamental concepts behind storing blobs within the Microsoft Azure cloud using the popular Zend Framework's Zend_Service_WindowsAzure component.
OData: Open Data for the Open Web By Dan Rigsby
Published June 10, 2010
Learn what OData is all about and how to produce and consume OData feeds in the .NET framework.
ReportsMaestro (ReportsMaestro) ReportsMaestro builds highly customizable, real-time charts and reports. Select from multiple chart/report types and create and share your own interactive dashboards on the web.
ChronicDB (ChronicDB) Offers live database updates and schema changes without bringing the database management system down at all.
