Operations

We can use FOR XML PATH to combine rows.  For example, have the following data:   And I want to combine the value of column SRC_ID_SEED from all rows to a single row as:   We can achieve this by using FOR XML PATH(): select stuff((select ‘,’+cast(src_id_seed as varchar(20))          from DATA_SOURCES          FOR XML PATH ( […]

I recently posted a script to export term sets in SharePoint (vetted in both 2010 & 2013).  I was prompted to write that script, because the client I was working on had a very particular (and large!) managed navigation structure that I wanted to replicate across all environments to make testing code much simpler. This […]

It is with great honor and excitement that I share the latest in Perficient’s growth story. Today, the company announced the acquisition of TriTek Solutions, an enterprise content management and business process management consulting firm, based in the northeastern United States. TriTek brings meaningful services expertise, important intellectual property assets, and a proven track record […]

By Lesli Adams, MPA Director, Oracle Healthcare Business Intelligence   Blue or Red? Doesn’t matter.  It’s a question I get asked daily when I talk about Healthcare Consulting, Technology, and oh yeah, Clinical Measurement.  Over 2 years ago, when the Patient Protection and Affordable Care Act  (PPACA) was signed into law, my industry went off […]

We recently hosted a webinar on Office 365, where my colleague Rich Wood discussed what’s new and improved when it comes to the latest release of SharePoint Online. Rich, Director of Perficient’s National SharePoint Practice, gave attendees nine great reasons to love the new SharePoint Online. The tenth topic focused on Yammer, as Rich delved into SharePoint Online […]

I don’t know about you, but I really wish there was a way to export managed metadata in SharePoint, especially since SharePoint teases you with the ‘Import Term Set’ option. To get around this I’ve written a little script to export all of the term sets in a term store (easily customizable to just export […]

Trying to stay ahead of the curve when it comes to IT issues is a challenging task. Emerging technology forces in the financial services industry are already impacting business. The convergence of these forces does present challenges; however, it also provides a window of opportunity for financial institutions to elevate business performance and gain a […]

This post discusses the actual installation of WebLogic Server. Generally speaking, the installation of Oracle WebLogic Server, in reality, involves installing two software products: Java – typically a Java software development kit (SDK) – and WebLogic Server. In a secured deployment, I will install the Java SDK in the same location as WebLogic Server. On […]

I recently came across a Gigaom article, written by Phil Fasano of Kaiser Permanente, discussing the parallels to new and disruptive technologies in the financial services industry healthcare systems need to embrace to improve the quality of patient care while reducing costs.  This article got my wheels turning.  There are a lot of parallels to financial services […]

  Scenario: Data source is a flat file and we want to load this data into the target. The problem is the source file name keeps on changing.  Here we go: Use a pre-session script that creates a file list. Windows dir /b part_of_file_name*.txt > FILELIST_NAME.LST UNIX ls part_of_file_name* > FILELIST_NAME.LST                 In Workflow Manager […]

This post continues where we left off in discussing the pre-installation tasks of Oracle WebLogic Server. 1) Operating System Firewall Most operating systems include a (software) firewall. The existence of the Windows firewall and Linux firewall (a.k.a. iptables) are common knowledge. Just in case, here are some articles for Solaris and AIX: Setting up a […]

A few days ago when I was browsing some information categorized in data mining and machine learning, I heard that Google had released a large dataset called Wikilinks Corpus which contains 40 million mentions over 3 million entities. What does mention and entity mean here? Apple is also rumored to be working on a new, […]