CASE IN ORDER BY

sorting data based on a particular value.

Recreate a temporary table from TempDB

This Script can be used to pick out a temporary table from tempDB

you might want to Check and drop the table before you create it just in case , but I Haven't included it here

Find Currently Running Query – T-SQL

Following script retrieves the queries currently executing on the server.

Validating null values in a column without using ISNULL or NVL.

We can check for null values using count.

Cleanup old text files on the errorlog directory

SQL Agent job to cleanup all old text files on the errorlog directory.

Change SQL Server Service Accounts with Powershell

If you need to change multiple SQL Server Services accounts across your environment, Powershell can do that for you.

Orphaned login report for all databases

Running the sp_change_users_login @Action=Report against all databases with a simple cursor wrapped around it.

NULLs to Not NULLs

Script finds char types columns defined to allow NULL values but have non NULL values and generates the ALTER statements for the changes.

Grant EXECUTE on all user-defines types

Gives execute permission on all user-defined types for the specific user

SQL Agent job to show SQL Server service details upon agent restart

To show SQL Server and physical server details upon instance restart so that we have visibility of unexpected issues with servers and services.