(Hamid Minoui) Managing space in a data warehouse environment is often one of the most challenging tasks for data warehouse database administrators. Not only are there many data files and tablespaces to manage, but the size of individual segments and partitions tends to be very large. This white pap
Author: SSWUG Research
Handling the Client-Side onblur event of an asp:TextBox wth Server-Side code
(Brett Burch) A recent project required me to handle more client-side events than the usual click, onchange and submit events that are easily wired up with the .Net framework. Here’s a way to handle additional client-side events with server-side code. WARNING: This does involve what I would consider
How the Oracle Enterprise Technology Center Scaled its Storage Infrastructure to Meet Customer Demand
As its largest hands-on training facility, Oracle’s Enterprise Technology Center (ETC) is used by Oracle and its customers to develop, demonstrate, and test Oracle solutions in a full-scale enterprise environment. But prior to a February 2005 storage upgrade, capacity limitations prevented the Oracl
When Should You Use Microsoft SQL Server Over Microsoft Access?
(Chris Le Roy) Microsoft Access databases have certainly become more prevalent over the last 2 years as large corporations break the imposed ban on using the tool. Many of our large corporate clients and government clients have stymied development in Microsoft Access for varying reasons which can in
Build a Package Using the Visual Studio Extensibility SDK in Three Easy Steps
(Justin Whitney) Of all the ways you can extend your Visual Studio environment, packages are easily the most intimidating. But you’ll be downright surprised at how easily you can build one. Like a good game, building a package is simple to learn and challenging to master. But also like a good game,
Ideas for Improving ASP and ASP.NET Web Application Security – Part 1
(Brett Burridge) Hackers and other people with dubious intentions are always on the lookout for websites that display technical error messages. ASP or ASP.NET error messages are often useful to such people. In some cases the hackers can actually think of ways of causing the error messages to appea
Automating Control Validation and ToolTips in Visual Studio 2005
(David Catherman) Visual Studio 2005 Windows Forms has some new extended provider components that allow ToolTips and validation error messages to be assigned to individual controls, but the process requires a fair amount of developer time in large projects. A better way is to automate the process to
Oracle’s FIPS Flagger
(James F. Koopmann) FIPS stands for Federal Information Processing Standards which includes which include a set of standards and guidelines for governments. Included are requirements for SQL to meet a set of standards. Wow! What a mouthfull. Really if you care about this you should do a search on th
AJAX Document Management – AJAX Document Viewer
(Christopher Krause) Forms are an essential part of many business or administration processes: Tax declarations, travel expense reports or an annual budget request. They offer a simple means of structuring data entered by an end user.
Distribution statistics uses with the DB2 optimizer
(Dirk Fechner) The DB2 optimizer is a cost-based optimizer. It makes decisions based on statistics that are available for the tables and indexes. When generating statistics, DB2 offers the possibility to create so-called distribution statistics, in addition to the basic statistics. This article expl