Rename logical & physical MSSQL files

This post will provide guidance on how to amend the logical and physical file names of a MSSQL database.When a copy of a database is restored as a new database, the logical file names will remain the same as the source database.Firstly, check the current logical and physical file names: USE master GO SELECT name AS [Logical_name], physical_name AS [File_Path], […]

SnipIT No 7: Change colour when using “ls”

SnipIT is a series of short blogs containing useful information in an easily digestible format. Listing the files and directories in a PuTTY session when connected to Red Hat recently, I realised how bad the contrast is between the default dark blue on black. To change this to something more usable, we can edit the bashrc file. $ vi ~/.bashrc […]