Archived articles - April 2016
Archive for April 2016 (1)
28
Apr
2016
Create XML/HTML with T-SQL
SQL/T-SQL8 titlesGenerating XML/HTML output in SQL Server
0
Sending email from SQL is not a difficult to achieve, but generating rich HTML content might be. SQLÂ Server itself is not built as a text processor, first approach would be to build HTML by simple concatenating the string elements.
This approach will work, but over time it will become more and more difficult to maintain especially if you need to add layout elements over time.
...read more
.NET
21
May
2019
Using dispatcher class to resolve CQRS commands and queries in ASP.NET Core
Injecting dispatcher class instead of multiple commands and queries in controller constructor
19
May
2019
Automatic CQRS handler registration in ASP.NET Core with reflection
Registering all query and command handlers in your CQRS implementation in ASP.NET Core
16
Apr
2019
Localization of the DTOs in a separate assembly in ASP.NET Core
Localizing validation messages in ASP.NET Core WebAPI
14
Apr
2019
Displaying Azure DevOps build number in Swagger UI for ASP.NET Core
How to add and show Azure DevOps build number in ASP.NET Core project and Swagger UI
8
Apr
2019
Why you should not use Authorize attributes to protect your API endpoints
Protecting ASP.NET Core WebAPI without using Authorize attribute
26
Mar
2019
DTO comments from external assembly in Swagger documentation in ASP.NET Core
Involving contract classes documentation from separate assemblies to Swagger
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