(Katherine Sanders) In this article, API developers can learn how to use IBM WebSphere Cast Iron Web API Services to create a web API that can be invoked to create a contact in the Salesforce.com customer relationship management system. With IBM WebSphere Cast Iron Web API Services, you can assemble
Author: SSWUG Research
Getting Started With SQL Server 2014 the Easy Way
(Grant Fritchey) You know you want to at least take a look at the new Client Technology Preview (CTP) of SQL Server 2014. I don’t blame you either. I want to spend hours swimming through it too.
Change Current Month Language in SQL Server 2014
(Sharad Gupta) In this article I explain how to change the current month language to other languages depending on his/her country.
Next-Level Parallel Plan Forcing: An Alternative to 8649
(Adam Machanic) “Even experts with decades of SQL Server experience and detailed internal knowledge will want to be careful with this trace flag. I cannot recommend you use it directly in production unless advised by Microsoft, but you might like to use it on a test system as an extreme last resort
12c Partial Indexes For Partitioned Tables Part II (Vanishing Act)
(Richard Foote) In Partial Indexes Part I, we looked at how it was possible with the 12c database to create a Partial Index based on data from only selected table partitions. The resultant Partial Index can be either a Global or Local Index.
‘UPDATE SET ROW’ with UNIQUE constraints can cause ORA-00060 deadlock
(Martin Schapendonk) While developing some software that inserts and updates a lot of records in an Oracle database I used UPDATE SET ROW a number of times:
Smooth Migration from ADF 11g R1/R2 Apps to ADF 12c
(Andrejus Baranovskis) First test I did with ADF 12c was to run apps developed with previous releases ADF 11g R1/R2. Migration was very smooth, no issues so far. Applications are migrated just with single click, no matter if based on JSPX or Faces.
DB2 Tips n Tricks Part 4
(Harishkumar Baburao Pathangay) How to move/copy Data without Intermediate Data(DEL/IXF) Files.
Creating Multi-Column Reports: The Top-Down Version [SSRS]
(Valentino Vranken) About half a year ago I wrote an article in which I explained how you can get newsletter-style reports implemented which work in every renderer (except just the image ones), I called that article Creating Multiple-Column Reports.
TechTip: Implement a Rolling Average User-Defined Function in DB2 for i – See more at: http://www.mcpressonline.com/database/techtip-implement-a-rolling-average-user-defined-function-in-db2-for-i.html#sthash.EaN3QCOU.dpuf
(Michael Sansoterra) A friend recently asked me how to convert a particular Oracle query to SQL Server 2005. The query contained a column expression that looked like this (modified and simplified):