(Darren Green) One of the benefits of the SQL Server 2000 is that the SQL tasks support mapping of global variables to parameter placeholders within the SQL. This means you can use the global variable as an input parameter for your stored procedure.
Other News
Access for the DB2 database
(Kent Milligan) I’m trying to gain access for DB2 within a iSeries where the applications are in VB6 and ASP — soon to be ASP.net. I’m familiar with ADO and SQL, however, there is also a tool by ASNA, the ASNA Tookit that allows the VB or ASP application to access the database natively as you would
You Want Salt With That? – Security vs Obscurity
(Eric Lippert) A poster to one of the Joel On Software fora the other day asked what a “salt” was (in the cryptographic sense, not the chemical sense!) and why it’s OK to make salts public knowledge. I thought I might talk about that a bit over the next few entries. But before I do, let me give
Dive into .NET with Web Matrix, part 1
(Phillip Perkins) Microsoft is tipping the scales in its favour with ASP.NET Web Matrix, a free download that lets you create ASP.NET Web applications, services, etc. This IDE runs on Windows 2000 and Windows XP machines. Here’s an overview of Web Matrix, as well as the steps you need to take to cre
MySQL 5 to open once-closed doors
(Jan Stafford) MySQL AB CEO Marten Mickos won’t reveal the release date of MySQL 5.0, but he does promise that it has all the goodies requested by database developers and corporate users. There are three enterprise-level flagship features in MySQL 5.0: stored procedures, triggers and views. Get
Part 1: Automating the XML Data Mapping Process in Excel 2003
(Sergei Gundorov and Clark Hamilton) In the first of a three-part series, learn how to use XML maps to customize Excel as a data input and display system.
Parent-Child Dimensions
A parent-child dimension is based on two dimension table columns that together define the lineage relationships among the members of the dimension. One column, called the member key column, identifies each member; the other column, called the parent key column, identifies the parent of each member.
Using DTS To Copy Database Is As Simple As 1-2-3
(Steve Schofield) One of the items I like to do from time to time is have a fresh copy of a production database on a local SQL Server. The local copy usually would be used for performance testing, application development etc. Microsoft SQL Server 2000 uses DTS (Data Transformation Services) to help
Reset the Identity for All User Tables
(Jaya Nehru) Before you start testing any database-driven application, the first thing you need to do is: –Remove the old data from all the tables. –Reset the identity back to 1 for every one of the tables.
IBM Express Software Buying and Selling Guide
Welcome to the “IBM Express Software Buying and Selling Guide.” Is your business as profitable and competitive as you would like? Are your communications between employees, suppliers, customers, and trading partners as efficient and effective as they should be? Are you using the Web’s global reach a