(Wes Dumey) In Part 2 of this series, Wes Dumey talks about some of the key tables in a data warehousing scenario. He covers fact tables, dimensions and some of the other tables you’ll see in a data warehouse. (video)
Author: SSWUG Research
Utilize the Exception Handling Block in .NET-based apps
(Tony Patton) Discover how the Microsoft Enterprise Library’s Exception Handling Block configuration program makes it easy to set up exception policies that are used in application code.
How to Use Oracle (16) – What happens when you run a SQL statement?
(Dratz) This part of the series shows what the Oracle SQL engine does in a nutshell.
Using Custom Tasks in MSBuild to modify XML Configuration Files on the Fly
(Mike Gold) Part of our deployment process at work is to not only build the .NET applications, but to go through a bunch of XML configuration files and change the tags contained within them manually. That drudge work is starting to get old, so I figured, why not automate the process. The first th
Search text with new Perl-like regular expressions in Oracle 10gR2
(Bob Watkins) Oracle 10g Release 1 added support for POSIX regular expressions for matching patterns in text strings. Release 2 extended the initial list of pattern metacharacters, with additional ones found in Perl. If you’re developing scripts against Oracle 10gR2, check out these nifty shortcuts
IBM releases DB2 email archiving hardware and software
(Shamus McGillicuddy) IBM says its new email archiving appliance is so easy to install that small and medium-size businesses can have it up and running in less than a day. (R)
Harden code to prevent SQL injection
(Kevin Beaver) Never trust user input — it’s a cornerstone of secure coding, right? True, but why is SQL injection still occurring? Isn’t everyone validating all user input these days? If it were only that simple! The fact is given the complexities of your applications and the time crunch to re
Identify Large Indexes
(Vishwamithran S.) Large numbers of deletes or updates occurring within a table sometime leave relevant indexes larger than their table sizes. The following script is designed to identify these indexes and help to schedule a rebuild of them, after choosing appropriate storage parameters.
Optimizing for Query Speed
(Paul Dubois) This chapter discusses general principles that are useful for optimizing queries to run more efficiently.
The Java XML Validation API
(Elliotte Rusty Harold) Validation is a powerful tool. It enables you to quickly check that input is roughly in the form you expect and quickly reject any document that is too far away from what your process can handle. If there’s a problem with the data, it’s better to find out earlier than later.