Scripts that I made to help with my journey with SQL Server with:
๐ Finding SQL Server objects such as views, procedures, functions, tables, columns and parameters by their name or type;
๐ Find views, procedures and functions by the content inside of them;
โ๏ธ Force renaming database;
โ Kill all process from a database;
๐ฆ Compress database log to make it smaller;
๐ Seeing important info about a database such as compatibility level, collation name, cached size;
๐ See latest databases restore;
๐ See current queries running on server, execution plan, how much long they were being executed, query content and be able stop them.