(Cynthia Harvey) IBM has a grand dream for enterprise data management: to create a single toolset that can manage every aspect of the data life cycle. This toolset would offer built-in compliance and easy integration with other IBM tools. And it would work equally well with IBM data servers (includi
Other News
Backup and recovery in database systems
(John Charles Olamendy) This article is intended to cover one of the most critical responsibilities of database administrators in order to maintain data integrity. I will explain with some examples the main concepts of data backup and recovery in different database management systems.
Validation in ASP.NET 2.0
(Samer Salem) With the new advanced version of ASP.NET, enhancements have been done to the use of validations. One of which is that ASP.NET validations work on most browsers other than Internet Explorer. We will show in this article the six types of validations: RequiredFieldValidator, RangeValidato
The Primary Key That Wasn’t
(Kenneth Downs) Sometimes you get a situation where you have a great possibility for a natural key, except that the key will change from time to time. I call this the “Impermanent Primary Key” and we are going to look at this pattern today.
PL/SQL Associative Arrays
(Tyler Muth) I’ve known of PL/SQL Associative Arrays for quite a while, but never really used them before. Wow, I had no idea what I was missing! They’re particularly useful for name-value pair type arrays where you want to look up the value of a particular element without looping over the entire ar
IBM WebSphere Portal Web Content Manager and DB2 Tuning Guide
(Helmut K. C. Tessarek) Looking for a central source for tuning your WebSphere Portal Web Content Management and IBM DB2 for Linux, UNIX, and Windows environment? This article describes the different parts of the environment that are unique and require special consideration. You’ll learn how to tune
Usage of SQL Server Database Snapshots
(Dinesh Asanka) If you needed to analyse a database at a given time, what would you do? For example, say you wanted to analyse a database at 12:00PM, how would you do this? Most probably, you would create a schedule to create a backup at 12:00 PM and then restore the database into a database server
SQL Server 2008 – iFTS Introdction
(Simon Sabin) This is the first of a series of posts on the new Integrated Full Text feature in SQL Server 2008. This is one of my favourite features which I’ve had to keep stum about for quite a while.
SQL Server Alerts: Soup to Nuts
(Robyn Page and Phil Factor) To keep a database system running without hitches, you have to know of anything out of the ordinary that has happened. You need to know about events, error conditions, extreme loading, problems with the hardware, security issues, performance-related conditions, failed pr
Monitoring 101
(Ronald) Hands up those that don’t monitor their production MySQL web server. I’m a little surprised by this, but I’ve visited several clients that have absolutely no monitoring other then “the customers will tell us when something is wrong”. The lack of system monitoring is one of the topics in my