Useful SQL Scripts

Welcome to my collection of useful SQL Server scripts! As a seasoned Software Engineer with a passion for databases, I have accumulated a wealth of knowledge and experience in managing relational SQL Server databases.

During my work with databases, I have created a set of scripts that have proven to be extremely valuable for various tasks and operations. I am now excited to share these scripts with the hope that it will be useful for you too.

Each of the scripts posted on this site have been used by me personally and been valuable to my work. The scripts will be documented, to ensure that they are reliable and easy to use.

Whether you are a seasoned SQL veteran or a beginner just starting out, hopefully you will find scripts here that will save you time and be of use to you.

List of scripts

Description Link to page
Search whole database for text data Search Database for Text
Shrink database file (SQL Server) Shrink Database File
Find table relationships Find Table Relationships