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

0

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 https://connect.microsoft.com/SQLServer/feedback/details/427666/instead-trigger-return-zero-number-into-output-identity Read my post at http://microsoftprogrammers.jebarson.com/bug-instead-of-trigger-on-view-returns-no-output/ which explains one of the work around which may come handy to you

0

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

0