Current Projects

GitHub Gists

Throughout my day-to-day job, I get to write a lot of T-SQL scripts for all kinds of varied needs and scenarios. Every once in a while I get to write something pretty cool which I think other people can also find useful.

When that happens, I usually try to clean that script out of any personal information (to keep my NDAs, after all) and then upload it to GitHub as a “Gist”.

With time, I’ve accumulated quite a collection of such Gists, all of which are publicly available here:

Eitan Blumin’s GitHub Gists

I also tend to upload here the scripts about which I later publish a blog post.

Projects

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

 

Completed Projects:

 

ClrHttpRequest

A 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: http://www.sqlservercentral.com/articles/SQLCLR/177834
My version extends the project by adding more advanced authentication methods. It’s open source in GitHub and already has a release.

SqlClrJsonParser

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.

 

Projects In Progress:

 

CRUDE-ASP

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 version with more advanced features.

 

SQL Server Monitoring & Alerting Platform

I’m developing a highly-customizable, lightweight monitoring and alerting solution for Enterprise environments with multiple SQL servers. Implemented with a SQL Server back-end, and classic ASP web front-end. Probably won’t be open source, but should be much cheaper than most available SQL Monitoring Tools in the market right now.

 

Azure Data Studio Extension

I’m interested in building an extension for Azure Data Studio, which would provide end-to-end monitoring information as a “pocket-size” version of the Guardian Monitoring solution. Open source in GitHub. Still learning this.

 

ClrWmiRequest

Inspired by Eilert’s project, 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.

 

FilterParseJsonParameters

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. Will be published in a new blog post, presented in a webinar, and a GitHub repository that includes a simple front-end demo as well.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s