IT, operating systems, maths, and more.
Did you know that you can execute almost any SQL query directly in your Excel spreadsheet? This can be very useful for executing queries with GROUP BY and aggregates since they cannot be generated that easily. Let’s begin. I will use Excel 2013 but this method should work in other editions as well. First, create … Continue reading Executing SQL query inside Excel spreadsheet
This is the forty seventh part of the ILP series. For your convenience you can find other parts in the table of contents in Part 1 – Boolean algebra Today we are going to solve Battleship puzzle. It is very similar to nonograms which we already solved so let’s start with the code: Application is … Continue reading ILP Part 47 — Battleship puzzle
This is the fourth part of the Sitefinity series. For your convenience you can find other parts in the table of contents in Sitefinity Part 1 — Capturing logs Last time we saw how to change database connection string for Sitefinity which can be useful if we need to extract it in runtime. In the … Continue reading Sitefinity Part 4 — Turning on Redis in Sitefinity in Azure
This is the third part of the Sitefinity series. For your convenience you can find other parts in the table of contents in Sitefinity Part 1 — Capturing logs Sitefinity stores its database connection string in App_data\Sitefinity\Configuration\DataConfig.config so you can easily modify connection string there. But what if you want to extract the connection string … Continue reading Sitefinity Part 3 — Dynamically changing database connection string in Sitefinity
This is the second part of the Sitefinity series. For your convenience you can find other parts in the table of contents in Sitefinity Part 1 — Capturing logs In order to use DI in Sitefinity you need to configure two mechanisms. One for feather widgets and one for other stuff. Let’s begin with widgets. … Continue reading Sitefinity Part 2 — Dependency injection in Sitefinity