(Dwaine Snow) Learn skills that help you to properly manage your DB2 database servers. This is the first in a series of seven DB2 9 DBA certification prep tutorials that you can use to help prepare for the DB2 V9 for Linux, UNIX, and Windows Database Administration (Exam 731). (R)
Author: SSWUG Research
Installing 10gR2 Database Software
(Tarry Singh) I keep getting offers all the time–contracts in which I have to install databases (RAC or Standard) for clients. Every time, I have to go through the rigmarole of preparing and then installing the database. It is good, it pays me well per hour, but is it smart? I don’t think so. VMwar
Migrating from Oracle 10G XE to SQL Anywhere 10
(Jayaram Krishnaswamy) In a previous article, a set of tables from Oracle 10G XE were transferred to SQL 2005 Server using SQL 2005 Server’s Export/Import Wizard. This article is about migrating a table from Oracle 10G XE to SQL Anywhere 10.
Demystifying .NET compilation
(Lamont Adams) As a code-execution platform, Microsoft .NET is a bit more complicated than what has come before it. The support for multiple-source languages and (in theory, at least) multiple platforms required the addition of an intermediate layer between the traditional two levels of code: source
Transform your SQL scripts with SQL Prettifier
(Phil Factor) The SQL Prettifier converts monochrome SQL code into colourful HTML. I was driven to write it by my frustration at having to paste dull monochrome, badly-formatted SQL code into blogs and forums. Not only was the code in monochrome, but the columns never lined up and strange things hap
Document-level security using DB2 9 pureXML and LBAC
(Brian M. Williams) DB2 9 pureXML provides native XML storage and retrieval. In addition, DB2 9 provides a new security protection mechanism called Label Based Access Control (LBAC). Combining these two features can produce a Native XML data store that can protect XML documents at the document level
DBA from Crisis to Confidence
(Sreeram Surapaneni) Every DBA needs to know how to do their work under pressure, while facing crisis after crisis. Our most important contribution is to keep the database running. It’s an on-call function; you never know what might happen. Half the branch was up all night last night restoring a dat
An Introduction to LINQ – Part 1
(Thiru Thangarathinam) Most programmers today are required to integrate some sort of data into their applications. Often, you have to take data from multiple sources such as memory collections, relational databases, XML files, etc. With the current implementation of .NET Framework, getting to this d
.NET Enum The Next Level
(mikeperetz) In this article I am going to try to provide an alternative way to use enumeration in .NET, I like using enumeration because it is type-safe and makes the code easier to read. However, there has been always something that I didn’t like about enums. Enums are designed to work only with n
Creating Dynamic Web Sites with PHP and MySQL
(Larry Ullman) With the fundamentals of PHP under your belt, it’s time to begin building truly dynamic Web sites. Dynamic Web sites, as opposed to the static ones on which the Web was first built, are easier to maintain, are more responsive to users, and can alter their appearance based upon differi