|
Database Management & Programming News, Articles & Tutorials for Database Administrators
7/21 Learn how you too can stamp out common database errors and learn a lot about relational databases along the way. 'Ambiguous Groups' is extracted from 'SQL Antipatterns', published by the Pragmatic Bookshelf. 7/21 Constantly watching CPU utilization is critical to a database administrator's understanding of their database system. The sar utility, while seemingly small and insignificant can and should be used to help initially determine if any high-level CPU resource usage is out of balance, potentially pointing to database processing that requires tuning. 7/20 Multi-master MySQL provides a database administrator with a host of new features. Sean Hull discusses how multi-master MySQL aids the DBA in areas of database administration that can negatively impact performance of the primary database.
7/19 Many critical business applications now execute in an environment separate from that of the enterprise database server. The database administrator often finds monitoring and performance tuning of these "distributed" applications to be especially difficult. This article looks at common performance issues of distributed applications and presents advice to assist the IBM DB2 database administrator in mitigating performance problems. 7/16 SQL can support the creation of variable hierarchical structures in a number of differently controlled operations that can be combined. Michael M. David describes a powerful and flexible automatic method of dynamic structure generation. 7/15 Oracle's software is freely available for personal use but you'll have to pay for access to technical notes, patches, and other specialized content. Plus, there's a technical/legal catch; you can't use My Own Support to find database articles under a different product license. In terms of compliance, you really need a database product. Enter Oracle Database Personal Edition.
O’Reily open source convention has announced the availability of DB Relay that enables easy database access for web application development.
Perform advanced analytics and provide geospatial intelligence in a combined solution from Teradata and ESRI.
Canonical offers IBM DB2 on Linux-based servers for cloud setup.
Will the biggest maker of business software be able to extend the Sybase database to rival that of Oracle?
Platform-as-a-service (PaaS) provider Heroku addes NoSQL data stores to help accelerated cloud development.
Just a couple weeks left to get your Oracle database or application abstract in for review to the UKOUG Conference Series.
The CPU update for the Oracle database keys in on CVE-2010-0902 as a most dangerous vulnerability.
Through their wholly-owned subsidiary, Sheffield Acquisition Corp., SAP has extended their offer to acquire Sybase, Inc.
More Database News...
DBA Videos
|
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.
|
|
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.
|
|
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.
|
|
By Jason Gilmore
Published May 28, 2010
This screencast introduces the Zend_Db component, showing you how to use the component's basic features to successfully interact with your database.
|
(More Videos)
Receive news via our XML/RSS
feed
 
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. Offers live database updates and schema changes without bringing the database management system down at all.
Debugger for MySQL is a handy framework to develop, test and debug MySQL procedures and functions.

|