Taking Databases Offline and/or Dropping through SQL Query
The following SQL query is for taking databases offline, drop the offline databases, or bring them all back online. This affects every database in you...
Collection
Microsoft SQL
GFI Archiver resource usage
Does your GFI Archiver resource usage SQL process ballon over 8GB? If so, the following procedure will reduce usage by about half and fix many perform...
Configuring SQL Authentication
Configuring SQL Authentication can be tricky at times, and this is a great article that goes over the two types of authentication in SQL. I find some...