Database Administrator Passionate About Automation, Performance and Security
In theory, nobody should be using the sa login for anything. In reality however, I've seen many applications and processes configured to use it. Trying to change the way these applications and processes are setup, or convince people to change them, is a challenge to say the least... a challenge which I wont try to… Continue reading Renaming and disabling the sa login
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
