Microsoft ActiveX scripts can be used to add functionality to Data Transformation Services (DTS) packages. Typical supported scripts are Microsoft Visual Basic Scripting Edition (VBScript), Microsoft JScript, PerlScript and XMLScript.
Author: SSWUG Research
Microsoft Visual Studio 2005 – Update to the Web Project Conversion Wizard
This is an update to the Web Project Conversion Wizard found in the final release of Visual Studio 2005 (all versions) and Visual Web Developer 2005.
Refactoring VB in Visual Studio 2005
(Paul Kimmel) Two primary factions have polarized Visual Basic: VB6 programmers and OOP programmers. VB6 programmers want VB to be really easy to use; OOP programmers say VB needs to be as powerful a language as C# or C++, or VB is just a toy. VB can’t be a hobbyist’s language and a full-blown objec
The Active Record Pattern
(Jason E. Sweat) This article, the first of two parts, helps you use design patterns to better organize how your web application interacts with a database.
Automated Backup with NAnt
(Liam McLennan) For those who don’t know, NAnt is a .NET build scripting tool. It is a lot like the Java build tool Ant, so everything in this article is probably also applicable for Ant. This article assumes a intermediate knowledge of the NAnt tool.
What You Need To Begin an SOA Deployment with IBM Rational SDP
(Andy Patrizio) A Service Oriented Architecture (SOA), done right, can leverage existing software applications by service enabling them and integrating them through an SOA such as using them in Enterprise Application Integration, business process management and business activity monitoring.
Understand the DB2 UDB JDBC Universal Driver
(Anson Kokkat) Discover the latest step in the evolution of Java application development using DB2 Universal Database for Linux, UNIX, and Windows (DB2 UDB). Get an inside view of the JDBC Universal Driver and examine common debugging techniques that will help you get to the heart of any problem.
Error message when you run the sp_helpfile stored procedure in SQL Server 2005 or in SQL Server 2000: ‘Arithmetic overflow error converting expression to data type int’
Consider the following scenario. You are running Microsoft SQL Server 2005 or Microsoft SQL Server 2000. You run the sp_helpfile stored procedure on a data file or on a log file. In this scenario, you may receive the following error message: Msg 8115, Level 16, State 2, Procedure sp_helpfile, Lin
SQL Server and MOM 2005
(Steven Warren) In this series of articles, you will learn the basics of installing Microsoft Operations Manager 2005 as well as how to use MOM to monitor SQL Server. This article takes advantage of virtualization. We will use VMware Workstation 5 to create the lab to introduce you to the basics of
More security stuff, but this time it’s all in Version 8
(Willie Favero) Let’s pick up where we left off before the Holidays; DB2 security.