(Chris Eaton) In my last posting I discussed some backup basics including the basic backup command, how to specify a target for the backup, tablespace level backups and how DB2 backups are integrated into TSM. In this posting I’ll cover a bit more about online backups and also talk about incremental
Other News
Access XML data using LINQ to XML
(Tony Patton) I have covered the basics about .NET Language-Integrated Query (LINQ) and provided information on working with a SQL Server backend via LINQ. This article focuses on what I think is one of the more exciting aspects of the LINQ technology: working with XML. LINQ to XML offers a cleaner
Stored Procedures in MySQL
(George J. Trujillo Jr.) Stored procedures were introduced in the MySQL database server in version 5.0. It has been interesting to see the growth of stored procedures in the MySQL community because it is completely different with how stored procedures grew in the Oracle community.
First Steps
(Jim Mischel) Since we want the new Int128 to act just like the other integer types, we’ll implement all of the interfaces that the other types implement. The .NET documentation is quite helpful in this regard because it tells us which interfaces those types implement. The Int128 structure definitio
Understanding pureQuery, Part 2: Assist class modelers with data modeling
(Azadeh Ahadian) Learn how the features of pureQuery can assist you as an object-oriented developer to define a set of database relational artifacts using traditional class modeling.
Creating a Custom Data Field Control – Part 2
(Brian Mains) In my previous article I wrote about the basics of developing data control fields that can be used in the GridView or DetailsView field. This article will show some more concrete examples, using a more simplified approach by creating a custom base class that makes developing custom dat
WPF Basics: How To Add Controls Dynamically at Run Time
(Ged Mead) Adding controls at run time using VB.NET in Windows Forms is fairly well-documented. Finding C# code-behind samples for doing this with WPF controls under Framework 3.0 is also an easy task.
Oracle 10g Backup Guide: A Small County Government Approach
(Kevin E. Medlin) Database backups are one of the most important parts of a database administrator’s job. Backup strategies need to be reviewed on a regular basis. Backups themselves need to be tested frequently. This document offers one approach to database backups for Oracle 10g databases on Windo
SQL Server 2008 Spatial – What shape is a square?
(Simon Sabin) You think this an odd title, a square is a square. Well whilst that is the case in a planar 2D world in a 3 spatial world where the square is drawn on a sphere.
Non-trusted constraints
(Tibor Karaszi) A discussion in the newsgroups before the holidays lead to trusted constraints and performance. This inspired me to blog about it, but I decided to have some vacation first :-). Instead of having one long article, I’ll do a two-part. This one is about non-trusted constraints in gener