Stories of daily programming
Good morning my friends! It’s been a while since our last contact, and I’m happy to be here again! Today I want to talk about how to create a basic installation of Visual Studio Code, in order to create a simple TypeScript project. But before we begin, let’s review some basic concepts… What are Visual…
Some time ago I published some posts about configuring a PHP development environment in a Windows machine. If you are interested, you can find here the first post of the series. Staying on this topic, these days I needed to create a new PHP project with FuelPHP framework, using the environment configured in the posts…
Hello my friends! Today I want to talk about some problems encountered using the property Environment.TickCount, available since the version 1.1 of .NET Framework. In a nutshell, this property tells you how many milliseconds elapsed since system boot. Why did I have to use it? During the development of TDP Robot, that I remind you…
Sometimes I like reading about (simple) mathematical problems and today I want to talk to you about a problem I encountered while reading a math book: the Goldbach’s conjecture. I admit that this is a topic that probably won’t be very useful in our life as programmers, but I find it fascinating and curious and…
Good morning to everyone! I’m sure you already know C#’s async / await keywords and the benefit of asynchronous programming in real world. In my blog we already talked about them in these posts: Working with C# async / await keywords (part 1 of 3) Working with C# async / await keywords (part 2 of…
Today I want to talk you about a problem I faced in these last days working on a ASP.NET web form project. In this project I used the library “UI for ASP.NET AJAX” from Telerik, and in particular the problem occurred using the RadGrid control. What was the problem? In a nutshell, without an explanation,…
I’m developing a C# application which uses the library ClosedXML in order to generate XLSX files, and I ran into this error: “Could not load file or assembly ‘DocumentFormat.OpenXml, Version=2.7.2.0, Culture=neutral, PublicKeyToken=8fb06cb64d019a17’ or one of its dependencies. The system cannot find the file specified.File name: ‘DocumentFormat.OpenXml, Version=2.7.2.0, Culture=neutral, PublicKeyToken=8fb06cb64d019a17′”. It’s weird, because in my development…
Read More “Could not load file or assembly ‘DocumentFormat.OpenXml, Version=2.7.2.0” »
Before talking about a multi-tenant database, let’s explain in a nutshell what a multi-tenant system is. Multitenancy is a software architecture that allows a single instance of software to be used by multiple organizations or groups of users. Database side, one possible implementation is that you use a single database instance which will contain data…
Good morning my friends! It’s been exactly a month since we last spoke! I’m very busy with a new project, which I hope to share with you soon. Apart from that, I want to share with you a link which I think will be useful: https://github.com/microsoft/sql-server-samples/tree/master/samples/databases/northwind-pubs What does it contain? From the link above you…
Today I will share with you some suggestions about using SARGable predicates. First of all let’s start explaining what is a SARGable predicate…SARGable stands for Search Argument able: in a nutshell a predicate is SARGable if Sql Server can use an index to improve the execution of the query. Use the following operators to build…