Database Administrator Passionate About Automation, Performance and Security
In my last post about moving database files, I touched on the point when you detach and then attach a database, you lose some of the database settings. This is a real gotcha that many people don't realise...until they've done it and wonder why things become broken. The database settings that get changed when you… Continue reading Detaching then Attaching a Database Loses the Database Settings
From time to time, the database data files (like *.mdf and *.ndf), or transaction log files (like *.ldf) need to be moved or renamed, in some way or another. Sometimes, to a different drive or volume. Sometimes, to a different folder on the same drive. Sometimes, the files need to be renamed too. For some… Continue reading Moving Database Files, It Ain’t That Hard
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
You kick off a few maintenance tasks on your SQL Server instance, or they they were scheduled to start via a job which may be slowing your server down. For example a full backup, or a DBCC CHECKDB, or maybe even shrinking a file. You might be getting a touch nervous of the potential impact… Continue reading How to Find Out the Progress of Maintenance Tasks
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
