Over the past 30 years of working with SQL Server, I’ve realized that many routines—like user migration, partition management, and more—can be streamlined with a shared library. So, I decided to create one to simplify these complexities. The code is available at: https://github.com/sqlnotes/sql. Documentation is available at https://github.com/sqlnotes/sql/wiki.
This library isn’t designed to solve every challenge or cover every scenario. For example, its partition management feature automates tasks for index-aligned tables on the same file group only. Even with these boundaries, it can significantly reduce your daily workload.
The library is still evolving, with more features to come. Stay tuned for updates, and feel free to share your thoughts or feedback!
About SQL Server, Schema z, and Others