A general solution for database backup and recovery depends on many aspects and is different for every mainframe shop. HP can provide an independent analysis of the customers’ situation and forecast a way to improve the current business by using new software and hardware techniques. This white paper
Other News
How to Ensure a Strong Oracle Password
(Lewis R Cunningham) Sophos recently blogged about weak passwords and the hashing mechanism in Oracle. Today I wanted to discuss how easy it is to ensure strong passwords in your database.
Using Secure Shell (ssh) with Database Partitioning Feature (DPF)
(Chris Eaton) If you are using DB2 DPF then you know that the db2start command will start up DB2 on all database partitions (across all servers) automatically. The way it does this internally is that it runs a remote shell on the remote partition and issues the start database manager code. As well,
An interview with Michael Rys
(Douglas Reilly) Dr. Michael Rys is the program manager for the SQL Server Engine Team at Microsoft. Michael also represents Microsoft on the W3C XQuery Working Group and has a seat on the SQL Standardization committee. He is also a co-author of XQuery from the Experts.
Thinking XML: Good advice for creating XML
(Uche Ogbuji) I have been discussing XML best practices in this column and in other series for years. Others, such as fellow columnist Elliotte Rusty Harold, have covered it as well. The more XML experts that join the discussion of XML design principles, the better, so the community can converge on
Understanding Access Modifiers in VB 2005
(Paul Kimmel) Access modifiers in Visual Basic .NET are represented by the four words—public, protected, friend, and private—that support a cornerstone of object-oriented programming (OOP): encapsulation. Encapsulation supports information hiding, and the general purpose of an access modifier is to
MDX Set Functions: DrillDownLevel()
(William Pearson) In this article, we will continue our examination, begun in Set Functions: The DRILLDOWNMEMBER() Function, of the MDX surrounding drilling up and down within our Analysis Services cubes. As we have noted, drilling up or down occurs along the lines of drilling paths that are defined
Boost Performance and Reduce Code Use With SQL Server Aggregate Functions
Aggregate functions, a staple means of summarizing large volumes of data for serious database developers, are mainly used for generating business data reports. Aggregate functions allow you to retrieve summarized information from a table by operating on a set of data as a whole rather than on each d
Data Access for Partially Connected Applications
(Markus Egger) All but the simplest applications store data in a central location and access it over a network. However, in many scenarios, distributed applications cannot assume a certain kind of network connection, both in terms of performance and reliability. In scenarios where users access their
Building Database-Driven PHP Applications on Oracle XML DB
(Yuli Vasiliev) Although, when working with Oracle XML DB from the PHP scripting language, you can still process XML data on the client side by using PHP’s XML extensions, there are many advantages to processing XML content inside the database, including the following: –Benefiting from the XML-s