Programming, SQL

SQL Server 2019 – very short intro

Today Microsoft presented SQL Server 2019 in general availability. Did you expect a lot of new features? I did not but it looks like Microsoft made a nice surprise. Most important features: Support for big data using SQL Server, Spark and HDFS Support for AI (including Python) Data virtualization – allows to use SQL Server …

AWS, Cloud

AWS Glacier – why to avoid

I’m using Glacier for long term backups. I was pretty happy with upload process (setup, performance) until I provisioned a vault for a long term backup (1.5~2 years) and right now I was willing to get rid of it. Unfortunately you cannot just drop it when it is not empty. You have to remove all …

Azure, Certificate, Cloud

Learning to Azure AZ-203 exam

Here is a bunch of links which I’m using in learning to AZ-203 (and AZ-204) exam: Exam homepage Learning path related to materials from Microsoft (long read) 50 minutes intro (overview) on Azure Whizlabs on the preparations Youtube videos with basic knowledge by Adam Marczak Azure for architectes by Ritesh Modi (Packt, Oct 2017) – …

.NET, C#, CSharp, Library, Programming, Tests, Unit tests

Fluent Assertions in unit tests

As a continouation of the article about unit test frameworks I would like to introduce Fluent Assertions. This framework simplifies testing by BDD style syntax. Let’s start from basic assertion. As you noticed, first is going the result, then the keyword (or rather extension method) Should() and at the end the condition (so in case …

.NET, C#, CSharp, Library, Programming

.NET unit test frameworks comparison

In .NET we have 3 dominant unit test frameworks: MS Test (v2) NUnit (3.x) xUnit (2.x) First one comes with Visual Studio, two other requires additional components installation. Initialize First difference we will find in initialization approach. In MS Test there several initialization available (by attributes): AssemblyInitialize, ClassInitialize and TestInitialize. The disadvantage is that initialization …

Cloud, GCP

Spanner – GCP custom SQL solution

Google Cloud Platform (GCP) offers 3 SQL engines as a service: MySQL 5.6/5.7, PostgreSQL 9.6 and Spanner. MySQL and PostgreSQL are quite well known across the world. Spanner is completely new player – Google’s own product dedicated to handle thousands of requests. When we setup the database, it is required to specify number of nodes …

beacon, IoT

Change battery in estimote beacon

There is a lot of videos across YouTube how to change battery in proximity beacons (big, blue one). It is quite simple as they are dedicated for such operation. But is that possible with stickers? Officialy not, but… Lets see how looks single beacon sticker (usually few cm over few cm) and it is flat. …

.NET, .NET Core, ASP.NET, C#, CSharp, Programming

Install .NET Core on Debian Linux

Microsoft prepared quite good instruction how to install dotnet runtime on Linux. I’ve been interested in Debian distro. So I went pretty smooth through the first part of the manual (system setup). However installing dotnet I had constinously an error that package cannot be found. First comment: the package name has been changed and it …

.NET, Mobile, Xamarin

How to get iPhone X front camera depth data in Xamarin iOS?

How to get iPhone X front camera depth data in Xamarin iOS? This question has been raised in many places across the web. However I did not found any good description of this problem including Apple site. They have only quite generic description of required classes without tutorial. As one of the first step, we …