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.

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

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.

SQL Database Migration: Lower to Higher Version

Database Migration - Lower version of Microsoft SQL Server to Higher version of SQL Server, with complete DBA Guide with Automated Scripts and Steps.

Function to calculate and return age in text to closest minute between

Calculates and returns age in text to closest minute between 2 datetimes, eg: 2 Years, 4 Months, 12 Days, 4 Hours, 17 Minutes

Productivity Keyboard Shortcuts 2

This is something i can not work without anymore