Undo pending changes from a specific user account

  If you want to undo some changes from a specific user, you can use:   Change directory to folder containing "tf.exe"     • cd "C:\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\IDE" Check the status of checked out files, to see correct "account"     • tf status "$/TFS/Path/To/Folder/To/Search/For/Pending/Changes" /s:123.123.123.123 /u:* /recursive …

Using a recursive common table expression, to calculate totals and subtotals of children and grandchildren in a hierarchy

In SQL Server a common table expression can be used to calculate totals / subtotals of a table containing hierarchical data:   — Create test data: if object_id(‘tempdb..#Hierarchy’) is not null begin drop table #Hierarchy end create table #Hierarchy ( Id int not null, ParentId int null, Amount int not …

How to manually get Angular services in TypeScript

If you manually want to get / use Angular services in TypeScript you can use the following code:   /// <reference path="../libraries/angular/angular.d.ts" /> module app { "use strict"; var appModule = angular.module("app", []); var injector: angular.auto.IInjectorService = angular.injector(["ng"]); var httpService: angular.IHttpService = injector.get("$http"); var qService: angular.IQService = injector.get("$q"); }

Fix favicon error

When there is no favicon.ico in the root of your website, then the browser will automatically get a 404 favicon error. To prevent this error, you can add a transparent favicon.ico to the “head” tag of your HTML page: <link rel="icon" href="data:;base64,iVBORw0KGgo=">