We’ve always been working with timeseries data and at one point we all once came accross a challenge of searching data points based on a time period. Yesterday, while we designing our API, our team shared this interesting representation from OSISoft API and I thought this could be fun code :)! For copyright reasons, I have re-draw the visualization. Headers from left are time, headers from right are search results whre [x] are matching rows for given search mode. ... Read more

Today I had great time hearing various arguments on pros and cons of OData in our services. Some of our team mates shared the pain of changing interfaces to accomodate fast chaning business requirements and concerns on future maintenance costs to support new capabilities. They also argued if we expose OData in our internal APIs, the clients would only have to draft the right query and would only have to do this once to satisfy all future queries. ... Read more

Container technology is relentlessly changing the way we construct software. The release of docker support for SQL Server and Linux version is a leap forward on database devops evolution. In this lighweight demo, you can create or compose a container running SQL Server on Linux host and throw away when you’re done. The possibilities are yours to explore. For full source code available here. Motivation Allows your regression tests to freely drop and re-create database during execution Explore new releases and versions of SQL Server Keeps you away from ivory tower of DBAs during development A step toward Infrastructure as a Code (IaaC) Tools Windows 10 or Windows Server 2016 Docker for Windows (Switched to Linux container) VS Code Build & Run 1. ... Read more

In the past weeks, @mikependon and I works to stabilize #RepoDb; a lightweight and fast repo-based ORM for .NET. Mike went so deep that we have used direct IL emit codes to optimize our data readers. But if we are fast, how fast are we compared to other micro and full-ORMs? This perf report is our first attempt. TL; DR; You may download the full test results here. For this task, we have chosen to run RepoDb with the ff benchmark frameworks. ... Read more

Three months ago, my close friend and colleague @mikependon pitched-in the idea of creating our own Object/Relational Mapping tool. Our ORM is a core component of our services could be a costly adventure to change, I immediately sense the risks there. Yes, I am skeptical but I also don’t want to immediately scrap this innovative idea. Fast forward… In past 2-weeks, me and Mike we’re pairing to make the first stable release of RepoDB; the ORM tool we have just debated. ... Read more

If you are new to BDD/TDD/Specflow/Cucumber/Gherkin buzz, its worth spending few minutes reading this. Intro to BDD How about working with team from business that created 100+ Specflow feature scenarios before we even start writing a single C# code! It’s astonishing, TDD in its own form, and I love it! So we supported all behaviours and make them all passed over time. Deployed the services. Done. As we get better, we receive more feature scenarios: like 5 today, and maybe 10 more next week. ... Read more

This is part of a five-part series in my exploration of Azure microservices facilities. Kick-start containerized microservice CI/CD with Azure DevOps Build containerized microservices with Docker and .NET Core 2.1 Build containerized web dashboard with ASP.NET Core Email service health report with Azure serverless Scale out services with Managed Kubernetes AWS rocks the cloud computing world with the introduction of AWS Lamda; AWS Lamda pioneered serverless computing based on a simple promise: “You write your code, the rest is on us”. ... Read more

This is part of a five-part series in my exploration of Azure microservices facilities. Kick-start containerized microservice CI/CD with Azure DevOps Build containerized microservices with Docker and .NET Core 2.1 Build containerized web dashboard with ASP.NET Core Email service health report with Azure serverless Scale out services with Managed Kubernetes Creating the service health dashboard We’ll KISS it. The front end layer displays the state of services and the heartbeats we received. ... Read more

This is part of a five-part series in my exploration of Azure microservices facilities. Kick-start containerized microservice CI/CD with Azure DevOps Build containerized microservices with Docker and .NET Core 2.1 Build containerized web dashboard with ASP.NET Core Email service health report with Azure serverless Scale out services with Managed Kubernetes Building the REST API There are two ways to create our REST API and each have pros and cons: 1. ... Read more

This is part of a five-part series in my exploration of Azure microservices facilities. Kick-start containerized microservice CI/CD with Azure DevOps Build containerized microservices with Docker and .NET Core 2.1 Build containerized web dashboard with ASP.NET Core Email service health report with Azure serverless Scale out services with Managed Kubernetes Background I have always been fascinated with container technology and over years I have watched the technology mature. ... Read more