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-SQL 8 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-SQL 8 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

10

Oct

2018

Extending Serilog with additional values to log

Adding additional information to log in .NET Core application with Serilog

8

Oct

2018

Logging EF Core actions to a file using Serilog

Log Entity Framework Core using Serilog in .NET Core application

16

Sep

2018

Using custom request and response serializers in ASP.NET Core

Configuring input and output serailzer/deserialier in ASP.NET Core pipeline

11

Sep

2018

Setting up .NET Core development environment on Ubuntu Linux

A quick guide for switching from Windows based Visual Studio 2017 to Visual Studio Code

8

Sep

2018

Reloading the cache automatically once expired is ASP.NET MVC

Load values to in memory cache as soon as they expire in ASP.NET MVC

27

Aug

2018

Get most visited pages of your website from Google Analytics using C#

List most visited website pages from Google analytics in your .NET application code

JavaScript

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

19

Dec

2015

GoogleMaps route jQuery plugin

jQuery plugin for easily adding route map on your website

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

18

Jun

2018

Remote PowerShell Core session to a Linux host from Windows machine

Remote sessions using OpenSSH from Windows to Linux host

17

Mar

2018

Setting IP address and domain filtering in IIS using PowerShell script

Restricting and allowing traffic to web application through IIS using PowerShell

6

Mar

2018

Converting existing website images to Google WebP using PowerShell

Encoding existing image files to Google WebP format

6

Mar

2018

Optimize JPG images for internet using jpegtran and PowerShell

Reduce size of existing JPG images without loosing quality with jpegtran

5

Mar

2018

Optimize PNG images for internet using pngcrush and PowerShell

Reduce size of existing PNG images without loosing quality with pngcrush

4

Mar

2018

Minify CSS and JavaScript files with PowerShell script

JavaScript and CSS file optimization with PowerShell script