Rafał Hryniewski / rhryniewski
C#, .NET, T-SQL, Azure
Ostatnie newsy
I’m going back into polish language
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…
Versioning data with MS SQL Temporal Tables
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…
Versioning data with MS SQL Temporal Tables
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…
Using MS SQL’s Row Level Security Policy in Entity Framework
My last blog post was about a feature in SQL Server called Row Level Security Policy. It’s quite simple and known feature for people who’re working directly with databases. But most .NET developers are using ORM of some kind to work with DB, and some of them tend to be blind to stuff that is not…
Using MS SQL’s Row Level Security Policy in Entity Framework
My last blog post was about a feature in SQL Server called Row Level Security Policy. It’s quite simple and known feature for people who’re working directly with databases. But most .NET developers are using ORM of some kind to work with DB, and some of them tend to be blind to stuff that is not…
Row Level Security in MS SQL
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…
Row Level Security in MS SQL
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…
Querying external databases in Azure SQL
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…
Querying external databases in Azure SQL
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…
Structured logs with Serilog and Application Insights
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…
Structured logs with Serilog and Application Insights
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…
Multitenancy in Cosmos DB
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. Let’s start with some explanation about how data is structured in Cosmos DB. The endpoint for accessing our data along with keys and some settings (most…
Multitenancy in Cosmos DB
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. Let’s start with some explanation about how data is structured in Cosmos DB. The endpoint for accessing our data along with keys and some settings (most…
Akka.NET #7: Creating and accessing Actor System with Dependency Injection Container
A while ago I wrote about creating Actor System and top-level actors. Sadly it was stored in a static field. And keyword static is … let’s say it’s not one of my favourites. Today I’ll show you how I’m doing the exact same thing but in Dependency Injection container. One of my favourite IoC containers…
Akka.NET #7: Creating and accessing Actor System with Dependency Injection Container
A while ago I wrote about creating Actor System and top-level actors. Sadly it was stored in a static field. And keyword static is … let’s say it’s not one of my favourites. Today I’ll show you how I’m doing the exact same thing but in Dependency Injection container. One of my favourite IoC containers…
rhryniewski
C#, .NET, T-SQL, Azure
Za dnia pracuję .NET Developer i Team Leader w firmie Elastic Cloud Solutions. Nocą walczę z głodem wiedzy i nudą jako entuzjasta chmury, bloger, prelegent i lider Białostockiej Grupy .NET.
Chwytam się wszystkiego co nowe i świeże o ile ograniczona ilość godzin w dobie mi na to pozwala, a czasem, by dać głowie odpocząć lubię sięgnąć po dobrą książkę lub komiks.