Over the next month, with a few days change, LessThanDot will be posting, "DBA Tip a Day Series" for SQL Server Database Administrators. The hopes of this series of blogs and articles will be to assist anyone that is starting out in SQL Server and also DBAs with vested years of experience to gain more knowledge. The list of tips includes topics such as Memory, CPU, I/O, Baselines, Security Auditing, and even Professional Development. These will be tips, and not in-depth looks into each one. The tips will draw from crucial areas in the community, pulling information from many resources, to provide a comprehensive guide to finding answers.

Once completed, this list will be made available on this page as a downloadable PDF. We hope that in the PDF form, you can take the complete listing of tips to work daily as a guide and assistance when needed.

Tips posted so far are listed below and will be updated as we add the days

SQL Server DBA Tip 1 – Server Configuration – MAX Memory

SQL Server DBA Tip 2 – Server Configuration – Data/Log Files

SQL Server DBA Tip 3 – Server Configuration – Model Database

SQL Server DBA Tip 4 – Server Considerations – 32 bit / 64 bit

SQL Server DBA Tip 5 – Server Considerations – Installing Features (SSIS, SSRS, Engine, SSAS)

SQL Server DBA Tip 6 – Server Security – Windows Authentication / SQL Authentication

SQL Server DBA Tip 7 – Server Security and grouping – Schema Control

SQL Server DBA Tip 8 – Server Monitoring – Baseline

SQL Server DBA Tip 9 – SQL Server Monitoring – Default Trace

SQL Server DBA Tip 10 – SQL Server Reporting – Offload the reporting factor

SQL Server DBA Tip 11 – SQL Server Configuration – MIN Memory

SQL Server DBA Tip 12 – SQL Server Tuning – Missing Index DMV

SQL Server DBA Tip 13 – SQL Server built in DR/HA Solutions

SQL Server DBA Tip 14 – SQL Server General – Updating Production Data

SQL Server DBA Tip 15 – SQL Server Agent – Job ownership

SQL Server DBA Tip 16 – Working with Files and Folders