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 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: 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.
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.
Looking for a way to send calendar event invitations from within SQL Server? Did you try that one hack where you use sp_send_dbmail to generate an ics attachment file, and then found that it’s still not being identified as a calendar event in the e-mail program? I’ve been there, and out of sheer desperation of not being able to find a properly working solution, I’ve decided to build one myself. And now it’s available for your wide consumption as an open source project! This works splendidly and has a lot of useful functionalities.
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.
Respite for SQL: 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.
The product is dubbed “Respite for SQL”. It is currently in private beta.
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 Respite Monitoring solution. Open source in GitHub. Unfortunately, I’m still learning the framework, and it’s low priority on my list.
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.