In a multi-tenant data insert scenario, GUID is a great data type for primary key. Since it is unique globally, you will not need to rely on any range or custom logic. However, if you extend these columns as index, you will end up with frequent index fragmentation and hence bad performance. In this post, […]
Writing an asynchronous RelayCommand implementing ICommand
If you are familiar with MVVM, then you are already familiar with relay commands. We use relay commands to map a method with the ICommand raised from a control. Below is the typical code snippet you may have seen a lot of time. The class below is pretty simple; it accepts a method and allows […]
A poor man’s implementation of row level security in SQL
Often I have come across situations where the enterprise customers want to restrict data availability to their employees / IT not only from the application but also at the database level. Government / Public sectors have a common requirement that they don’t want everybody at their IT team to be able to query everybody’s data. […]
Pin / Unpin Control Template For Toggle Button
I was looking for a template which will help put a pin / unpin button using toggle button. Thanks to Antoni Dol who has already shared a fantastic template in his blog. I had to make few changes with respective to the pinned style as I didn’t like the original one. So I made few […]
How To Check If Cookies Are Enabled In Windows Phone
Windows Phone as of today doesn’t provide a property or direct API call which will help you identify whether the user has chosen to accept cookies or not. However, we can identify this pretty neatly by trying to get the cookie collection. So to achieve this, we are going to get the cookie collection for […]
DIY Home Security Using Kinect, Azure, Windows Phone and Windows 8
Most the people who were in the TechEd 2012 India would have witnessed the cool demo by me and Abhijit Jana made on the opening Keynotes of the event. And now we would like to share how this solution was developed so that you can also build your own. Background Before we could pitch […]
Byte Array To BitmapImage Converter & IRandomAccessStream Implementation For Windows 8 Metro
After writing the application for Windows Phone, I wanted to bring the same feature with Windows 8 Metro but unfortunately, metro didn’t support the same converter for the reason that BitmapImage can no more read from Stream but only from IRandomAccessStream. I was very much disappointed with the Metro 8 API for having different design […]
TechEd India 2012 – Integrating Windows Azure, Windows Phone, Windows 8 Metro and Kinect
I am very happy and excited to announce that this TechEd I will be presenting along with my friend Abhijit Jana. We will be presenting a session which will showcase the integration of Windows Azure, Windows Phone, Windows 8 Metro and Kinect. For the presentation we have developed a proto solution for Home Security. Well […]
Byte Array To BitmapImage Converter For Windows Phone Silverlight
While you are binding a byte array of an image file to a Image control in WPF, it displays the image without any problem since, it has the converter for the same defined withing itself. While in Windows Phone, you don’t get the same liberty as with the WPF. Below is the code which I […]
Why Ternary Operator Doesnt Support Nullable Types
Nullable types and ternary operators are around for many years now and may be not everybody know that ternary operator doesn’t support assigning null values to nullable types. There is also a bug logged in the “connect” site and it is closed by design. To understand the real reason for the design, I got in […]