st's blog

The brilliance and poverty of microservices

Submitted by st on

This is the revised translation of my article published in "ITWeek" magazine January 24, 2019.

An expert tries to know more and more about less and less until he knows absolutely everything about nothing. And a philosopher tries to know less and less about more and more until he knows nothing about everything.
Daniil Granin, "Going Inside a Storm"

Agile or not agile

Submitted by st on

Bertrand Meyer's article "Making sense of agile methods" (PDF, November 2017)
Russian translation published in "Open systems" magazine N°2-2018 "Об Agile по гамбургскому счету"

Some citations (I completely agree according to my experience).

Everything will look fine until you suddenly discover that the next user story conflicts with previously implemented ones, and you have to go back and rethink everything

SQL Server: temporary tables and constraint names

Submitted by st on

Local temporary tables are isolated in the scope of current session regardless its name. It means that #temp_table in the session 1 is not the same that #temp_table in the session 2. However, the names of constraints are stored in the metadata of tempdb and can produce duplicate name errors.

SQL Server: key-value store table and hash index

Submitted by st on

Hash indexes are used as entry points for memory-optimized tables; both features were introduced in SQL Server 2014. Let's look at index performance in scenario "key-value store".

Scenario and environment

The table stores a significant volume (about 10 millions rows) of pairs key-value. The key is of integer type and the value is a small random string.

The table store is used :

  • random read of a value from a key
  • random update of a value by a key

We will tests the scenario for the following types of table :

Pages

Subscribe to RSS - st's blog