Stop annoying Office365 service update emails

 

Go to: https://admin.microsoft.com/adminportal/home?ref=MessageCenter&showPref=1

A side panel will open on the right.

                Scroll to the bottom of the side panel
                Untick ‘Send me a weekly email digest’
                Click Save at the bottom of the panel.

Find the location of MS SQL MDF and LDF files

Run the following query against the Master DB to return the location of User DB file locations. You can then select all in the results pane and paste into Excel.

select name,physical_name from sys.master_files where database_id > 4