Category: Backup Software Tags: Backup software, Restore softw Compatibility: SQL Server 7.x and later Description:
Other News
Tuning Up for OLTP and Data Warehousing
(Scott Hayes and Philip Gunning) At conferences and other speaking engagements, we often say we’ve never met a database whose performance we couldn’t improve. We’re willing to put that claim in print and share tips and tricks gleaned from our combined 22 years’ experience with DB2 Universal Database
DB2 stored procedures and dynamic cursors
(Tim Albrecht) With a more complete implementation of stored procedures in DB2 Versions 5 and 6, many new distributed access opportunities have been given to the DB2 developer. Many shops, ours included, severely limited or completely denied Dynamic SQL access to operational Online Transaction proce
Highly Available DB2 Universal Database using Tivoli System Automation for Linux
(Enrico Joedecke, Steve Raspudic and Andy Beaton) In this paper, we describe the implementation and design of highly available IBM DB2 Universal Database (DB2) environments in conjunction with the IBM Tivoli System Automation for Linux platform (TSA). Also included is a detailed description of the D
Using libferris with XML
(Ben Martin) This article presents the benefits of using libferris with your XML applications. libferris presents a uniform interface to hierarchical data. This data can be persisted using many providers including the filesystem, an RDBMS, or even XML. All the data providers in libferris are made av
Data Access and XML From 2- to N-Tier
(Steve Lasker) Visual Studio “Whidbey” leverages existing ADO.NET and XML investments, and enables developers to perform data access tasks in drastically fewer steps and fewer lines of code. Watch this video to explore creating data access components complete with custom validation logic, consuming
Merging datasets with NULL values
(Carmen Beitzer) The MERGE functionality introduced in Oracle9i offers a simplified, yet powerful enhancement to the commonly known UPSERT approach of earlier editions. Just as its predecessor, MERGE is a valuable functionality when integrating same datasets over time, (i.e. when extracting incremen
Cleaning Up XML
(Adam Kolawa) Garbage in, garbage out – it’s an axiom that applies to many aspects of enterprise development, but none more so than building reliable and robust Web applications and integration projects with XML. Since its inception, XML has been seen as the cure-all for every problem related to Web
Everything you wanted to know about Stored Procedures
(Himanshu Khatri) Stored procedures can offer performance gains when used instead of regular queries. This article will start with the basics and give you the complete overview on stored procedures and how to use them. Have you ever thought what happens when your queries get to the database?. They a
UDFs Endanger Performance
(Brian Moran) Three of my last five performance-tuning clients faced problems associated with user-defined functions (UDFs). As SQL Server 2000’s customer base matures and becomes more comfortable with the product’s advanced features, more people are using UDFs without recognizing the problems they