(Desirée Harris) A database move can be done a couple different ways, but when the database is updated frequently and the move needs to be completed with minimal downtime and no data loss, it is best to move it by detaching and then reattaching the database on the new server. The database will be of
Other News
SQL Server Transactions and Error Handling
(Saumendra Poddar) Transactions group a set of tasks into a single execution unit. Each transaction begins with a specific task and ends when all the tasks in the group successfully complete. If any of the tasks fails, the transaction fails. Therefore, a transaction has only two results: success or
Best Practices for Advanced Data Persistence in Enterprise .NET
(Greg Aloi and Tobias Grasl) The .NET framework has become the platform of choice for many enterprise applications. Not surprisingly, many .NET concepts parallel those in CORBA and J2EE. The benefit of hindsight gives .NET architects and developers the opportunity to imitate the success while avoidi
Building a Template Parser Class with PHP, Part II
(Alejandro Gervasio) In part one of this two part article series, you learned how to build a simple template parser class in PHP. In this second article, you will learn how to add caching capabilities to the class.
Determine How Deep FK Constraints – Alternate Version
(Zlatko Sirotic) This is an alternate version of a previous Tip of the Week, “Determine How Deep FK Constraints”, from February 16, 2003. This new version uses a packaged associative array.
Good Migrations
(Jeanne Kays and Roger Miller) DB2 Universal Database Version 8 (DB2 UDB V8) for z/OS offers significant opportunities for improvement in six key areas without a lot of added effort. They are: –High availability –Scalability and benefits for very large databases –Increased productivity of J
‘A Picture’s Worth A Thousand Words’: The IBM DB2 Universal Database Spatial Extender
(Paul C. Zikopoulos) I know it’s an old saying, but it certainly is an accurate one in this case. Visualizing data makes it easier to understand and act on. In fact, quite often, patterns or correlations that you never thought existed suddenly become apparent with visualization. The IBM DB2 Univ
Oracle reassures Retek workers
(Mike Meyers) Oracle Corp. senior executives came to town to promise employees and customers that Retek Inc., the Minneapolis software company they recently agreed to acquire, isn’t headed for wrenching changes.
Understanding dimensions in an OLAP solution
(Arthur Fuller) Relational databases are by definition two-dimensional—rows and columns. Online analytical processing (OLAP) databases introduce additional dimensions, which you can think of as perspectives or vantage points. Discover why it’s important to have a clear grasp of what dimensions are a
Bandwidth planning for disaster recovery systems
(Mike Talon) Bandwidth is always an issue in disaster recovery, even if you’re not planning to send data between sites. If you’re using only tape devices, then your bandwidth concerns are limited. If you’re replicating data for potential failover—both locally and remotely—then your bandwidth issues