Rob Janssen

All | Unread | Read

Why you should use SQL CTEs

Last week I was explaining to a junior analyst how CTEs (common table expressions) work. They’re persisted temporary data sets, that allow you to store a single query to go back to later in your script. They're underrated compared to the subquery, that seems to be what most analysts around me use.

The Illustrated TLS Connection

In this demonstration a client has connection to a server, negotiated a TLS 1.2 session, sent "ping", received "pong", and then terminated the session. Click below to begin exploring. This choice of version number (3.3 rather than 1.2) is due to TLS 1.0 being a minor revision of the SSL 3.

The danger of TaskCompletionSource<T> class

TaskCompletionSource<T> class is a very useful facility if you want to control the lifetime of a task manually. Here is a canonical example when TaskCompletionSourceis used for converting the event-based asynchronous code to the Task-based pattern:

What indexes should I create on a table?

While designing a software system that involves a database, this question inevitably pops up in the minds of software developers.

What is a website that everyone should know about but few people actually know about?

Of course not otherwise how else will the great Pearson stay afloat? /s Someone created an algorytm that wrote every possible 1000 digit paragraph bthat features lowercase letters and the punctuation marks , . and ? With a space of course.

Supercharger : Visual Studio Marketplace

.NET application architecture

Xamarin allows you to build native Android, iOS, and Windows applications using .NET. Common patterns, such as MVVM, combined with good application layering, will maximize code sharing and result in an application that is easier to understand, test and maintain.

Implementing Authentication and Authorization with ASP.NET Core 2 - Chris Klug

Authentication and authorization is not a fun topic for most people. It is generally that thing that has to be there, but nobody really cares about. And on top of that, every time the requirements are a little different. And every time we have to figure out how to write all the plumbing to get it do

The State of C# - What Have I Missed - Filip Ekberg

One of the most popular programming language on the market is getting even better. With every iteration of C# we get more and more features that are meant to make our lives as developers a lot easier. Support for writing (hopefully) better and more readable asynchronous code, being able to do patter

C# 8 - Jon Skeet and Mads Torgersen

Just in case the stream of C# 7 point releases hasn't given you enough to think about, let's have a look at what might be in C# 8.Nullable reference types? Shapes? Extension everything? One thing's for sure: this talk won't be pinned down until it's being delivered...

This Read-It-Later-list is just that, bookmarks of stuff I intend to read or have read. I do not necessarily agree with opinions or statements in the bookmarked articles.

This list is compiled from my Pocket list.