Site icon Eitan Blumin's blog

Projects Portfolio

Other Projects

Below are some of the personal projects I’m currently working on (as a hobby of sorts).

Completed Projects:

SQL Vulnerability Assessment Tool – Rules Reference List

This is not so much a project, as it is simply an online reference page that I created for the various rules executed by the SQL Vulnerability Assessment Tool in SSMS. Personally, I’ve been looking for such a page for a while now, but never found one. So eventually, I figured “why not do it myself?”. Cool script attached!


A CLR function that allows running REST commands (i.e. http web requests) right from within SQL Server. This is a fork of the clr_http_request project initially published By Eilert Hjelmeseth here:
My version extends the project by adding more advanced authentication methods. It’s open source in GitHub and already has a release.


A CLR assembly with a couple of functions that simulate the OPENJSON and JSON_VALUE functions introduced in SQL Server 2016. One of my clients used an older version of SQL Server without a possibility to upgrade (yet), so I created this assembly for them (I couldn’t find such an assembly anywhere else, so I made it myself). Figured it might be useful for other people with pre-2016 SQL Server versions, so I made it public on GitHub.


A new implementation similar to FilterParseXMLParameters which implements dynamic search queries while protecting from SQL injections. This time, implemented in JSON instead of XML, and with a few other improvements. It’s presented in a webinar, and published as a GitHub repository that includes a simple front-end demo as well.


This is a stored procedure written in T-SQL, which can be used to generate a CREATE TABLE script in T-SQL for a given table in Microsoft SQL Server. This is an open-source project at GitHub and you can contribute your own issue and pull requests to enhance its capabilities.

Projects In Progress:


CRUD Application Generator using SQL Server, Classic ASP, Bootstrap and AngularJS. Based on the AdminLTE template. It’s open source in GitHub. I will also be working on a .NET+Angular version with more advanced features.

Abandoned: Respite for SQL: Monitoring & Alerting Platform

I’ve been developing a highly-customizable, lightweight monitoring and alerting solution for Enterprise environments with multiple SQL servers. Implemented with a SQL Server back-end, and web front-end. It was developed while using the simplest and most-accessible platforms in mind, such as SQL Server as a back-end (utilizing linked servers, service broker queues, SQL agent jobs, etc.), and classic ASP (a.k.a. ASP3).

The product is dubbed “Respite for SQL”. It is currently abandoned and is no longer developed, due to lack of time and market saturation of similar tools.


Inspired by Eilert’s project (clr_http_request), I wanted to create something similar for running WMI queries from within SQL Server (i.e. clr_wmi_request ). I made good headway and this even works with remote WMI queries. This too is open source in GitHub.

Exit mobile version