(Nandha V) This document provides insights into the approach to handle SOAP Exceptions thrown by an external Web service in a WCF based application. It becomes challenging for a WCF application to handle such exceptions from an external SOAP or ASMX based web service, as you don’t have any control o
Author: SSWUG Research
DB2 Performance Tuning Your DBA Staff
(Dave Beulke) As a consultant over the years, I have seen the characteristics of a number of shops and discovered there are many different ways to develop, support, and get the best DB2 performance tuning out of a variety of situations. I believe the most important component of successful DB2 perfo
Hybrid Analytics Solution Using DB2 for z/OS and the IBM DB2 Analytics Accelerator for z/OS V3.1
(Paolo Bruni, Willie Favero, James Guo, Ravikumar Kalyanasundaram, Ruiping Li, Cristian Molaro, Andy Perkins, Theresa Tai and Dino Tonelli) The IBM DB2 Analytics Accelerator Version 3.1 for z/OS (also called simply Accelerator in this book) is a marriage of the IBM System z Quality of Service and Ne
Oracle SQL Developer 4: A Tweak With Table Filter Recall
(Jeff Smith) In previous versions of Oracle SQL Developer, if you start typing in the Data tab’s filter dialog on a Table Editor, SQL Developer would make suggestions for you.
How to break a large query into many small ones
(Bobby Durrett) I haven’t figured out the best way to do this yet so this is a work in progress. I’m trying to document the process of taking a large query that joins many tables together and breaking it into a series of small queries that only join two tables at a time.
Automatic Creation of Standby Logs with RMAN DUPLICATE?
(Uwe Hesse) Just a brief information for you out there who are about to create a Data Guard Configuration. You will want to have Standby Redo Logs (SRLs) on the Standby Database. Our (otherwise very good) Online Documentation says “RMAN automatically creates the standby redo log files on the standby
A LINQ Style Operator to Find Items with Distinct Properties
(Richard Carr) Language-Integrated Query’s (LINQ) Distinct operator removes duplicates from a sequence but does not allow a lambda expression to be used when determining if an item is unique. This article describes a custom extension method for this purpose.
Problems With Calculated Members And Level Names
(Chris Webb) Here’s something strange I came across today: a customer had created a calculated member, not on the measures dimension but on another hierarchy, and even though it had been selected in their client tool it wasn’t appearing in the query results. I tested in Excel and saw some strange er
Power Query Data–Should it be Loaded to the Worksheet?
(Melissa Coates) This post discusses situations when you may *not* want to load Power Query data to the worksheet, but instead to the data model only. One reason relates to file size limits in Power BI for Office 365; the other reason is to simplifying & de-duplicate the fields displayed in the Piv
ASP.NET: Responsive GapFree MultiColumn Grids using Nested.js
MultiColumn Dynamic Grid Layouts are very popular nowadays and Pinterest, the fastest growing social network is a familiar real time example of the same. There are many jQuery plugins available for creating such layouts starting from the jQuery Masonry plugin.