(Ed Tittel) In November 2005, XML tool and technology vendor Altova announced support for Visual Studio 2005 in its XMLSpy 2006 product offerings. XMLSpy is a well-liked and widely-used XML development environment that includes advanced features to model, edit, debug and transform XML-related markup
Author: SSWUG Research
Be Aware: Using AWE, locked pages in memory, on 64 bit
(Slava Oks) We have already talked about Windows AWE mechanism on 32 bit and how SQL Server utilizes it. Today I would like to go over AWE & related mechanism on 64 bit platforms.
Reading committed records without locks
(Craig Mullins) We have an issue in our OLTP and Datamart 24/7 design (both on DB2 UDB V8.1 on AIX). While running ETL against the OLTP database, if the ETL process uses “Cursor Stability” isolation, it potentially locks out other users. So we changed isolation to “Uncommitted Read.” This added a ne
Oracle Database 10g PL/SQL Programming, Chapter 3: PL/SQL Basics (Sample Chapter)
(Scott Urman, Ron Hardman and Michael McLaughlin) Syntax and rules govern what you can and cannot do in PL/SQL. While following syntax and programming standards alone do not make a program good, failure to understand the rules of the language can certainly make a program bad. In this chapter, we dis
Develop better code by gleaning insight from previous experiences
(Ken Pugh) Create readable code as you develop your application and reduce future frustration using the techniques gleaned from superior experience. (pdf)
Presenting Parent/Child Data in a Data Grid Row
(Ezhilan) The Data Grid provides a richer UI presentation for Web applications. Most of the time, there may be a requirement to show one or more child data items that belong to the parent row in a column within the Data Grid. The following article gives an example of defining a Repeater control insi
Improving concurrency by knowing your application
(Chris Eaton) Regardless of the locking mechanisms used by a database, the best way to get the most throughput and improve concurrency is to know the requirements of your application. If you know the expected behavior of the application and the business requirements, there may be some things you can
Generate Strong Passwords
(Paul D. Sheriff and Ken Getz) I recently wrote an application that must let users generate strong passwords at runtime. In this case, as in many Web sites, if the user forgets a password, the application generates a new one and sends it out via e-mail. (Because my company stores its passwords using
Networking Features in .NET Framework 2.0
(Thiru Thangarathinam) One of the cool features introduced with the .NET Framework 2.0 is the networking feature. The .NET Framework 2.0 introduces a new namespace named System.Net.NetworkInformation that encapsulates all of the network related features. This namespace exposes a number of classe
A cumulative hotfix package is available for SQL Server 2000 Service Pack 4 build 2162
Microsoft SQL Server 2000 hotfixes are created for a specific Microsoft SQL Server service pack. For example, you cannot apply a hotfix that was designed for Microsoft SQL Server 2000 Service Pack 3 (SP3) to an installation of Microsoft SQL Server 2000 Service Pack 4 (SP4) unless a special case is n