SQL/T-SQL - February 2015

24

Feb

2015

Transform comma seperated string to rows in SQL Server

Use comma separated string in TSQL

SQL/T-SQL10 titles

0

Passing complex data to and from stored procedures has always been a tricky one. The most elegant way to pass values to a stored procedure is to use predefined data types in SQL Server...read more

18

Feb

2015

Migrate stored procedures across databases

Copy stored procedure from one database to another with T-SQL

SQL/T-SQL10 titles

0

When working on an app you create all your stored procedures, functions, tables, view and other objects in a development database (or t least it should be like that). A small but annoying problem occurs when you have to migrate your stored procedures to test or production database. Imagine during development you had let's say 20 stored procedures...read more

.NET

5

Jun

2022

Using dotnet nuget package vulnerability scan in Azure DevOps build

Listing nuget vulnerabilities and controlling build in Azure DevOps

5

May

2022

Protecting static files in ASP.NET Core using custom middleware

Restricting access to specific static content with middleware in ASP.NET Core

20

Dec

2021

Supporting multiple authentication schemes in asp.net core webapi

Using more than one authentication schemes in webapi projects

12

Dec

2021

Controlling the flow of migrations in EF Core

Altering EF Core migrations execution order

28

Nov

2021

Unit of work pattern with Dapper

Implementing unit of work pattern with Dapper in .NET 5

21

Sep

2021

Adding display name to Enum values

Implementing additional values for Enum items in C#

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

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