Recent Posts

Writing a powershell cmdlet…

3 minute read

A cmdlet (reads "command-lit") is a lightweight command used in Powershell environment. The Powershell runtime invokes cmdlets within the context of automati...

Use transactions for select statements

less than 1 minute read

Transactions are usually when you have insert, update or delete statements with the "atomic" behaviour. However, in a highly concurrent application, it could...

Indexing CreatedDate

less than 1 minute read

Indexing columns is a joy and adventure. I have just indexed a datetime column to boost performance. The query had a date range, and the column didn't have i...

Crystal Methodology - draft

less than 1 minute read

"Methodology" is even hard to spell. Initially, I wrote "Methodoligy" and soon noticed something was wrong. Crystal is a methodology introduced by Cockburn. ...