Create and Edit DocumentDB Server Side Scripts in the Azure Preview Portal

Posted on

The DocumentDB Script Explorer now supports creating, editing, and deleting stored procedures, user-defined functions, and triggers! You can read more about DocumentDB server side programming here.

Now, let’s get started with the new functionality.  Within Script Explore, click the applicable command depending on the type of script you wish to create.



To see more about this click here:


Connecting to Dynamics CRM Online with Power BI

Posted on

It  provides the ability to  connect to a number of online services and one of these is Dynamics CRM Online.

Once you have logged in successfully, Power BI will synchronize with your Dynamics CRM Online repository and provide a dataset representing your CRM data.

Accessing it from your Phone

Microsoft has an IOS, Windows Phone and Android app for viewing your dashboards.  This works well with Dynamics CRM data for getting access to your vital data at a glance while on the road!



To  see more about this click here:

Querying and Editing DocumentDB Data Just Got Better

Posted on

DocumentDB queries, documents, and server-side programming in the Azure preview portal, including:

  • Query Explorer Improvements
  • Document Explorer Improvements
  • An all new Script Explorer

DocumentDB’s language integrated, transactional execution of JavaScript lets developers writestored procedures, triggers and user defined functions (UDFs) natively in JavaScript. This allows you to write application logic that can be shipped and executed directly on the database storage partitions.



To see more about this click here:

Azure Data Factory Updates: Monitoring and Management Enhancements

Posted on

This is very helpful when customers have a pipeline with more than 1 activity and want to see the operational lineage for just that single pipeline.

Customers can now determine why their slices are stuck in ‘Pending Execution’ state. We have enabled a new feature that allows customers to determine the upstream dependencies due to which the current slice is not ‘Ready’ and still in ‘Pending Execution’ state.

This is very useful for customers who are monitoring the last produced dataset in their Azure Data Factory workflow and are continuously seeing the slices in ‘Pending Execution’ state.


To see more about this click here:

New DocumentDB Import Options

Posted on

Two new import options: Azure Table storage and URL support for JSON, CSV and MongoDB export files.Import data from Azure Table storage to DocumentDB.  Simply provide a connection string and table name to import all entities from an Azure Table.  For finer control over the data you wish to import, you can optionally specify the following:

  1. Filter
    • Specify a filter to limit the entities you wish to import (e.g. PartitionKey eq ‘Partition1’ and RowKey gt ‘00001’)
  2. Include Internal Fields
    • All – Include all internal fields (PartitionKey, RowKey, and Timestamp)
    • None – Exclude all internal fields
    • RowKey – Only include the RowKey field
  3. Select Columns
    • If you want to only import specific Azure Table entity properties, add them to the Select Columns list.  All other entity properties will be ignored.

To see more about this click here:

Introducing Azure Data Lake!!

Posted on

Azure Data Lake, Microsoft’s hyperscale repository for big data analytic workloads in the cloud. This offering is built for the cloud, compatible with HDFS, and has unbounded scale with massive throughput and enterprise-grade capabilities.

It’s as an enterprise wide repository of every type of data collected in a single place prior to any formal definition of requirements or schema. This allows every type of data to be kept without discrimination regardless of its size, structure, or how fast it is ingested.


JOPX on SharePoint, Big Data and the future of business!!!!!!

Posted on

SharePoint 2013 allows you to view the result of the ranking model by retrieving the rankdetail managed property. The rankdetail property will only be returned when there are less than 100 results in the returned search result set. There is however an interesting tool hidden inside SharePoint which outlines the rankdetails calculation which I found in Explain rank in SharePoint 2013 search. SharePoint 2013 contains a built-in  application page called /_layouts/15/explainrank.aspx which accepts two mandatory parameters:

  • q – which contains the query
  • d – which specifies the path of the item for which you want to see the rankdetail

You can download a specific Explainrank search display template which will incorporate a link to the explainrank.aspx page with the required parameters. An alternative for this which will also work on Office 365/SharePoint Online is the Mavention Search Ranking app. My current favorite for the moment is theSharePoint 2013 Search Query Tool which also allows you to show rankdetails and rank calculation.

To read more about this, click here: