(Marcin Policht) In the previous article of this series dedicated to the SQL Server 2005 Integration Services (SSIS), we started exploring features, which provide the ability to reuse packages (without modifying their design) in situations where some of their parameters need to be changed (frequentl
Other News
Use Reflection to Validate Assembly References—Before Your Customers Do
(Michael Jones) Reflection is truly a paradigm shift for developers using Microsoft’s line of development tools. The runtime availability of assembly metadata provides developers with new flexibility and the ability to develop interesting software tools. Developers often use reflection to load assem
FIX: You receive incorrect results when you run a query that uses a cross join operator in SQL Server 2000 SP3
You receive incorrect results when you run a query that uses a cross join operator in Microsoft SQL Server 2000 Service Pack 3 (SP3). This problem may also occur if the SQL Server query optimizer generates an incorrect plan. If the SQL Server query optimizer generates an incorrect plan, you may r
Free Book – Introducing Visual Basic 2005 for Developers
Get a focused, first look at the features and capabilities in Microsoft Visual Basic 2005, Visual Studio 2005, and .NET Framework 2.0. If you currently work with Visual Basic 6, these authors fully understand the adoption and code migration issues you’ll encounter. They’ll step you through a quick p
Arrays
(W. Jason Gilmore) Arrays offer an ideal means for storing, manipulating, sorting, and retrieving the kinds of data sets that programmers spend a lot of time working with. PHP supports the array data type. This article explains the array-based features and functions it supports.
Microsoft’s Lineup of SQL Server Related Webcasts for July 2005
Seventeen new webcasts are Scheduled for July, covering such topics as Database Tuning Advisor, Advanced MDX Scripting, Applying SQL Server 2005 Data Mining to Enterprise Business Problems and more.
Implementing a FIFO and a LIFO stack in SQL Server
(Arthur Fuller) Even though you’re probably familiar with the basic data structures such as stack, queue, and linked list, you may not have implemented these structures in SQL Server. Before I show you how to implement a stack, I’ll discuss why you may want to implement one.
Two Good Uses for XML
(Michael Champion) During the past seven years, XML (eXtensible Markup Language) has gone from “What is it?” to “We’re doing it.” Surveys show that most enterprise IT departments have some XML-related projects underway, and many companies use XML in mission-critical applications. As a result, the vo
Untangle URIs, URLs, and URNs
(Dan Connolly) In information management, persistence and availability are in constant tension. This tension has led to separate technologies for Uniform Resource Names (URNs) and Uniform Resource Locators (URLs). Meanwhile, Uniform Resource Identifiers (URIs) are designed to serve as both persisten
Oracle Gets Closer to J.D. Edwards Users
(Lee Kroon) Over the last several weeks, Oracle Corporation has taken significant steps to show users of its J.D. Edwards applications that it has their best interests at heart. The vendor’s actions should help it to retain customers and cut through the atmosphere of uncertainty that has pervaded th