(Mike Davis) The pivot transform in SSIS is already a pain to use. When you have bad data it makes it even worse. In this blog I am going to show how to handle bad data when using the pivot transform. You should understand how to use the pivot transform already and Devin Knight has a great blog on h
Author: SSWUG Research
XML processing in Enterprise Java
(Albert (Gong) Cheng) XML processing is one of the central technology in almost all the modern enterprise programming language. Over the time, Java language have developed various standards to process XML, choosing the right one become one of the common design decision that enterprise Java developer
SQL Server – Track Deprecated Features with Extended-Events
(Debjeet Bhowmik) In this blog we will explore one possible solution to the problem all database developer and administrator have during SQL Server upgrade from one major release to another. Every new release of SQL Server brings some new features to the world which is great but it also deprecates s
SQL Server tempdb database size – file creation and file growth
(Travis Gan) SQL Server tempdb is a system database that used as global resource for temporary user objects, internal objects, row versioning and other operations. The database grows as these resources demand increases, and below the maximum file size limit if previously configured.
LINQ to JQuery
(meula) This extends Arrays in JavaScript, adding the main domain and filtering functions of LINQ, Count(), FindFirst(), and Where().
DB2Demo – Updated for DB2 10.5!
(George Baklarz) Trying to demonstrate what a database does is rather boring. It stores data. It retrieves data. Sometimes it does it in clever ways, but at the end of the day it’s just manipulating data. Which is where DB2Demo comes in.
Guaranteed delivery with InfoSphere DataStage
(Paul Stanley) This article describes how the InfoSphere DataStage Distributed Transaction Stage can be used to guarantee delivery of data. It also addresses the use of local transactions within DataStage database stages. Finally, it describes how the Change Data Capture Transaction stage works with
Measuring Max Replication Throughput on Percona XtraDB Cluster with wsrep_desync
(Jay Janssen) Replication throughput is the measure of just how fast the slaves can apply replication (at least by my definition). In MySQL async replication this is important to know because the single-threaded apply nature of async replication can be a write performance bottleneck.
SharePoint Online Website Examples
(Chris Clark) This type of SharePoint public-facing website lacks the full feature set of SharePoint, but is perfectly adequate for websites with basic functionality (not necessarily small or low-traffic sites).
DB2: What’s Tape Got to Do With It?
(John Iczkovits) Many people in the computer field are surprised when they learn that tape was available before disk. Think about your favorite old TV shows or movies; when the director wanted to show data being processed, you would see flickering lights on part of the CPU or console area.