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