When configuring a new SQL Server instance, you probably want to configure Database Mail. As with all your post install configuration changes, it's better to do it using a script to save yourself a whole heap of time while ensuring all your SQL Server instances are standardised and consistent. Unfortunately it's not as easy to… Continue reading Configure Database Mail and Test it – All using T-SQL
Category: Server Configuration
Default Directories
You decide to create a new database, or restore one for that matter, and you find that it creates or restores the database to a file location you didn't expect. Why did the data file end up on the C: drive? Why did the transaction log file end up in the same location as the… Continue reading Default Directories