Microsoft SQL
Taking Databases Offline and/or Dropping through SQL Query
· โ˜• 2 min read · โœ๏ธ Chris Titus

The following SQL query is for taking databases offline, drop the offline databases, or bring them all back online. This affects every database in your SQL instance, so be very careful when using these. The following three queries will save you a considerable amount of time if repurposing an instance.

GFI Archiver resource usage
· โ˜• 2 min read · โœ๏ธ Chris Titus

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 performance issues.

Configuring SQL Authentication
· โ˜• 2 min read · โœ๏ธ Chris Titus

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 programs interface better with direct SQL authentication when Windows Authentication fails for any reason.