(Bipin Joshi) By default Web API action methods use the same HTTP method name that they are serving. For example, to deal with the HTTP GET method the Web API has the Get() action method. However, you may want to customize these action method names for the sake of better readability.
Author: SSWUG Research
Simplifying Repetitive Queries with IN
(Richard Carr) The usual use of the IN clause in a Transact-SQL (T-SQL) query allows a column to be compared with multiple values. For searches, where the same literal is compared with multiple columns, the IN clause can be used to simplify the query.
SSIS: Using Checkpoints
(sqlbischmidt) When working in SSIS, one of the most frustrating things is when your package has several steps in the control flow, and fails on the last one. Especially if the first few steps take a longer amount of time, and the last step is an archive or something that takes 5 seconds, and someon
Building Flat File Connectors Dynamically For SSIS
(Wes Brown) What else can I say. I finally broke when I had to build a flat file connector with 258 columns that needed to be imported into a staging database. 258 columns… I almost had a stroke. Not only is it mind numbing it’s also error prone. I do dabble in c# so I build a little tool to […]
Differential Backups, Differential Terms
(Thomas LaRock) Backup or dump, which do you prefer to take?
Integrating WebSphere ESB V8 or WebSphere Process Server V8 with WebSphere Service Registry and Repository V8
(Ganesh Nagalingam) This article shows you how to do dynamic endpoint lookup by integrating WebSphere ESB or WebSphere Process Server with WebSphere Service Registry and Repository (WSRR), using the Endpoint Lookup and Custom mediation primitives. This integration has important advantages over using
The Basics of Achieving High Performance with DB2
(Daniel Luksetich) This month, IDUG’s topic of discussion will be “Performance.” This is an extremely wide topic that has the attention of many of us in our daily activities. We’re constantly striving for high performance, our managers are constantly demanding high performance, and IBM is quite dedi
Measuring application network performance using DB2 ping
(Cristian Molaro) The network utility ping is commonly used to investigate connectivity issues. If you are troubleshooting a DB2 distributed application, for example, ping can tell you if the server where DB2 is running is accessible to an application or to a DB2 Client.
Adding External Logins to your ASP.NET application in Visual Studio 2013
(pranav rastogi) The project templates showcase a way of logging in with external login providers, along with the normal way of logging in by creating a local account.
Waiting for 9.4 – ALTER TABLE … ALTER CONSTRAINT for FKs
(depesz) Basically whole purpose of this patch is described in the commit message, but let’s see how that works.