Varieties of properties
Property is a flexible mechanism to access private fields (set and get value) and implement computations. Now we have different ways for implementing properties - from classic with backing field and get-set keywords to modern lambda-style. Let's find is there any difference between all these properties.
This article is based on StackOverflow question
Who can foreach
This post is about popular question "What collection can be used in foreach statement?". If you think that correct answer is IEnumerable, read this post :)
Null or NotNull
This topic is related to this question on StackOverflow.
Let's discover, what are CanBeNull or NotNull attributes? How they work?
IndexOf with IEquatable
This topic started from question on StackOverflow:
different collections (Array and List) have different implementation of IList.IndexOf method.
Неизвестный T-SQL
Несколько редко используемых, но вполне полезных функций MSSQL. Если вы никогда не слышали о функциях CHOOSE, ROW_NUMBER, RANK, DENSE_RANK, FIRST_VALUE, LAST_VALUE, LAG, LEAD, PERCENTILE_CONT и PERCENTILE_DISC, то ниже вы узнаете, какие полезные вещи можно сделать их помощью. Так же, я покажу несколько примеров использования выражений OVER и PARTITION BY в оконных функциях.