(Sam Alapati) You can manage the Oracle HTTP Server through the Application Server Control, or with the help of command-line tools.
Author: SSWUG Research
On importing data from Oracle into Excel with a Visual Basic for Application macro
(René Nyffenegger) I have been playing with Excel and its Visual Basic for Application (VBA) macros recently. As much as I loathe the syntax of VBA, I do like what can be done with it. Especially, I found it quite easy to connect to an Oracle Database with ADODB, execute a select statement and impor
Sizing Up Performance
(Mike Hichwa) As Oracle Application Express becomes more popular, many users are asking for guidance on sizing and performance tuning. In this column, I’ll show you a quick and convenient way to estimate performance and sizing. I’ll also demonstrate how to identify and deal with performance issues.
Improving ASP.NET Application Performance and Scalability
(Joydip Kanjilal) Many factors influence application performance, but in essence, the most important is to be aware of how to optimize your applications so they consume the least amount of memory and require the least amount of processing to produce the desired output in a managed environment.
How To Use Lazy Initialization with VB.NET and Visual Basic 2005
(Mike McIntyre) This is part one of a two part article and source code which explains the lazy initialization pattern and how to implement it in an order entry scenario with VB.NET and Visual Basic 2005. In object-oriented programming (OOP), lazy initialization is the strategy of improving applicati
PHP’s Building Blocks: Data Types, Literals, Variables, and Constants
(Ellie Quigley and Marko Gargenta) A program can do many things, including perform calculations, sort names, prepare phone lists, display images, play chess, ad infinitum. To do anything, however, the program works with the data that is given to it. Data types specify what kind of data, such as numb
Product Review: SQL Refactor
(Danny Lesandrini) Years ago, I created an Add-In for Microsoft Access that was a toolbox of sorts, and I called it the DataFast Utility. It’s still available for download, but never was anything more than a crude collection of scripts that I found personally useful. According to my records, it’s be
Clustered and non-clustered indexes in SQL Server
(Laurence Schwarz) When do I use a clustered index vs. a non-clustered index? This is somewhat of a tough question to answer, and frankly, the one I’m going to give is the age old standard database administrator’s answer; “It depends.” There are numerous factors into the when and where of index plac
Index Build strategy in SQL Server – Part 3: Offline Serial/Parallel Partitioning (Aligned partitioned parallel index build)
In case of parallel build we scan and sort partitions in parallel and the actual number of sort tables existing at the same time will depends on the actual number of concurrent workers. Partitions are being chosen by workers one by one and when one worker completes with one partition it takes the ne
Dynamically Templated GridView with Edit, Delete and Insert Options
(G Mohyuddin) In many situations we want to bind a fully, in-place operational GridView with a dynamically changing data source. This article shows how GridView can be templated programmatically at run time and how is it possible to do edit, insert and delete operations on it. Although just binding