About SQL Server, Schema z, and Others
The importance of object naming convention in a database system is a well known subject which will not be discussed in this article. Instead, this article focuses on how it’s defined and enforced in Schema Z. To enforce the naming conventions, function z.fn_GetExpectedName generates standard names for database objects. This function is referenced by views … Read more
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 … Read more