Benchmarking Index Fragmentation With Popular Sequential GUID Algorithms

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,…


Check If Your Processor Has AVX Instruction Support

If you are trying to develop applications in Q# (Quantum Computing), then you would require support of AVX instruction set in your processor. While Microsoft is working on removing this limitation as of today, it may take a while before the limitation is removed. If your processor is shipped On or after Sandy Bridge (2011)…


Writing an asynchronous RelayCommand implementing ICommand

Read the full article here 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…


Refer azure runbook activity output in PowerShell expression

When you are creating a runbook with multiple activities, often you will encounter the need of referring an activity output in another activity. Thankfully, all the activities in the runbook can refer another activity in the parameter pane. However, when you have a piece of powershell script which needs to use the same, you don’t…


Working around the bug “Instead Of Trigger on View returns no output”

This post is to help developers implement a workaround on the bug mentioned in Read my post at which explains one of the work around which may come handy to you


Get text from RichTextBlockOverflow Control

RichTextBlockOverflow is one of my favorite control. As we all know, it allows you to render the overflown text from a RichTextBlock. Virtually you can render the overflow text to any number of level. Below is how a the overflow happens when you got one RichTextBlock and two RichTextBlockOverflow to render the overflown text. Read…


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….


Complete XAML Solution For SelectAll In Datagrid

Over the period of time lot of asks and solutions were made for selectall selector for DataGrid. However, I failed to see a solution which is completely built on XAML. When my friend approached me, I thought that I will write my own. The idea is to have a template column with a separate definition for…


Pin / Unpin Control Template For Toggle Button

I was looking for a template which will help put a pin / unpin button using toggle button. Antoni Dol who has already shared a fantastic template and I had to make few changes with respective to the pinned style as I didn’t like the original one. Read More


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 a…