Today I would like to officially unveil 3 new open source SQL Server projects that I have on GitHub! I will have upcoming blog posts that discuss each project in more details, but here is a brief summary of each:
- SQL Server Metrics Pack – A collection of scripts for gathering and persisting metrics (currently just index and file metric) from SQL Server’s underlying DMO’s.
- SQL Server Permissions Manager – A suite of scripts that allows you to take “snapshots” of users and permissions across any or all of the databases on your SQL Server. You can then script out user permissions, restore snapshots, clone users, and more.
- SQL Server Index Insight Scripts – A collection of scripts (OK, currently just 1 script) to use with indexes in SQL Server. This one will really just be a bunch of scripts I use when working with indexes.
It has taken me a while to write this post. If you look at the initial commit dates, all 3 of these projects have been on GitHub for a few months. I am both excited and terrified to open these projects up to the public. I have been running the code in these repositories on my servers for quite a while, testing, double checking for problems, trying to fix every bug I could so that I could release a perfect solution. After all, I don’t want anyone to think my code is BAD! But, I finally came to the realization that there is no way that I can account for all of the different configurations or scenarios that are out there in the SQL Server world. As with most open source projects, these are a continuous work in progress. So, with that in mind:
It works on my machine!
And now it’s time to make it work on yours. I have no doubt that there are issues with my code. Bugs. Inefficiencies. Typos. Tabs vs. Spaces. There will be problems and situations that I never thought of, but you may encounter regularly. I started these project to fit my needs, and hope that you will want to contribute to help make them fit your needs as well.
I am looking forward to working with (and learning from) the SQL community on these projects! Please let me know if you are interested in contributing.