I’m going back into polish language

By | December 2, 2018

Hi there. It’s been a while. Sadly I’ve acquired a rather nasty writer’s block. I’ve been doing some talks and other activities in the meantime. I’m pretty much unlocked at the moment and I’ll resume my writing really, really soon. However, I’m after a long thinking and planning session. Starting January 2019 I’m going to… Read More »

Versioning data with MS SQL Temporal Tables

By | April 17, 2018

We have many solutions for versioning data through time. One of the cleanest, most transparent and pretty effortless in my opinion are Temporal Tables which are available in MS SQL 2016+ (compatibility level 130+). What’s really great about that approach is that unless you need to retrieve state from the certain point in time or browse through… Read More »

Row Level Security in MS SQL

By | February 13, 2018

In some scenarios, like single-database multi-tenant or soft delete ones, you could want to restrict access to your rows based on a value stored in one or more values stored in your columns in example IsDeleted flag or some kind of TenantId column. Since SQL Server 2016 we have a wonderful tool for that called Row… Read More »

Querying external databases in Azure SQL

By | January 25, 2018

When I’ve started working with Azure SQL there were some differences to SQL Server that I’ve needed to get used to. One of the first was that you just can’t query other databases that you’re already in, querying for [OtherDB].[dbo].[SomeTable] just wasn’t possible anymore. It appears that it may not be possible, but you actually… Read More »

Structured logs with Serilog and Application Insights

By | December 10, 2017

I’m working with Azure for quite a while now. Almost every single one of my projects lands there eventually and even if I don’t deploy it there, I’m using one of it’s databases. Recently I’ve started using Visual Studio Team Services for storing code and managing my every pet or demo project that I want to… Read More »

Multitenancy in Cosmos DB

By | October 9, 2017

Storing data in multitenant environments always required some consideration. With Cosmos DB we have 2 options that are really worthy of our attention so let’s weight some pros and cons.

You have 7 evenings in a week. Use them well.

By | June 28, 2017

On Saturday week and a half, I’ve been on finals gala of Get Noticed contest. Unlike last year I won’t write a summary about the event itself. Instead, I’ll share one really simple thing with you. On gala, I’ve been rewarded with special prizes by two sponsoring companies – Microsoft and Objectivity. Awards were really neat… Read More »

Get Noticed 2017 – I’m in the finals!

By | June 8, 2017

For the last 3 months I’ve been participating in Get Noticed contest, just like a year ago. I’ve persevered to end of the contest just like almost 200 people out of almost 1000 that started it. In the last week we as contestants was supposed to vote for other projects to choose 25 finalists from… Read More »

PaaS databases available on Azure

By | May 28, 2017

Working with Azure means you can use on of databases it provides in PaaS model. If you use them you don’t have to install and configure i.e. SQL Server on some kind of (virtual or not) machine. Databases in PaaS model have a lot of other virtues but let’s not go there in this post,… Read More »

Akka.NET #5: Persisting actors state – events

By | May 11, 2017

As I’ve mentioned in previous posts about Akka.NET, everything that actor knows is stored in memory. While we can skip any database or IO related bottlenecks because things in memory are generally speaking very fast, we must remember that memory is not a place where you can store your data for an extended period of time… Read More »

Microsoft Flow – Introduction

By | May 4, 2017

Microsoft Flow is a service I’ve been working with for some time and poking it to discover some of its possibilities. Basically, it’s service that allows to create and manage workflows from ready to use blocks representing triggers and actions.

LookUp class in C# – have you ever tried it?

By | April 25, 2017

How many times have you stored something in key/value collection? Most probably it was Dictionary or some kind of implementation of IEnumerable<KeyValuePair<TKey, TValue>>. More than a few times I wanted to store more than one value under single key, most common solution for this situation is Dictionary with collection of some kind as value type,… Read More »