(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
Author: SSWUG Research
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.
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
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
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.
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
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
SQL Server 2005 Integration Services – Templates, Data Sources, and Data Source Views – Part 50
(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
Exploit SQL Server Compact Edition and Occasionally Connected Systems
(Roger Jennings) SQL Server Compact Edition v3.1 and v3.5’s free license covers deployment on Windows PC clients as well as devices, so you can take advantage of this lightweight, in-process relational database as a local data cache and automatically synchronize its data with a back-end SQL Server 2
Business Intelligence a Key for SQL Server 2008
(Jeffrey Schwartz) Developers can now take a first hand look at Microsoft’s next major upgrade of its flagship database platform. The company this week released the first CTP of SQL Server 2008, until now known as Katmai.