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.

SSAS Connector and Power BI Preview

Key things about SSAS connector and Power BI Preview

• Only SQL Server Analysis Services Tabular models are supported for Power BI Preview
• The connector has to continue running and the computer where it is installed has to remain on.
• When you use the SSAS connector, your data remains on-premises.  The reports you create based on that data are saved in the cloud.
• Q&A natural language querying is not currently available for SSAS on-premises tabular data.  Only cloud-based datasets are supported for Q&A.

Pre-requisites SSAS connector and Power BI Preview

• NET Framework 4.5.1 or later must be installed on the computer.
• Installing the Power BI Analysis Services Connector and the Data Management Gateway on the same computer is not supported. If you already have the Data Management Gateway installed, uninstall it before installing the Power BI Analysis Services Connector, or install the Connector on different computer.
• The Analysis Services server is domain joined.
• The Analysis Services connector & Analysis Services server are installed on computers in the same domain.
• If you use a .onmicrosoft.com email address, you'll need to sync your Active Directory to Azure Active Directory using Azure Active Directory Sync (DirSync).

Technorati Tags: Power BI Preview,SSAS

WebAPI IHttpActionResult vs HttpResponseMessage

The WebAPI Controller can return either HttpResponseMessage or IHttpActionResult. HttpResposeMessage converts it directly to an HTTP response message. Call ExecuteAsync to create an HttpResponseMessage then convert to an HTTP response message.

ApiController Action Result Methods by HTTP Status Code

Status Code	Meaning	Method
200	Operation successful	Ok() Ok(data)
302	Temporary Redirection	Redirect(target) RedirectToRoute(name, props)
400	Bad Request	BadRequest() BadRequest(message) BadRequest(model)
404	Not Found	NotFound()
409	Conflict	Conflict()
500	Internal Server Error	InternalServerError() InternalServerError(Exception)

Technorati Tags: WebAPI

[rsRuntimeErrorInExpression] The value expression for the textrun ‘Textbox1.Paragraphs[0].TextRuns[0]’ contains an error: Input string was in a correct format.

In this scenario, the expression for the textbox was =”Total Value: “ + Fields!TextBox1.Value

Changing that to =”Total Value: “ + CStr(Fields!TextBox1.Value) will fix the issue.

Technorati Tags: SSRS