Archived articles - April 2015
Archive for April 2015 (7)
18
Apr
2015
Generate sitemap.xml on the fly in Umbraco CMS
Umbraco CMS25 titlesSimple sitemap.xml Umbraco handler
0
Sitemap.xml is important component of SEO which is responsible for indexing your website. Search engine robots are generating indexes of your website based on this file.
Since content in Umbraco website is dynamic, it makes not so much sence to have static sitemap.xml file for indexing your content...read more
16
Apr
2015
Fast image search in .NET using C#
.NET178 titlesSearching images on the file system with C#
0
Searching files on the file system is pretty easy using System.IO namespace classes. The problem is if you need to youery file system with some things which are related to a file, but not related to file system itself...read more
14
Apr
2015
Benefits of binary serialization in C#
.NET178 titlesManipulationg with object instances using binary serialization in C#
0
By default object instances in .NET are never "trully" clonned. Instead .NET is doing shallow copy of instances which means if you have one variable which is object instance and you assign that variable to other variable, both of them will point the same instance of that object.
Basically you created two pointers of the same object instance.
...read more
14
Apr
2015
Scraping website content using HtmlAgilityPack
.NET178 titlesBuild you own website crawsler for extracting data from websites
0
HTML is a markup language same as XML, but still there are differences which make dealing with them a bit different. Basically HTML is a strict structure in terms of node sets and attribute sets, but in general more documents online are not exactly following the proper structure since browsers usually manage to deal with rendering out the document in UI.
However, this makes it more difficult to read them in case you want to from website itself as you cannot apply all XML rules since structure is not strictly followed.
...read more
13
Apr
2015
Dealing with duplicate rows in SQL Server
SQL/T-SQL8 titlesFinding and cleaning up duplicate rows in SQL Server tables
0
In case your data in tables needs to have unique constraint based on more than one value in the row, the proper solution for that would be a composite key.
...read more
09
Apr
2015
Microsoft IIS and ASP.NET MVC caching techniques
.NET178 titlesWays to cache data and response to improve page performance
0
Of course, the best way to make you web application work fluent is to write the code properly and design the architecture of application to meet requirements and certain load depending of the type of application. But even though architecture is good, you can always improve performance by reducing processing in application code itself.
Caching is the best way to boost web application performance and reduce load of both application (IIS) and data servers (SQL Server)
...read more
02
Apr
2015
Block referrer spam request on ASP.NET application
.NET178 titlesBlock unwanted spam traffic from your wesbite
0
Recently I was checking my Google Analytics for this website I spotted some referrer urls that were completely unknown to me. When I tried to visit the url of theĀ referrers I got a lot of commercial and pop-ups after few redirects.
It looked really suspicious, so I tried to find a little bit more about these.
...read more
.NET
4
Feb
2019
How to have a REST with Azure serverless functions
Building REST API services with Azure Functions Serverless model
21
Jan
2019
Speech to text mp3 audio files using Azure Cognitive Services and .NET Core
Transcribe mp3 audio files to text using Azure SpeechServices and C#
4
Jan
2019
SqlBulkCopy object collection to database table with C#
Performing SqlBulkCopy with collection of objects as a source data
3
Jan
2019
Filtering and paging collection result in ASP.NET Core Web API
Paging response data in ASP.NET Core WebApi projects
30
Dec
2018
Running .NET Core on Raspberry PI with Raspbian Stretch
Setting up .NET Core on Raspbery Stretch Linux distribution running on Raspberry PI
15
Dec
2018
The best option to use for a return type in ASP.NET Core WebAPI controller
Choosing the proper return type for WebApi controller actions
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
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
13
Apr
2015
Dealing with duplicate rows in SQL Server
Finding and cleaning up duplicate rows in SQL Server tables
12
Mar
2015
Reducing the number of Stored Procedures for the Application
Approach to reduce number of stored procedure for the application
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