(Eddie Awad) Avoid standalone procedures and functions and always use packages to construct your application. That is one of the “best practices” when developing Oracle PL/SQL programs.
Author: SSWUG Research
Installing and configuring WebSphere Portal V6.0 Servers for development with Rational Application Developer V7.0 and Rational Software Architect V7.0
(Donal Riordan) IBM Rational Application Developer V7.0 and IBM Rational Software Architect V7.0 are the first products in the IBM Rational Software Delivery Platform range of products to include full-featured support for IBM WebSphere Portal V6.0 development. This means that you can develop with th
Four Ways to Optimize Your MySQL Database
(Jason Gilmore) From its inception, speed has been a strong point of the MySQL database server. In fact, its developers have long been cautious to add new features at the expense of performance even when faced by withering pressure from detractors. Yet over time MySQL’s features caught up with its b
Extending the XML data model to XFDL forms using IBM Workplace Forms V2.6
(Kiat Sing Lai) Learn how to separate a form’s data layer from its presentation layer by using XML data model with IBM Workplace Forms. IBM Workplace Forms provides the set of interfaces you need to create e-forms that maintain the non-repudiation and auditability features of paper-based forms.
How I created my first table controlled partitioned tablespace by mistake
(Omer Brandis) I have a short story to tell, its all about how I created my first table controlled partitioned tablespace by mistake. I do hope that by sharing this sad story, I’ll help someone else to not make the same mistake, so here goes:
Getting Started with ASP.NET
(Jeff Cogswell) Ready to get started with ASP.NET? Great! Here’s what you’ll need. –If you don’t yet have the Microsoft .NET 2.0 runtime, download and install it here. –If you don’t already have Visual Studio 2005, then download and install the free Visual Web Developer 2005 Expression Editio
Using and Managing Database Mail
(Gregory A. Larsen) With SQL Server 2005 comes a new mail sub-system, called Database Mail. Database Mail is a great improvement over SQL Mail that came with earlier versions of SQL Server. Now you are able to set up multiple accounts and profiles to support your different application email needs. T
Calling Web Services Asynchronously with ASP.NET
(Dan Wahlin) This video tutorial walks you through the fundamentals of calling Web Services asynchronously from an ASP.NET page using the .NET 2.0 event driven model exposed by Web Service proxy objects. There are several different options for calling Web Services asynchronously including polling, c
Customizing and Managing Your Site’s Appearance with ASP.NET 2.0 Tools
(Randy Connolly) The previous chapters introduced many of the standard Web server controls. This section returns to the coverage of Web server controls by demonstrating how to more fully customize the appearance of these controls. The chapter does so in two ways. The first way uses common formatting
Turn AUTO_SHRINK off!!
(Paul Randal) This week’s topic is data file shrinking. I’ve seen lots of mis-information in the last few weeks and I’ve had a bunch of questions about it. First up is auto-shrink.