- What is the solution for implementing truly dynamic search queries? Not just a stored procedure with optional parameters, but something even more dynamic than that? Let the end-user choose the exact fields and, more importantly, the operator types to use on them, in order to get the results that they need. And how do you achieve this level of dynamic interactivity without risking SQL injection? This presentation will answer these questions and give you a solution involving some advanced T-SQL martial arts!
- In this session, the second of a 2-part series, we will cover the rich tools, features, and methodologies in SSDT that allow DBAs to implement a continuous database development lifecycle. We will also learn about solutions to common fears and objections coming from naysayers, common problems while starting with SSDT for the first time, and various problematic edge cases and how to solve them. We all know the database is a critical element of your software product. It’s high time for that fact to be reflected in your database development lifecycle!
- What is source control? What is version history? What are unit tests? What do CI and CD even mean, and what the heck is an Artifact?? In this new era of Agile development, DevOps, DataOps and other weird buzzwords, we the DBAs gotta learn to keep up. It's time to add our monstrous database into the continuous integration pipeline. But first, we need to know what we're going into and need to familiarize ourselves with the terms and methodologies of the world of software development lifecycles.
- This project is for development of a stored procedure, which is to be used as an add-on to Ola Hallengren's maintenance solution, and retains the same standards and conventions in its implementation of parameters. The procedure focuses on managing database file size growth and shrink, based on specified parameters.
- 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? Then fret no more, my friends, because I’ve been there, and out of sheer desperation […]
- This open-source project aims to visualize your #SQLServer data and transaction log file contents. It is currently built with #PowerBI, but there are plans for implementation in other technologies as well (you're welcome to contribute!).
- 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.
Below are some of the personal projects I’m currently working on (as a hobby of sorts).
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: 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.
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’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. 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.
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.