(Willie Favero) It’s here and it’s official. Today, Tuesday, March 6, 2007, just one short month after the End of Service announcement for DB2 Version 7 (see my post last month discussing EoS “17 months and getting closer everyday… DB2 Version 7 EoS announcement”), IBM announces the general availab
Author: SSWUG Research
Creating a CascadingDropDown Using AJAX
(Electronic Screw) I have seen in many forums people asking questions as “how to populate the cascadingdropdown with values from database.” Although there was a sample provided for the same in the ASP.NET AJAX ControlToolkit, most of the learners (novice) following the walkthrough given at http://aj
ANALYSIS: Oracle Shows No Momentum In Linux Effort
Oracle promised to take the Linux software world by storm last October, but the major expansion by one of the world’s largest software companies so far has failed to show momentum.
(56) Information Lifecycle Management, SQL 2k5 SP2(a), OneCare Issue and More
Pro-Center Video Programming for IT Professionals
How to find out if an outer join was converted to inner
(Sergey Petrunia) After this post I’ve got a question how one can tell if his outer join was converted to inner. You can find it out by looking at the warning generated by EXPLAIN EXTENDED.
Validating ASP.NET Query Strings
(Dino Esposito) For years, classic ASP developers implemented page authentication by inserting some generic code at the top of each page that would grab user credentials, attach a cookie, and redirect. All that repetitive code was swept away by the ASP.NET HTTP modules for authentication. As a resul
SQL 2005 Maintenance Wizard Part 2
(Don Schlichting) SQL 2005 includes a graphical tool called the Maintenance Plan Wizard that can be used to create database optimization and integrity checking packages. Some of the tasks the Maintenance Plan Wizard can orchestrate include backing up the database, reorganizing data and index files,
Understanding Full Text Searching Compared with LIKE
(Simon Sabin) One of the most common questions that comes up on the newsgroups is around searching for terms containing punctuation. The questions are normally something like “I’m trying to use Full Text to search my product catalog, when someone enters a product code the results I get back are o
Using Perl with the Informix Dynamic Server
(Daniel Hebert) This tutorial takes you through the process of setting up the Perl Database Interface (DBI) to work with the IBM Informix Dynamic Server (IDS). See examples of how to exercise a variety of DBI features and learn how to configure CPAN module installation, driver installation, script a
Paging records in SQL Server 2005, SQL Server 2000, MS Access and MySQL
(Erwin@ODS) As a Web developer, you should know by now that using the default paging capabilities of ASP.NET Webcontrols like DataGrid and GridView is NOT recommended, simply because with every roundtrip to the data-server, you get ALL the records ALL of the time. This is fine perhaps for very small