(Michael Curry) As organizations work on integrating and managing information across the enterprise, they’re finding that it’s no easy task. For the most part, they’re forced to build from scratch or knit together solutions that provide access, cleansing, integration, and management. But for mission
Author: SSWUG Research
Exploiting personalization in WebSphere Portal V6.0
(Larissa Schoeffing and Rene Auberger) This article is for portal specialists, architects, and consultants who need to understand how to use the personalization support in WebSphere Portal V6. You walk through detailed examples of rule driven personalization involving Web Content Management and Port
Create generic database code using ADO.NET 2.0 Provider Factories
(David Jeavons) The new DBProviderFactory class lives in the System.Data.Common namespace. Within this Namespace you will see the usual suspects such as DbConnection, DbDataAdapter, DbCommand etc., but note how they are all prefixed with Db. Each of these classes are abstract classes and implement t
Color DataGridView Cells Based On Data with the Windows Forms DataGridView and Visual Basic 2005
(Mike McIntyre) This blog, and the source code it provides, demonstrate how to handle the Windows Forms DataGridView CellFormatting event to set the BackColor of a cell based on the cell’s value.
Creating a Crosstab Report in Visual Studio 2005 Using Crystal Reports
(Jayaram Krishnaswamy) Reporting is one of the major tasks in any enterprise and reporting software occupies a prominent position in enterprise software suite. There are multitudes of reporting software vendors; among them Crystal Reports has a large following with a variety of products designed fo
Applied Reflection: Creating a dynamic Web service to simplify code
(Zach Smith) Many developers are using Web services to communicate with their business logic, and there are a lot of advantages to this. This approach allows a wide range of flexibility in the architecture that would otherwise be very hard to come by. However, there are also a few disadvantages. One
Think ANSI Standard SQL Is Fully Portable Between Databases? Think Again
(Alexander Kuznetsov) Out here in the field, there is a popular urban legend: “If your application issues only ANSI standard SQL, then your application is portable.” Many developers actually believe it. Unfortunately in some cases, identical SQL works differently on different RDBMS. This article pre
SQL Server 2005 Transactional Replication Agents
(Baya Pavliashvili) Some of my previous articles discussed transactional replication setup, monitoring, troubleshooting, and maintenance with SQL Server 2005. This article explores the inner workings of replication agents: security, properties, and profiles. I will also introduce you to a few system
RAC node scaling in DSS workloads vs. OLTP
(Bill Cullen) What are your experiences with RAC node scaling in DSS workloads vs. OLTP? Also, isn’t the primary bottleneck in scaling out the overhead of the cachefusion lock management protocols, not the actual interconnect? (R)
Statistics Profile Output Formatting
(Peter Zabback) Statistics profile output is an important tool when it comes to troubleshooting query plan issues. When enabled, it returns a textual representation of the query plan with a lot of detail about cost and cardinality estimates as well as actual counts.