The fastest way to split a string using CLR

The original post appeared here: http://sqlblog.com/blogs/adam_machanic/archive/2009/04/28/sqlclr-string-splitting-part-2-even-faster-even-more-scalable.aspx Please visit the original website for more discussion, this is for reference purpose only.   using System; using System.Collections; using System.Data; using System.Data.SqlClient; using System.Data.SqlTypes; using Microsoft.SqlServer.Server; public partial class UserDefinedFunctions { [Microsoft.SqlServer.Server.SqlFunction( FillRowMethodName = “FillRow_Multi”, TableDefinition = “item nvarchar(4000)” ) ] public static IEnumerator SplitString_Multi( [SqlFacet(MaxSize = -1)]… Continue reading The fastest way to split a string using CLR

How to Download a single folder, directory or partial repo from a GitHub repo

Well, Most of the times I see hundreds of projects in a single repo. Now, if I don’t want to download a GB of code and then eventually use just 20mb of it. How is it fare? So I wanted to create a downloader for it. Turns out I’m a little too late. There are already a… Continue reading How to Download a single folder, directory or partial repo from a GitHub repo

Difference between ASP.NET MVC and ASP.NET Web API

Found this interesting article on http://www.dotnet-tricks.com/Tutorial/webapi/Y95G050413-Difference-between-ASP.NET-MVC-and-ASP.NET-Web-API.html Most people tend to think MVC and web api are the same thing. Well not really!   While developing your web application using MVC, many developers got confused when to use Web API, since MVC framework can also return JSON data by using JsonResult and can also handle simple AJAX requests.… Continue reading Difference between ASP.NET MVC and ASP.NET Web API

Reverse shell on a Node.js application

This post is copied from: https://wiremask.eu/writeups/reverse-shell-on-a-nodejs-application/ As the site is down right now, i just thought it should be replicated at another source.   Reverse shell on a Node.js application How we obtained a Javascript reverse shell by exploiting a vulnerability on a Node.js application during a security assessment. Introduction We were tasked by a small… Continue reading Reverse shell on a Node.js application