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.