Tag Archives: DBA

Detaching a Database – File Security Gotcha

A look at what happens to file permissions when you detach a database with an active directory or machine user account. Continue reading

Posted in Administration, Internals | Tagged , | 5 Comments

Procedure Creation – Correct Syntax, Wrong Database

A brief look at why a procedure is created even with a reference to an object that isn’t valid. Continue reading

Posted in Administration, Internals, T-SQL | Tagged , | Leave a comment

Database Restores – Zeroing Out Log Files

A look at what happens the log file when the database is restored. Continue reading

Posted in Administration, Internals | Tagged , | Leave a comment

Off’ing a Database

A brief look at taking a Microsoft SQL Server database offline. Continue reading

Posted in General Conversations | Tagged | 7 Comments

Fire Prevention

Fire prevention, DBA Style! A few thoughts on things that you can do as a DBA to help prevent fires. Continue reading

Posted in General Conversations | Tagged , | Leave a comment