(Mike McIntyre) The Select…Case statement is used to execute one of several groups of statements, depending on the value of an expression. This article and source code reviews and demonstrates different possible ways to vary the expression list used to test the value of an expression in a Select..
Other News
ILDASM and Obfuscation in .NET
(Sandeep Acharya) ILDASM and Obfuscator. These two words are not very common to the beginners of .NET. So before going over these two things, we must know their background. First, we have to know what is the significance of ILDASM and Obfuscation.
Exploring Secrets of Windows Form Validation
(Michael Sorens) Input validation is something that every program needs, and every programmer dreads. Most developers craft hard-coded program logic to verify that a phone number consists of 7 or 10 digits; that an IP address consists of 4 octets; that a country name matches 1 of 193 choices, etc. W
Easy code archiving in SQL Server 2005
(Tim Chapman) As a database administrator, I always try to give code that I promote to our production environments a thorough look before the move is made. However, as much as I hate to admit it, I can’t catch everything that may disrupt our production system. When these situations occur, sometimes
.NET Application Extensibility
(Jack Gudenkauf and Jesse Kaplan) The Microsoft .NET Framework has made it very easy to take components built by different developers and companies and integrate them into your own applications. But it’s only easy if you know which components you’re building against. If those components are not know
BMC Recovery Manager for DB2 UDB Recoverable Load Made Simple
In the complex world of global business, every database operation needs to be done very quickly to cope with constant data changes. There are many ways to perform database operations quickly, but most are very complex. Is there anybbody who makes these complex operations simple, to help DBAs get the
Interesting V8 SQL Change
(Willie Favero) We spend a lot of time talking about the really neat stuff like multi-row FETCH & INSERT and such because they give you some significant CPU back when you change your applications to take advantage of them. However, DB2 for z/OS Version 8 had a lot of SQL added and enhanced. So today
Parsing XML As Query Object In Coldfusion
(Ben Cortese) I work in the financial industry as a developer and not that the financial industry has any greater implementation of XML than any other, but web applications that utilize back office processing for loan applications, or new account opening processes, or retail internet banking applica
Using EXPLAIN EXTENDED to see view query rewrites
(Guy Harrison) At the MySQL Mini Conference in Sydney this week we discussed how to use EXPLAIN EXTENDED to view the rewrites undertaken by the MySQL optimizer. IN particular, to see if MySQL performs a merge of the query into the view definition, or if it creates a temporary table.
Inversion of Control (IoC) in XAML
(Vincent-Philippe Lauzon) The code presented here allows the use of XAML to implement the Inversion of Control pattern (IoC, also known as Dependency Injection).