Database management system DBMS architecture design and strategy
- December 11, 2007
Putting together a comprehensive data migration plan now can help firms avoid serious downtime later, according to experts.
- December 04, 2007
Data migration processes are slowly evolving from hand-coded scripts toward packaged applications. Find out why more companies are using tools for data migration.
- October 23, 2007
Gartner's data warehouse DBMS Magic Quadrant 2007 includes familiar names offering new technologies that meet the demands of old IT mantras.
- August 03, 2007
IBM today announced plans to buy Princeton Softech -- which makes data management, archiving and classification software -- to bolster its Information on Demand initiative.
- May 30, 2007
IBM's DB2 9 Viper can manage XML and relational data in one database. An analyst says IBM's architecture is unique -- and that other vendors might not appreciate the challenge.
- December 19, 2006
Data management skills are in demand, but inconsistent job titles and descriptions can make finding data management jobs tough. Learn what employers seek and how DAMA may help.
- December 14, 2006
Oracle's Database 11g enhancements focus on XML DB and include a new binary XML data type, a new XML index and enhanced support for XQuery and other emerging standards
- September 28, 2006
The new version of Berkeley DB, the embeddable database Oracle acquired along with open source stalwart Sleepycat Software, promises better performance and the ability to do upgrades on the fly. But does Oracle really have open source street ...
- September 25, 2006
Gartner's new Magic Quadrant for data warehouse software and DBMS systems finds that mixed workloads, new appliances and pricing pressures are all affecting the market.
- August 10, 2006
Restoring your SQL Server 7.0 or 2000 machine to 2005 may be fairly straightforward. Restoring an earlier version is another story entirely. Edgewood Solutions' Greg Robidoux explains how to restore an older database to a new SQL Server 2005.
- August 02, 2006
Write and run SQL Server stored procedures more effectively. This collection of FAQs will start you on the path to working with useful T-SQL routines.
- August 02, 2006
Discover syntax differences between SQL Server and MySQL, code for a timestamp automation workaround and why it's important to keep your version of MySQL current.
- August 01, 2006
SQL Server 2005 index partitioning allows you to distribute the load for a given index across multiple files to improve performance. Contributor Serdar Yegulalp explains how it differs from SQL Server 2000 partition views and how to create an index ...
- July 27, 2006
Determining who issued SQL Server backup and restores and when they occurred is no simple task -- unless you have these stored procedures.
- July 21, 2006
There is often a disconnect between developers and DBAs. Bridging the gap between database design/development and operations management can make the difference between an efficient, well-managed business application and one that fails to meet ...