TFS Notifications debugging

[Reflection.Assembly]::Load("Microsoft.TeamFoundation.Client, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"); $collectionBaseUrl = "http://YOURTFSSERVER:8080/tfs/YOURCOLLECTION/"; $tfs = [Microsoft.TeamFoundation.Client.TeamFoundationServerFactory]::GetServer($collectionBaseUrl); $collectionHive = $tfs.GetService([Microsoft.TeamFoundation.Framework.Client.ITeamFoundationRegistry]); $collectionHive.SetValue("/Service/Integration/Settings/NotificationJobLogLevel", "2"); Note: Zero to turn off debug mode SELECT TOP 10 DATEADD(hour, -6, StartTime) as StartTimeCDT, Result, ResultMessage FROM [Tfs_Configuration].[dbo].[tbl_JobHistory] WHERE JobId = 'A4804DCF-4BB6-4109-B61C-E59C2E8A9FF7' --AND Result <> 0 ORDER BY StartTime DESC

Custom Comparison tool in Visual Studio

/wait /2 /title1:%6 /title2:%7 %1 %2 - command to compare files via custom tool in Visual Studio

God mode for Windows 7

Create folder with this name:
All.{ED7BA470-8E54-465E-825C-99712043E01C}

Check all checkboxes on the page wity JQuery

javascript:$("input[type=checkbox]").attr('checked', true);

C# Runtime objects comparison (find differences)

Put the following code to Immediate Window (Ctrl + Alt + I)

// Create StringWriter
System.IO.StringWriter stringWriter = new System.IO.StringWriter();

// Serialize object to the stringWriter.
new System.Xml.Serialization.XmlSerializer(obj.GetType()).Serialize(stringWriter, obj);

// Get serialized output.
stringWriter.ToString();

After you get xml strings for the serialized objs, that you wanted to compare you can easily compare this string in Araxis Merge or WinDiff tools.

Service Broker

С помощью следующего скрипта можно посмотреть для каких баз включен Service Broker^

SELECT [name], is_broker_enabled FROM sys.databases Order By [name]

Помоги другу научиться пользоваться гулом

http://lmgtfy.com/