Friday, August 05, 2016

SSMS and storing templates in a different location

In Sql Server Management Studio (SSMS), there doesnt seem to be a way to store the templates in a location other than the default (which is: %appData%\Microsoft\SQL Server Management Studio\12.0\Templates\Sql). I use this feature heavily, but everytime I get a new computer, I end up loosing them templates that I have collected over time.

I found a simple solution around this and it uses the “mklink” command.


1. Open a command prompt and CD to: “%appData%\Microsoft\SQL Server Management Studio\12.0\Templates\Sql”

2. Run the command:

mklink /D MyTemplates C:\OneDrive\SqlTemplates

The above command creates a link from within the folder that SSMS looks for templates to a folder on c drive (I am mapping it to folder thats backed up by one-drive).

3. Restart SSMS, and voila, you should see this folder in your templates explorer.

Saturday, July 16, 2016

Opening JSON directly in IE

You need to add the following entries into the registry after which IE will directly render the JSON data instead of prompting to save the file:

Windows Registry Editor Version 5.00
; Tell IE to open JSON documents in the browser. 
; 25336920-03F9-11cf-8FD0-00AA00686F13 is the CLSID for the "Browse in place" .

[HKEY_CLASSES_ROOT\MIME\Database\Content Type\application/json]

[HKEY_CLASSES_ROOT\MIME\Database\Content Type\text/json]

Tuesday, June 14, 2016

Fiddler and vshub requests

If you debug a web-site project using Visual Studio 2015 or higher, you may see a ton of requests to the URL /vshub/ in fiddler. These requests are used by Visual Studio and the VsHub process to communicate with each other and are not actually related to your website.

So what can you do?

1. You can setup a filter to filter out the /vshub/ uris.

2. I prefer custom rule that I can turn on or off and here is what it looks like:

Edit the customRules.js file (Rules > Customize Rules).

Add the following lines to class Handler

public static RulesOption("Display VSHUB Requests")
var m_bShowVshubRequests: boolean = false;

In “OnBeforeRequest” add the following code:

static function OnBeforeRequest(oSession: Session) {
        if (!m_bShowVshubRequests && oSession.uriContains("/vshub/"))
            oSession.Ignore(); //oSession["ui-hide"] = "true";

And now by default it will never show and if you want to look at it, you can do so by enabling it at:


Tuesday, May 24, 2016

How to feed your baby step by step

Its hard to know how much to feed your new-born. Here is a hand out that we received from our doctor (Partners in Pediatrics) that I found extremely helpful.


Every baby is very special. This is a general guide for feeding your baby, so don't worry if your baby eats a little more or a little less than this guide suggests.

Tuesday, April 26, 2016

CRM XRM service including error information

Here is what you need to add to the web.config of the CRM website so that you can see why the XRM service maybe failing on a call:


    <serviceHostingEnvironment aspNetCompatibilityEnabled="true" />




          <serviceDebug includeExceptionDetailInFaults="true" />





Friday, April 15, 2016

RegionManager.RequestNavigate is not working!

This is not so much a solution, but a debugging hint.

Recently I was banging my head for hours on a RequestNavigate not working. After a lot of googling and head banging, I found out that RequestNavigate has a callback and it has useful error information that can help in determining the issue.

The signature is: public static void RequestNavigate(this IRegionManager regionManager, string regionName, Uri source, Action navigationCallback)

And here is how you can use it:

_regionManager.RequestNavigate(RegionNames.MainRegion, uri, nr =>
if (nr.Result.HasValue && nr.Result == false)
//put a breakpoint in here to determine why. nr.Error will have the data
var error = nr.Error;

In my case, I found out that the caller was on a background thread and hence, the navigation was failing silently. By subscribing to my event on the UI thread, I was able to solve my issue!

Saturday, December 19, 2015

TMS Dining Nook Assembly Instructions

I had a hard time finding the instructions for this dining nook. NOw that I have it, thought I would post it for others that might have lost it and need it again:

Thursday, October 15, 2015

Windows 10 – BSOD on resuming from hibernate

After upgrading my machine to Windows 10, I found that after I hibernated by computer, it would always BSOD on resuming with the error: SYSTEM_SERVICE_EXCEPTION (cng.sys). After a whole bit of troubleshooting and nothing working, I found an old post regarding a similar failure on Windows 7. It suggested turning off Hyper-V (via Windows Features).


Turning it off on my Windows 10 machine, seemed to make the BSOD issue go away.

Monday, September 28, 2015

Importing Windows Event Log into SQL Server

LogParser is your friend:

Here is a sample command to import the data into SQL Server:

LogParser -i:EVT "SELECT * into prodEvents FROM  c:\temp\prod.evtx" -o:SQL -server:sqlServerName -driver:"SQL Server" -database:testDb -createtable:ON  -cleartable:ON -transactionRowCount:-1  -maxstrfieldlen:8000

note: use -username:test -password:test to specify username and password if you need to.
note: I cant seem to find a way around the 8000 character limit in LogParser. So it always truncates at 8000 characters :(

The table definition is:

CREATE TABLE [dbo].[prodEvents](
    [EventLog] [varchar](8000) NULL,
    [RecordNumber] [int] NULL,
    [TimeGenerated] [datetime] NULL,
    [TimeWritten] [datetime] NULL,
    [EventID] [int] NULL,
    [EventType] [int] NULL,
    [EventTypeName] [varchar](8000) NULL,
    [EventCategory] [int] NULL,
    [EventCategoryName] [varchar](8000) NULL,
    [SourceName] [varchar](8000) NULL,
    [Strings] [varchar](8000) NULL,
    [ComputerName] [varchar](8000) NULL,
    [SID] [varchar](8000) NULL,
    [Message] [varchar](8000) NULL,
    [Data] [varchar](8000) NULL

Keep in mind that you can run many SQL like queries directly against the EVT file locally on your machine without importing the data into a table.

Other useful queries:

logparser.exe -i:evt "select * from c:\temp\prod.evtx where timegenerated > '2015-09-01 00:00:00'"

More info:

Useful commands and tips: (for, but useful even for Event Logs)

Monday, March 30, 2015

Visual Studio rebuilds all projects instead of just the projects referenced by the current project

One of our Visual Studio solutions all of sudden started building all projects in the solution, even when I was trying to build one single project.

I found that Visual Studio allows you to set a flag in the registry that allows you to see more information regarding why it thinks a project is out of date and is trying to build it. The setting is called: U2DCheckVerbosity, which I believe stands for “Up to Date Check” verbosity level. By setting it to a value of 1, you get information in the output window that specifies why VS believes a project is not up to date and is causing it to build.

You can either create the new key manually, or copy the following text into notepad and save it as a REG file and run it.

Windows Registry Editor Version 5.00


Once thats done, if you look in the output window, you will see messages like:

Project ‘xxxxxx’ is not up to date. Project item ‘some_file_path\log4net.config' has 'Copy to Output Directory' attribute set to 'Copy always'.

I had not realized that “Copy Always” would cause a project to consider itself dirty and had gone through and set it on some config files I had recently added. So it turned out, it was I that was at fault. Fixed the config issue and everything is good now.