T SQL Date format convert function

Just came across very interesting scenario where I had to consume JSON data in SQL Server. Yes I can write C#/VB.net code and load JSON to SQL Server and go from there but what if I have no expertise in …

Consuming JSON data in SQL Server and SSIS, convert JSON to XML Read more »

I am going to list few most annoying Errors XAML designer throws to me and hope you find right solution. Most likely by this time you have already gone though your error list many times and scratching your head.. why …

XAML Tips: Why do I get error – Error The name ‘InitializeComponent’ does not exist in the current context Read more »

Recently I had very frustrating error and I thought I must blog it to save someone else time. I used MediaElement in Windows Phone to play audio files (*.mp3 in my case). Suddenly one of my change broke it and …

Windows Phone: MediaElement not playing file and failing with Error code 3123 Read more »

Recently I tried to exclude some project items and adding back from other location as “Add as Link” option. But I was keep getting below error. Visual Studio Error: Cannot add link to the file XXX. There is already file …

Visual Studio Error: Cannot add link to the file XXX. There is already file of the same name in this folder Read more »

XAML designer is full of surprise so get ready for Binging … When you get below error then just remove Default constructor with InitializeComponent() call and everything will be fine. When I had UserControl on my main Windows Phone Project I …

XAML Error: The name ‘InitializeComponent’ does not exist in the current context Read more »