(Robert Brunner) Along with creating a database schema and populating tables with data, being able to selectively modify data is one of the most important skills necessary for a database developer. This article teaches you how to selectively delete or update data in an existing table and how to modi
Author: SSWUG Research
Redirected Restore Script Builder
(Chris Eaton) Have you ever done a redirected restore? Did you enjoy it? Probably not. It’s a great capability but it is not the easiest thing to do. Before I dive into it let me first explain for those not familiar with DB2 what a redirected restore is.
Localization Made Easy with ASP.NET 2.0
(Manoj Agarwal) Do you have an ASP.NET application ready and now you want to translate it into different languages, or are you developing a new application for which you want to support localization? If yes, ASP.NET 2.0 makes it easier than ever before to do so.
Create an XML-based application using DB2 9
(Naveen Balani and Rajeev Hathi) Learn to create a sample application that uses XML as the data persistence mechanism using DB2 9. Create a Java-based application that inserts and retrieves XML elements, using powerful DB2 9 XML features. (R)
Security Inside
(David A. Kelly) Creating a data security strategy that fits your business is more than simply ensuring that basic access controls are defined or proper firewalls are in place. Having a comprehensive security plan means going beyond traditional security approaches to find flexible solutions that can
Generic Dictionaries: Hidden Treasure of System.Collections.Generic
(Bill Woodruff) The Dictionary class in .NET 2.0’s System.Colllections.Generic namespace provides the ability to create a strongly-typed dictionary where both the Keys and Values collections can accept any object-type. This capability enables novel solutions to typical programming problems—for examp
Asynchronous Processing in .NET Part 2
(Julian Skinner) In Part 1, we looked at the fundamentals of asynchronous processing in .NET, and we saw that subtle bugs known as race conditions can occur if threads are not correctly synchronized. We have no way of knowing at what point the operating system will switch execution between threads:
Create Predicates from Expressions for use with Generic collections
(Tim Kohler) I’m really a SQL nut. I love working in terms of sets and try to avoid looping where possible in favor of set based operations. One thing that caught my eye are the predicates and actions that are now in the 2.0 framework. They are part of generics.
Retrieving Data Using the MySQL SELECT Statement
(Chris Newman) In this lesson, you learn how to use a SELECT statement to fetch records from a MySQL database.
Track resource usage with SQL Server 2005 SQL OS
(Jeremy Kadlec) To achieve optimal performance, SQL Server and Windows depend on one another, as does Windows and the hardware platform. A problem in any one area can severely impact the other two. Unfortunately, gleaning insight into SQL Server’s hardware usage through Windows in any supported mann