Archived articles - January 2019

Archive for January 2019 (3)

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#

0

There is a big buzz about AI these days and major Cloud vendors like Amazon Web Services, Azure, Google Cloud are competing to bring better products to their platforms for variety of AI tasks. One of these services is speech recognition and generating transcription text from the audio. I recently worked on a project which involved transcribing large amount of daily generated audio recordings...read more

04

Jan

2019

SqlBulkCopy object collection to database table with C#

Performing SqlBulkCopy with collection of objects as a source data

0

Over the time various techniques to manipulate database data have evolved in .NET. Entity Framework is certainly the most advanced one, but for small ad hock applications where you have few inserts to deal with, ADO is still the fastest way to write data to the database...read more

03

Jan

2019

Filtering and paging collection result in ASP.NET Core Web API

Paging response data in ASP.NET Core WebApi projects

0

Paging a REST API response is equally important as filtering the data returned through REST API endpoints and they quite often come together. Just like filtering, paging limits the amount of data returned from the endpoint, saving both client and server side resources...read more

.NET

26

Mar

2021

Generic type controller methods in ASP.NET Core

Using generic type controller methods in ASP.NET Core with Swagger

17

Jan

2021

Mocking view mapped DbSets with XUnit in EF Core

Writing unit tests for view bounded entities in EF Core

19

Dec

2020

Setting up SQL Server IDistributedCache with migration in ASP.NET Core

Embedding SQL Server caching in a project with EFCore migration

11

Dec

2020

Representing available string values for parameters as list in Swagger ASP.NET Core

Valid values as list in Swagger UI in ASP.NET Core

24

Nov

2020

Running multiple queries at the same time in EF Core

Overcoming the limitation of EF Core query execution

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

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

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

13

Apr

2015

Dealing with duplicate rows in SQL Server

Finding and cleaning up duplicate rows in SQL Server tables

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