SQL Server DBA Best Practices Tips
All Tips
Administration
Checklist
- Checklist to Re Architect a SQL Server Database
- SQL Server DBA Checklist
- SQL Server DBA database management checklist
Configuration
- Best Practice Recycling SQL Server Agent Error Logs
- Enable SQL Server Instant File Initialization for Time Savings
- SQL Server Hardware Configuration Best Practices
Databases
- Best Practices Backup System Databases in SQL Server
- Best practices for SQL Server database ALTER table operations
- Best practices for working with read only databases in SQL Server
- Steps to Rename a SQL Server Database
- Use Consistent SQL Server Naming Conventions
Deployment
- Automate Removal of Saved SQL Server Objects During Deployments
- Backing up SQL Server Data for Rollback Purposes
- Identify and Delete SQL Server Archive Tables for Rollback
Development
- Benefits of SCHEMABINDING in SQL Server
- Comment SQL Server TSQL Code
- Getting started with source control for SQL Server
- Lessons learned from SQL Server process that took over 3000 hours to complete
- SQL Server Best Practices for Index Column Order, Money Data Type and DBA Learning Resources
- SQL Server Development Best Practices Webcast - Q&A - Part 1
- T-SQL and PowerShell Documentation With Gists
- Using Source Control with SQL Server Management Studio
Indexing
Planning
- Requesting and researching SQL Server enhancements with Connect
- SQL Server Disasters with Preventive Measures
Professional Development
- Best practices for taking on the SQL Server DBA role as a developer
- SQL Server Worst Practices
- You might be a DBA
Security
TempDB
Tools
- SQL Server Comparison Tools
- SQL Server Health and History Tool
- Using the Microsoft SQL Server 2005 Best Practices Analyzer
- Using the Microsoft SQL Server 2008 R2 Best Practice Analyzer
Troubleshooting
