Generate RESTORE DATABASE Script without Using CMDSHELL

Use this script to generate RESTORE DATABASE scripts for all .BAK backup files from backup location during Instance or Database migration.

Get a CSV list of columns in a table

Short little script to get the columns in a table in order into a CSV format.

Can be useful for select or insert statements.

Generate password using PowerShell

If you want to generate temporary passwords, can use my script.

Split String Function

This In-line Table Valued Function returns a table with individual records parsed from a string.

A script to answer: Should I use SPARSE?

A brief introduction to the sparse option and script to help decide when to use it

Query to find the Job Output file location at each job step

Query to find the Job Output file location at each job step.
This helps if you want to find out the location of each output file of jobs to find out whether those are going to the right location.

List CLR Objects in Database

Script lists all the clr objects in the database.

Dynamic sql for convert table to flat file using bcp

I comment CATCH section for removing dependence to log procedures.
Github link: https://github.com/ktaranov/sqlserver-kit/blob/master/Stored_Procedure/usp_bcpTableUnload.sql

Standardize Object Names

Rename all database objects to use a standardize naming convention.

Check Up Size Of Each Folder In a Path

If you have any requirement to check the size of each sub-folders in a path, you can use my script.