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
.NET213 titlesTranscribe 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#
.NET213 titlesPerforming 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
.NET213 titlesPaging 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
11
Sep
2020
Building and using advanced .NET Core CLI global tools
Handling commands, arguments and options in .NET CLI global tool application
6
Sep
2020
Seeding data in EF Core using SQL scripts
Another way of seeding data in EF Core
30
Jul
2020
Basic authentication with Swagger and ASP.NET Core
Setting up basic authentication in ASP.NET Core Web API projects
21
Jul
2020
Seeding data with Entity Framework Core using migrations
Using EF Core migrations to seed the data
21
Jun
2020
Dealing with default API versions in Swagger UI
Fixing additional routes in Swagger API when using default versions
11
May
2020
Setting up code coverage reports in Azure DevOps pipeline
Code coverage in .NET Core projects with Azure DevOps
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