(Peter Bendel, Toni Bollinger, M. Eugenia Garcia and Stefan Warwas) These tutorials are designed to guide application designers and application developers through the process of gaining insight from data mining analysis to applying it in end user applications. Practical examples show how business
Author: SSWUG Research
Returning Result Sets from SQL Server and Oracle
You may need the Result Set from a Query in your .NET or Java Code by calling a Stored Procedure. Here are some samples for SQL Server and Oracle 10g.
.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
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
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
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.
Expression List Variations Select..Case Statement VB 2002-2005
(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..
CodeGen to create Fixed Audit Trail Triggers
(Paul Nielsen) Audit Trails – what a pain they can be. We all know that a dynamic audit trigger, that investigates the metadata and builds an audit insert statement on the fly, is easy to implement, but performs as well as my teenager gets up in the morning. A fixed audit trail trigger, hard-coded s
More on Web Syndication: Atom 1.0
(Ed Tittel) In previous tips on the subject of Web syndication we’ve dug into the Resource Description Framework (RDF) on which so much syndication information hangs, and have also looked into the differences between RSS versions, including what makes RSS 1.0 essentially and profoundly divergent fro
Mastering OLAP Reports: Parameters for Analysis Services Reporting, Pt. II
(William Pearson) A common enterprise reporting requirement among information consumers is the capability to filter reports at run time for specific information they need. This is typically managed via parameterization, also known as “prompting”, where the filter criteria is requested (and hence the