(Jayaram Krishnaswamy) Enterprises have data stored in different kinds of databases from flat-files to relational databases. It is often necessary to generate reports from disparate databases. The rapid application development that is possible with MS Access allows one to rapidly deploy the report
Author: SSWUG Research
Have it Your Way: Customizing Work Items in Team Foundation Server
(Michael Jones) With the release of Visual Studio 2005 Team Edition last year and Team Foundation Server in March of this year, Microsoft delivered arguably one of the largest functional upgrades to the Visual Studio line of tools in years. When used with Team Foundation Server, Visual Studio Team E
Master Page Templates in ASP.NET (Part 1)
(Julian Roberts) In Classic ASP, developers will use include files to give each page a consistant look and feel. When the include file(s) are changed, those changes are also reflected on the parent pages. This makes a website quite maintainable. Although, the main drawback of this methodology is tha
Types of Tables in Oracle
(Steve Callan) If a co-worker were to ask you to name as many Oracle table types as you can, what would be in your list? More than likely you would start off with relational, object, “normal,” cluster, index-organized, nested, partitioned, and so on. “No, not those table types,” your friend says, “I
Recover database from only tablespace backups
(Chris Eaton) In DB2 v8 it was not possible to recover an entire database (from scratch) just from tablespace level backups. You had to start with at least a full backup image. Now in DB2 9 you can recover a database or even just a part of a database from scratch entirely from tablespace level backu
Web Services Notification
(Daniel Rubio) Web services are a boon when it comes to achieving a loosely coupled architecture since they are not locked down to a specific platform provider or consumer. In principle, this design is optimal for many enterprise settings, but also comes with its shortcomings. Up next we will addres
Learn How to Write Well-Formed and Valid XML
(Jennifer Kyrnin) Sometimes it’s easier to understand how to write well-formed XML by seeing an example. The Web Writer newsletter is written using a form of XML – I call it AML or About Markup Language (go figure!). Here is a sample “AML” file. While this is a working document, it is not actually a
HR Schema on Rails
(Casimir Saternos) Oracle Database is a product with a distinguished past and a bright future. It boasts innovative, state-of-the-art features as well as a history that predates many modern technologies. Applications have come and gone, but the data of organizations has lived on in Oracle databases
Administering MySQL: International Usage and Log Files
(Paul Dubois) By default, MySQL uses the ISO-8859-1 (Latin1) character set with sorting according to Swedish/Finnish rules. These defaults are suitable for the United States and most of western Europe.
Creating a Step-by-Step User Interface with the ASP.NET 2.0 Wizard Control: Improving and Customizing the User Experience
(Scott Mitchell) One of the many new Web controls available in ASP.NET 2.0 is the Wizard Web control, which takes the user through a series of discrete steps in order to accomplish some task. As discussed in Creating a Step-by-Step User Interface with the ASP.NET 2.0 Wizard Control: The Basics, the