(Marcin Policht) In this installment of our series dedicated to SQL Server 2005 Integration Services, we will look into functionality intended to improve efficiency of managing Business Intelligence Development Studio-based projects. In particular, we will focus on features that help maintain consis
Other News
Partial Database Availability
(Danny Tambs) This white paper outlines the fundamental recovery and design patterns involving the use of filegroups in implementing partial database availability in SQL Server 2005. As databases become larger and larger, the infrastructure assets and technology that provide availability become more
Letting ADO.NET Write Your SQL
(Paul Kimmel) Many years ago, while working on a Delphi project, a team member made an assertion about his code relative to everyone else’s. He said that his code represented best practices, and anyone who wasn’t coding the way he was was unprofessional. In short, “everyone but me is stupid.” He got
User and Group security for the Information Server and DataStage 8
(Vincent McBurney) This is a step by step guide to setting up user and group security for accessing the IBM Information Server and products on that server such as DataStage 8.
Using the Enterprise Library Validation Application Block in ASP.NET – Part I
(Alex Homer) This article shows how you can take advantage of the validation features within the Validation Application Block, part of version 3.0 of Enterprise Library, in your ASP.NET applications. The block supports both UI and object validation, and you can combine these approaches using the sam
So what’s the fuss about the new Open XML file formats?
(Joanna_Bichsel) You’ve probably been hearing about new Office 2007 file formats and that the fact that they are based on Open XML is a great benefit. But why? Why should you as developers care? Are they nothing more than just a compressed file format? Actually, they’re much, much, more than that. T
Retrieving Detailed Exception Information in C#
(Rick Leinecker) I remember those error codes we used to have to handle and interpret in the early days of Windows programming. There are a lot of system error codes, the Winsock errors, for example, are up in the 10,000s.
Automatic table maintenance in DB2, Part 1: Automatic statistics collection in DB2 for Linux, UNIX, and Windows
(Ivan Popivanov, Scott Walkty, Angela Yang and Beck Tang) DB2’s autonomic capabilities lighten the load of the DBA and enable you to maximize performance. This article demonstrates how to enable and configure automatic statistics collection, monitor automatic statistics collection progress, and dete
Using Windows Workflow to Control ASP.NET Navigation
(Steve Dunn) This article describes one simple solution for achieving interoperability between Windows Workflow (WF) and ASP.NET. It leverages the power of WF’s powerful visual logic to design page-flow based on user choices. Without WF, enforcing page flow would most likely entail hard-coding such
Unveil the Data Binding Architecture inside Microsoft ASP.NET Ajax 1.0 – Part 1
(Xianzhong Zhu) Recently, Microsoft ASP.NET Ajax 1.0 has attracted more and more developers’ attention. Why? Because it’s an Ajax-based solution from Microsoft for ASP.NET 2.0 web development! It came to the AJAX stage late in the game, but it brought with it an integral package of new Ajax-based we