[SQL Server] Access SQL Server standard reports and Dynamic Management Views (DMV) without being SysAdmin

GRANT VIEW SERVER STATE TO [User Or Group Name]

[WCF] MSMQ Active Directory Integration not working

Problem: After installing the MSMQ Active Directory Integration and configuring it on our WCF service endpoint, our service was failing to start due to the following error message:

"Binding validation failed because the binding's MsmqAuthenticationMode property is set to WindowsDomain but MSMQ is installed with Active Directory integration disabled. The channel factory or service host cannot be opened."

Solution: we checked our service configuration file where everything was OK. The solution to our problem was to restart our server in order for the Active Directory Integration to be activated and taken into account by our WCF service

[SVN to TFS] Migrating source code from SVN to Team Foundation Server 2013

Quick steps:

Follow the steps below to migrate your source code for free from SVN to TFS:


Install SVN Client, For example, Tortoise SVN
Install Git-TF

•     Add Git-tf to system %Path% variable

Install the Java Runtime Environment (JRE)

•     Add  java to system %Path% variable       

Install GIT Repo
Init Repo

•     git svn init http://svn/sources/trunk --no-metadata   

Fetch

•     git svn fetch   

Check history

•     git log

Push source code from GIT to TFS using the following command lines:

•     git tf configure "http://tfs:8080/tfs/DefaultCollection" "$/MyTeamProject/Services"
•     git tf checkin --deep --no-lock

Some useful links:
http://sitecoreblog.blogspot.fr/2014/04/migrate-from-svn-to-tfs-or-git.html
http://www.incyclesoftware.com/2013/08/migrate-svn-to-tfs-its-free/
http://www.incyclesoftware.com/2013/08/how-easy-its-to-migrate-svn-to-tfs-2013-git-repo/

Performance Analysis of Logs (PAL) issues

Performance Analysis of Logs (PAL) is a great tool to analyze performance counters. Recently while using PAL to analyze BizTalk Server performance counters, I encountered 2 issues:

1. Perfmon Template file could not be imported in the Data Collector Set in the Performance Monitor.
At first, we thought that it was caused by a group policy (GPO). In the end, it required to start the Windows Task Scheduler Windows service in order to be able to import the template file.

2. The analysis of performance logs with PAL stopped immediately with some red error messages in the PowerShell console
This is a "bug" in the PAL tool which at the same of writing this blog, did not support the French-FR locale. After switching to the English-US in the regional settings, performance logs were successfully analyzed.