Skip to content

Latest commit

 

History

History
24 lines (12 loc) · 966 Bytes

File metadata and controls

24 lines (12 loc) · 966 Bytes

My collection of SQL Server Scripts

This is a repo I use to keep SQL server related scripts, tips and tricks in one place.

Some are my own, others are copied from others. I try to remember to credit in the scripts.

Maintenance

Create a new user in masterdb and make it dbo on a client db

Backup all databases on server to a folder on the server.

Showing table sizes in SQL Server Management Studio does not always work with Azure. This script gets the job done no matter what.

Cleans up all tables related to a hangfire instance