(Andrejus Baranovskis) In order to minimize DB connections usage and optimize ADF runtime performance, I often prefer to enable DB pooling and keep data between requests in memory (jbo.doconnectionpooling = true and jbo.txn.disconnect_level = 1).
Author: SSWUG Research
TypeScript 0.9 Generics: What? And How to use them
Typescript 0.9 was released today and it brings some great things to the Typescript language!
Display an XML file to Console
(Mahesh Chand) Recently, I got a question in an email asking how to load an XML file and display it on the system console.
Achieving high availability during operational maintenance using IBM PureApplication System
(Animesh Singh, Andrew J. F. Bravery and Rehan Altaf) This article describes how the facilities of IBM PureApplication System and IBM WebSphere Application Server combine to streamline and simplify updates to operating systems, applications, and middleware, thereby minimizing human error and total t
Real-Time Web Enablement with SignalR in .Net (Part II)
(Sonal Arora) Before you start reading this Article, I suggest you to go through our first article in the series, Real-Time Web enablement with SignalR in .Net (Part I), in order to set the context right. It talks about SignalR and the general idea of its functionality and usability. In this install
How to Optimize MySQL UNION For High Speed
(Sean Hull) There are two ways to speedup UNIONs in a MySQL database. First use UNION ALL if at all possible, and second try to push down your conditions.
DB2 Analytics Accelerator for z/OS V3.1 prereqs
(Willie Favero) I was asked today about a software prerequisite for the DB2 Accelerator (full name in title). With the increased popularity of the Accelerator, I thought others may be looking for the same, or at least similar, type information.
SQL Server 2012 Integration Services – Leveraging PowerShell in Package Deployment Model
(Marcin Policht) SQL Server 2012 Integration Services introduces an innovative approach to deploying SSIS projects, known as Project Deployment Model. This is the currently recommended (and the default) deployment technique, due to a number of benefits it delivers (such as the ability to centralize
DROP A Tablespace After a Backup
(Hemant K Chitale) What happens if you drop a tablespace after it is backed up?
Split a Delimited Row into Multiple Rows using DAX Queries
(Jason Thomas) Recently, I got a question from one of my readers on whether there is a way to split a single delimited row into multiple rows using DAX. I had kind of demonstrated the opposite to Group Multiple Rows to Single Delimited Row in PowerPivot here and this was another interesting challeng