.NET - November 2020

24

Nov

2020

Running multiple queries at the same time in EF Core

Overcoming the limitation of EF Core query execution

0

Since the time of ADO in .NET one of the limitations was that one connection can execute single command at the time. Same limitation Entity Framework inherited and you can execute single command at the time per instance of your DbContext...read more

17

Nov

2020

Accessing multiple databases from the same DbContext in EF Core

Multiple database access from the same DbContext in Entity Framework Core 5

0

It is not uncommon to have a requirement to access tables or views in different databases in the same query. In order to be able to do your joins on tables or views in different databases you need to do it in the same connection instance which is bound to DbContext, therefore this access as to be accomplished from the same DbContext instance...read more

JavaScript

28

Oct

2018

HTML5 localStorage with expiry with vanilla JavaScript

Using HTML5 localStorage with expiry

8

May

2018

Monitoring DOM changes with JavaScript

Handling DOM changes with plain JavaScript

9

May

2017

Non blocking CSS load on the page

Load external CSS files in an async manner

16

Mar

2017

Serialize html form to JSON without using JQuery

Transform user input from HTML form fields to JSON

17

Jan

2016

Copy text value to clipboard using jQuery

Simple sample of using jQuery to copy value to clipboard

11

Jan

2016

Resize image on the client side with JQuery

Reducing the upload sie by resizing image on the client side

SQL/T-SQL

22

Feb

2022

Select column names with values from SQL Server database

Fetching column names with its value in T-SQL using built in JSON methods

23

May

2020

Identifying opened connections for the specific application in SQL Server

Connection listing queries in SQL Server

3

May

2018

Reading JSON data in T-SQL on SQL Server

Extracting values from JSON string on SQL Server using T-SQL

28

Apr

2016

Create XML/HTML with T-SQL

Generating XML/HTML output in SQL Server

24

Nov

2015

IP address to octets split in TSQL

Split IP addresse into octets in SQL Server

20

Jul

2015

Getting first and last second of the current year, month and day

Using minimum and maximum date time in SQL query

Umbraco CMS

2

Mar

2018

Minify HTML output of your pages

Minification of HTML output using ASP.NET IHttpModule

18

Apr

2015

Generate sitemap.xml on the fly in Umbraco CMS

Simple sitemap.xml Umbraco handler

2

Mar

2015

Accessing UmbracoHelper in HttpHandler request

Working with UmbracoHelper and IPublishedContent in HttpHandler

14

Sep

2014

Same page language switching in Umbraco

Land on the same page in different language in Umbraco using Relations

4

Sep

2014

Getting cropped image the smart way

The way to get cropped image URL with option to load original image too

27

Aug

2014

Fastest way to return JSON result from a controller

Resturn JSON in MVC controller action

PowerShell

1

Nov

2021

Adding centralized secrets service to Azure Service Fabric cluster

Adding secrets store and using store secrets in Azure Service Fabric

6

Jun

2021

Customizing PowerShell terminal with oh-my-posh v3

Setting up oh-my-posh v3 custom theme for PowerShell

1

Feb

2021

Setting Azure DevOps pipeline variable from PowerShell script

Output value from PowerShell script to Azure DevOps builds and releases

27

Sep

2020

Customizing WSL2 on Windows with screenfetch and oh-my-zsh

Setting up screenfetch and oh-my-zsh for use in WSL2 and Windows Terminal

8

Jan

2020

Generation Java client libraries for REST service with swagger-gen Azure DevOps

Compiling and serving MAVEN packages for Java with Azure DevOps using PowerShell

2

Sep

2019

Cloning Windows Virtual Machine in Azure without having to stop it

Zero downtime cloning of Virtual Machine in Azure using PowerShell