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:
I also tend to upload here the scripts about which I later publish a blog post.
Below are some of the personal projects I’m currently working on (as a hobby of sorts).
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.
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:
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.
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.
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.
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.