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 в оконных функциях.
Useful Constraints
Usually we use constraints to specify the allowable values for the columns in tables. And it works perfect! But beyond that, constraints help query analizer to generate more effective query plans. How it works? Read below.
Patterns: Retry vs Circuit Breaker
Today I want to tell you about two interesting patterns: Retry and Circuit Breaker. They look the same at first sight, but they are used for solving different problems.