Beginner Archives - Page 3 of 3

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 […]

Nov 19

Reset a lost or forgotten SA password

By Lori Brown | Beginner , SQL Administration , SQL Server

— By Lori Brown @SQLSupahStah Any login that is a member of the sysadmin role can reset the SA password. But, what if you have a hostile takeover by an application or for some strange reason don’t have any other logins as members of the sysadmin role? Don’t laugh! I have actually run into both […]

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 […]

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. […]

Oct 29

Find and Remove Duplicate Records

By Ginger Daniel | Beginner , Miscellaneous , SQL Development , SQL Server

— by Ginger Keys Having duplicate records in a database is an age-old problem that almost every organization has to deal with. Duplicates can appear because of careless data input, merging records from old systems into new systems, uploading leads from purchased lists, and multiple other reasons. Identifying these duplicate records can also be tricky. […]

Oct 23

Contained Databases – Pros and Cons

By Ginger Daniel | Beginner , Miscellaneous , SQL Administration , SQL Server

Beginning with SQL Server 2012 and beyond, Microsoft has developed a new feature in all editions of SQL Server that allows us to create databases independent of the instance hosting that database. In this article I will cover some of the features, pros and cons, and how to create a contained database. What is it? […]

« Previous 1 2 3