Archive for March, 2014

Talend Open Studio

March 19, 2014

Talend Open Studio is a powerful and versatile set of open source products for developing, testing, deploying and administrating data management and application integration projects. Talend delivers the only unified platform that makes data management and application integration easier by providing a unified environment for managing the entire lifecycle across enterprise boundaries. Developers achieve vast productivity gains through an easy-to-use, Eclipse-based graphical environment that combines data integration, data quality, MDM, application integration and big data.

Talend’s products dramatically lower the adoption barrier for businesses wanting powerful packaged solutions to operational challenges like data cleansing, master data management, and enterprise service bus deployment. Leveraging and extending leading Apache technologies, Talend’s open source ESB and open source SOA solutions help organizations to build flexible, high-performance enterprise architectures that integrate and service-enable distributed applications.

All Talend Open Studio products are 100% open source and free to download and use. The Talend Community provides a set of educational and support services including a discussion forum, tutorials, bug tracking, source code and product add-ons.


Enable ‘xp_cmdshell’ on Microsoft SQL Server

March 18, 2014

-- To allow advanced options to be changed.
EXEC sp_configure 'show advanced options', 1
-- To update the currently configured value for advanced options.
-- To enable the feature.
EXEC sp_configure 'xp_cmdshell', 1
-- To update the currently configured value for this feature.

How to obtain the setup updates for Microsoft Dynamics CRM 2011

March 14, 2014

When you install Microsoft Dynamics CRM 2011, or when you upgrade to Microsoft Dynamics CRM 2011, you can check for setup updates. If you select the option to check for setup updates, the application downloads any new setup updates and applies them to the installation while the setup process is running.
If the Microsoft Dynamics CRM server has an Internet connection, you can select Get updates for Microsoft Dynamics CRM during the installation. If there are any setup updates available, the updates are downloaded and applied to the installation.
If the Microsoft Dynamics CRM server does not have an Internet connection, or you want to manually deploy the setup updates, follow these steps:

  1. Obtain the setup updates by visiting the following Microsoft website:
    Setup Update for Microsoft Dynamics CRM Server 2011

    Note All previously released Setup Updates have now been included in the slip-streamed server installation which also includes all updates and hotfixes through Update Rollup 6. There are currently no other Setup Updates available. Microsoft Dynamics CRM Server 2011

    To verify the version number corresponds with the installation of Update Rollup 6, right-click on the SetupServer.exe and then click Details to ensure the build number is 5.0.9690.1992.

  2. Click Add to add the update to the basket.
  3. Click view basket in the upper-right section of the page.
  4. Click Download.
  5. Select the download location, and then click Continue.
  6. The Microsoft Update catalog will create a folder that uses the name of the download, and then it copies a .cab file into the folder. In this case, a Setup Update for Microsoft Dynamics CRM Server 2011 folder is created. Open the .cab file to view the .msp file(s). The .cab file will contain all 25 languages that Microsoft Dynamics CRM Server 2011 supports.
  7. Extract the .msp file to the location of your choice.
  8. Create a Config.xml file for the setup process.   Below is an example of a Config.xml file. Please refer to the Implementation Guide for information on the other xml elements that can be added.

    <CRMSetup> <Server> <Patch update=”true”> The path to your .msp file (For example: c:\temp\ Server_KB2434455_amd64_1033.msp)</Patch> </Server> </CRMSetup>

  9. Run the Setup file in the configuration folder.

Issues that are fixed in the setupupdates for Microsoft Dynamics CRM 2011.
A hotfix is intended to resolve only the problem that is discussed in an associated Microsoft Knowledge Base article (KB). For more information about a specific hotfix, and for more information that may be required if you did not install the setup update, see the following KB articles. Note These updates are not hotfixes that have to be applied after Microsoft Dynamics CRM is installed.
Microsoft Dynamics CRM Server 2011

  • When you install Microsoft Dynamics CRM Server that points to a website that has an HTTPS binding present, the setup process incorrectly sets the binding type to HTTP. Therefore, Help cannot load on any deployment where the website has HTTPS.
  • Server setup should only set HelpServerUrl when Help Server is installed, separately from Web Application.
  • The Microsoft Dynamics CRM Server upgrade fails because a deletion service fails to clean up all deleted records.
  • The Microsoft Dynamics CRM Server upgrade does not upgrade indexes in the MSCRM_CONFIG database.
  • Upgrading from Microsoft Dynamics CRM 4.0 to Microsoft Dynamics CRM 2011 for non-English base languages result in a “Cannot insert duplicate key in object ‘MetadataSchema.LocalizedLabel'” error.
  • Imported organizations think there is an update available when there is none.

Note All fixes listed above are now included in the current Setup bits.

View the original post

Ribbon Workbench for Microsoft Dynamics CRM

March 6, 2014

Customising/editing the Dynamics CRM 2011 Ribbon has never been easier with the Ribbon Workbench for Dynamics CRM 2011. Unlike other editors available, the Ribbon Workbench allows you to perform a complete set of customisations that have only been possible up until now by hand editing xml.

The Ribbon Workbench is installed as a CRM 2011 solution and is available immediately from inside the Dynamics CRM user interface.

Read ‘Getting started with the Ribbon Workbench for CRM

The following video shows installing the Ribbon Workbench and a short demonstration of it’s use.

(Please note, the video has no sound at this time)

A series of ‘how to’ articles are being added to regularily

Installation Instructions

Download the solution using the button below and install into your Dynamics CRM organisation. Once installed, you will see a new ‘Ribbon Workbench’ button in the ribbon/command bar when the ‘Solutions’ or ‘Customisations’ link is selected.

Learn how to use the Ribbon Workbench for Dynamics CRM

Getting started with the Ribbon Workbench

Knowledge Base Articles

Blog posts on customising the CRM 2011 ribbon.

Forums and Support

SharePoint Current Visitors Web Part

March 5, 2014

The Current Visitors Web Part is intended to display a list of users that are currently visiting a SharePoint site collection.

All you need to do is just to place the Web Part on your SharePoint page (Web Part or Master).

The Web Part is using OOB SharePoint auditing so please note when you activate the Current Visitors Web Part feature on your site collection, this in turn enables the site collection audit logging.

By default the ‘currently visiting’ user is a person who viewed any content in the site collection in the last five minutes. This period can be configured in the Web Part’s properties.


Microsoft SQL Server Date Function

March 4, 2014

SELECT DATEADD(d,-1,GETDATE()) ‘Yesterday’
First Day of Current Week
SELECT DATEADD(wk,DATEDIFF(wk,0,GETDATE()),0)’First Day of Current Week’
Last Day of Current Week
SELECT DATEADD(wk,DATEDIFF(wk,0,GETDATE()),6) ‘Last Day of Current Week’
First Day of Last Week
SELECT DATEADD(wk,DATEDIFF(wk,7,GETDATE()),0) ‘First Day of Last Week’
Last Day of Last Week
SELECT DATEADD(wk,DATEDIFF(wk,7,GETDATE()),6) ‘Last Day of Last Week’
First Day of Current Month
SELECT DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0)’First Day of Current Month’
Last Day of Current Month
SELECT DATEADD(ms,-3,DATEADD(mm,0,DATEADD(mm,DATEDIFF(mm,0,GETDATE())+1,0)))’Last Day of Current Month’
First Day of Last Month
SELECT DATEADD(mm,-1,DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0))’First Day of Last Month’
Last Day of Last Month
SELECT DATEADD(ms,-3,DATEADD(mm,0,DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0)))’Last Day of Last Month’
First Day of Current Year
SELECT DATEADD(yy,DATEDIFF(yy,0,GETDATE()),0)’First Day of Current Year’
Last Day of Current Year
SELECT DATEADD(ms,-3,DATEADD(yy,0,DATEADD(yy,DATEDIFF(yy,0,GETDATE())+1,0)))’Last Day of Current Year’
First Day of Last Year
SELECT DATEADD(yy,-1,DATEADD(yy,DATEDIFF(yy,0,GETDATE()),0))’First Day of Last Year’
Last Day of Last Year
SELECT DATEADD(ms,-3,DATEADD(yy,0,DATEADD(yy,DATEDIFF(yy,0,GETDATE()),0)))’Last Day of Last Year’

SharePoint 2010/2013 Tabbed Web Part Zone

March 3, 2014

Tabs in SharePoint Project Description

This project shows a working example of how to implement a tabbed web part zone in both SharePoint 2010 and 2013 using only a custom page layout and JQuery.
This project contains a sample SharePoint Publishing Page Layout (For both 2010 and 2013) with a “Tabbed Web Part Zone”.  See for more information.
Please see the Downloads section for pre-packaged WSPs for both SharePoint 2010 and 2013 if you’d like to directly deploy it to an on-premise SharePoint farm.
Please contact if you have any questions, comments or issues.

New! Tabbed Web Parts for SharePoint Online (365)

I have now created a manually deployable publishing page layout that is fully compatible with SharePoint Online 2013 with publishing (as well as backwards compatible with SharePoint 2013 Enterprise On-Premise if you do not want to deploy the entire WSP). Please check it out here:


SharePoint Admin Dashboard

March 1, 2014

Project Description Easily compare server configuration.   “Grid” layout shows configuration of the full farm in one table.  Export to Excel for filter, sort, and pivot chart.


  • Do admin tasks faster
  • Scale up beyond RDP
  • Add new servers without fear
  • Verify consistent configuration


  • New WSP format
  • Central Admin > Monitoring > SPDash easy navigation
  • View server config data in table format
  • Export to Excel
  • Timer job refreshes data cache of XML files
  • Wide screen layout for SharePoint 2013
  • Automatic hive (14/15) detection for SP2010/2013 support

Data Sources

  • WMI query
  • Global Assembly Cache
  • IIS web.config
  • Logical disk size and space
  • File versions (to confirm patching)
  • Display Local Administrator members
  • Kerberos SPN for all managed accounts and farm machines

Background SharePoint farms have many servers with various services, applications, traffic patterns, and purposes.  Having “grid” scripts like the below sample screen-shots can save lots of time.  What’s a “grid”?   Simple.   I wanted to build a real-time Excel spreadsheet to display ALL configuration without RDP.  RDP won’t scale.  While great for 1-2 servers, it’s awful for 10+ servers.  Having confidence in your configs and knowing everything is 100% consistent are BIG steps forward for most admins.