Category Archives for "Beginner"

Mar 09

March 2016 Tip of the Month -Full Text Indexing – Clean up those log files!

By SQLRx Admin | Advice , Beginner , Miscellaneous , SQL Administration , SQL Server , Tip of the Month

If you have Full Text catalogs set up in your databases you may notice that inside your log folder there will be lots of files named SQLFTxxxxxxxxxxxx.LOG. These are known as crawl logs which are designed to log information on the full text indexing. These logs can really pile up and there is no automated […]

Continue reading
Nov 12

Good DBA! Tasks that all DBA’s should do to have a Stable SQL Server

By Lori Brown | Beginner , SQL Administration , SQL Server

— By Lori Brown  @SQLSupahStah What are the critical aspects of SQL Server that a DBA should check on a daily basis?  How about on a weekly or monthly basis? Daily Checklist Backups: Check your backups (Full, Differential, Transaction Logs) to validate that they were successfully created per your company’s policies. Nightly Processing: Review the nightly or […]

Continue reading
Nov 04

SQL 2014 Backup Encryption

By SQLRx Admin | Beginner , SQL Administration , SQL Server , Tip of the Month

Available in SQL Server 2014 Enterprise Edition and Standard Edition Backup encryption has been introduced in SQL 2014 to allow encrypting backups without being forced to encrypt the entire database. Several encryption algorithms are supported, including Advanced Encryption Standard (AES) 128, AES 192, AES 256, and Triple DES. You can also compress the encrypted backup. […]

Continue reading