(Sudeep G) Caching is one of the common techniques that is used to increase system and application performance. Caching is used by web applications to cache frequently used web pages. Some of the key considerations to caching data are if: · The data is expensive to create. · The data does not
Other News
I can’t get a zero-length string in PL/SQL
(Rex Baldazo) One of the things I wind up doing a lot in my code is looping thru some data structure, say an HTML option list or a SQL result set, and concatenating the results into a single string so that it can be printed to a text file or an HTML stream. One of the things you often want […]
Mini-Tip #17 – Converting a Script to a Procedure
(Lewis Cunningham) In my mini-tips I try to answer FAQs that I get either here on the blog or via email. I get the below question a lot. I recently received this email from a reader: So if I have an anonymous block that populates a table, how do I convert the block to a procedure, so I can sched
Using checkpoints in SQL Server Integration Services (SSIS) Packages to restart from the point of failure
(Ray Barley) We have a number of SSIS packages that routinely fail for various reasons such as a particular file is not found, an external FTP server is unavailable, etc. In most cases these error conditions are just a temporary situation and we can simply rerun the package at a later time and it w
MySQL Acquisition Issues with Sun
New SelectViews SQL Server Show [Watch Now] A SQL Server problem triage plan and approach, a pet peeve about open source, public domain software, current release versions and more. Also on the show, the 60-second SQL Server tip of the day, upcoming events, the newsletter and discussion list watches and other goodies. Also Available [Watch Now] SQL on Call – […]
(93) A SQL Server problem triage plan and approach, a pet peeve about open source, public domain software, current release versions and more.
Pro-Center Video Programming for IT Professionals
SharePoint, SQL on Call Show and More
New SQL on Call Show Posted [Watch Now] Your Questions – the show today is all about answering viewer questions about SQL Server! Interview questions, what are the top 10 SQL Server tasks, working with management and more. Editor’s note: Sorry about the incorrect link to the show yesterday. Featured Article(s) Introducing Windows SharePoint Services Microsoft Windows SharePoint Services presents […]
Matching, diffing and merging XML
(Daniel Ehrenberg) I’ve said bad things about my job working on Carleton College’s website, but fundamentally it’s a really sound work environment we have. Just before winter break, one of the full-time employees came to me and asked if I could make a diff between two XHTML documents for use in Carl
Finding System Parameter Changes
(Troy Coleman) The core of how DB2 is configured on z/OS is through system parameter macros. Commonly called zparms, these macros are stored in an assembled parameter module with a default name of DSNZPARM. The installation clist DSNTINST displays a series of ISPF panels that prompt you with questio
Ajax and XML: Ajax for forms
(Jack D Herrington) Augmenting your HTML forms with Asynchronous JavaScript + XML (Ajax) callbacks to the server is a practical way to add Web 2.0 functionality to your application. Discover a variety of techniques to add Ajax code and enhance the user experience for PHP applications.