(Brady Upton) I have multiple duplicate records in my SQL Server database. What is a quick and easy way to remove them using SSIS?
Author: SSWUG Research
Static and dynamic ways of providing input to connector activities using WebSphere Cast Iron Studio
(Madhavi Kota, Aparna Srinivasan and Anusha Kulkarni) Learn how to provide input statically through variables and configuration properties and to provide input dynamically through other connector activities using WebSphere Cast Iron Studio. This article explains different ways to provide input so th
Checking Collections and Working with Objects in Visual Studio Test
(Peter Vogel) I admit it: I need help. I’ve got a useful little utility that helps me with a problem, but it doesn’t quite do everything I want. If someone out there has an idea, I’m open to suggestions. I’ll explain my problem and, along the way, introduce a feature of Visual Studio Test that you m
Heads up – Implicit sorting by GROUP BY is deprecated in MySQL 5.6
(morgan tocker) For those who were unaware, in MySQL the following statements are currently identical:
SharePoint 2010 – Group View
(Jean Paul) In this article I will take you through an out-of-the-box, but not so popular, feature of SharePoint.
DB2 for z/OS: How Big is Big?
(Robert Catterall) For several decades I’ve enjoyed reading the comic strip, B.C., about a bunch of cavemen. In one strip published long ago (I may be assigning quotes to the wrong characters, but you’ll get the point), B.C. asks one of his compadres, “Thor, how far can you see?”
The DB2Night Show z40: Dynamic SQL, Pros and Cons
(Martin) 98% of our studio audience learned something! Klaas presented many characteristics and considerations for using dynamic SQL. Watch the replay…
Working with the CommandBar in Windows 8.1
(Vipul Patel) During Build 2013, the annual Microsoft conference introduced Windows developers to over 5000 new APIs, which would arrive in the form of Windows 8.1.
Oracle Database 12c: New Features for Partitioned Tables
(Karen Reliford) Table partitioning is a feature often used in large databases with very large tables as a means to help improve the performance of accessing data in those tables.
Fusion Concepts: Fusion Database Schemas
(Vik Kumar) You often read about FUSION and FUSION_RUNTIME users while dealing with Fusion Applications. There is one more called FUSION_DYNAMIC. Here are some details on the difference between these three and the purpose of each type of schema.