DAX Editor

DAX Editor is an extension for Visual Studio that makes easier to work with DAX.

It supports the following features

• DAX syntax highlighting
• DAX formatting. Support for increasing and decreasing format depth using Edit->Advanced->Increase Format Depth or Decrease Format Depth
• IntelliSense support for keywords, functions, columns, and measures. Press Ctrl+Space to show IntelliSense.
• Autocomplete for keywords, functions, tables, columns and measures. Press Ctrl+Space to autocomplete.
• Syntax error reporting using squiggles/Error List
• Brace matching
• QuickInfo support in AutoComplete list that gives description of functions
• F1 help for functions & keywords

Download URL

Technorati Tags: DAX,Visual Studio

BISM Normalizer

BISM Normalizer manages Analysis Services Tabular models for Enterprise Implementations.

• Database Compare – Allows to compare different versions of the tabular models.
• PowerPivot Model Migration – When migrating a Tabular model from PowerPivot to enterprise-level in Analysis Services, the “Import from PowerPivot” can be used. But this will create separate PowerPivot database for each migration. BISM Normalizer allows to merge models migrated from PowerPivot model into appropriate Analysis Services database.
• Allows to maintain a master model that can be extended by different implementations within the Enterprise.
• Enables Partial Deployments by scripting selected differences from the model.
• Reports differences between models in an easily distributed Excel format.
• Full Integration with Visual Studio allowing tight integration with TFS and enables Code Merging.
• Reuse definitions between tabular models for alignment with common business definitions in an enterprise organisation.

Technorati Tags: Tabular Model,BISM Normalizer

String or Binary data would be truncated when using MERGE in SSIS

Normally this error occurs when the column in target table doesn’t have the same column length of the source table. To locate the particular column, try the following

SET ANSI_WARNINGS OFF

[Insert your MERGE Statement here]

SET ANSI_WARNINGS ON

Technorati Tags: SSIS

Snippet Designer

The Snippet Designer is a plugin which enhances the Visual Studio IDE to allow a richer and more productive code snippet experience

A Snippet editor integrated inside of the IDE which supports C#, Visual Basic, JavaScript, HTML, XML and SQL.

Integrates with VS 2013, VS 2012 and VS 2010

Click Once files installation folder

Click Once installs the files on the Users Desktop but it is hard to find the location of this folder

Once the application is installed through Click Once Deployment, Run the application and navigate to Task Manager and Right-Click on the Executable Name and Select "Open File Location".

It will completely an obscure path but this is where the installation files are stored to be accessed whether online or offline.