(Ged Mead) This is something that seems to come up fairly often in the Forums. Someone wants to test for a particular value in a ListBox and if the list does (or doesn’t) contain the value then that item is to be deleted.
Other News
OOXML: What’s the big deal?
(Peter Seebach) The OOXML specification has been both criticized and defended by a number of people, leading many to wonder what the big deal is. This article illustrates the basis of technical, rather than political, objections to treating OOXML as a standard.
DB2 9.5 and IBM Data Studio: Part 7: The SQL Builder’s Development Accelerators
(Paul Zikopoulos) So far in this series about the IBM Data Studio Developer integrated development environment (IDE) that’s available with DB2 Version 9.5 (DB2 9.5), I’ve shown you how to set up database connection objects and the actions that you can perform on them. In addition, I introduced you (
.NET Tip: Receive Notification When a File is Updated
(Jay Miller) Using the FileSystemWatcher class provides you with a very simple but flexible way to monitor the file system. It can be used to monitor directories, individual files, or groups of files. It also can be configured only to notify your application of certain types of changes. For this exa
ANSI Outer Joins And Lateral Views
(Greg Rahn) A few months ago the Oracle Optimizer Team did a blog post entitled Outerjoins in Oracle. In the Lateral View section of that post they go through some examples and discuss how a query is transformed with the ANSI outer join syntax. I thought it would be useful to go through an example t
Capturing SQL Server 2005 database file size information
(Tim Chapman) It’s very important to capture trends of the sizes of your SQL Server 2005 database because it allows you to plan for future space needs, notice types of problems, and plan for time periods of heavy volume. I’ll show you the simple method that I use to capture this information.
How to convert a table column to another data type
(Leo Hsu and Regina Obe) As Robert Treat pointed out in our PostgreSQL 8.3 is out and the Project Moves On, one of the features that was introduced in PostgreSQL 8.0 was the syntax of ALTER TABLE sometable ALTER COLUMN somecolumn TYPE new_data_type USING some_function_call_to_cast(somecolumn);
Which SQL Server 2008 Authentication Mechanism Should I Choose?
(Ross Mistry) At present, SQL Server 2008 continues to support two modes for validating connections and authenticating access to database resources: (Windows Authentication Mode) and (SQL Server and Windows Authentication Mode) also known as “Mixed Mode”. Both of these authentication methods provid
Sequence Enhancement in Oracle 11g
Starting with Oracle 11g, we can use sequences with straight variable assignment. Before 11g, we always have to use SELECT INTO clause to get sequence value in the variable. It is not a major change but just makes it easier to use. Let us see it with an example. We will first create a sequence.
Index Rebuild vs. Coalesce vs. Shrink Space (Pigs – 3 Different Ones)
(Richard Foote) Previously, I discussed how an ALTER INDEX … COALESCE is going to be less expensive in terms of using resources than an equivalent ALTER INDEX … SHRINK SPACE COMPACT (or ALTER INDEX … SHRINK SPACE) as the Coalesce doesn’t have to concern itself with ensuring all leaf blocks at the p