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
Tag: Server Configuration
Login Default Languages and the Effects of Getting it Wrong
There have been countless times where I've seen dates in SQL Server being interpreted differently to what people have expected. Sometimes the date is interpreted in the format dd-mm-yyyy whereas other times the date format is interpreted in the mm-dd-yyyy format. This can greatly change the results of queries or change the date that was… Continue reading Login Default Languages and the Effects of Getting it Wrong
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