Title: Operational Foundation for the SQL Server DBA

Level: Beginner/100

Pre-requisites: None

Length: Full day pre-con

Abstract:

Without a solid foundation, a structure has little to no chance of standing strong when trouble strikes. Your career as a SQL Server Data Professional is no different. Understanding the building blocks of configuration, performance tuning and troubleshooting are critical to the performance and availability of your SQL Server databases. If you are a new, accidental, or junior SQL Server database administrator (DBA) the building blocks listed below will allow you to craft a customized set of actions, ready for your return to the office. Perhaps you are a sysadmin, developer (application, SQL, or BI) or even a manager, who has the desire to reach beyond your current knowledge of working with SQL Server. These same building blocks can help you do just that.

During this all-day pre-conference we cover the following building blocks, building our way to an operational sound knowledge of how to configure, tun and troubleshoot SQL Server:

• Foundations
• System Databases
• File Structure
• Datafiles
• Transaction logs
• SQL Agent
• Database Mail
• Restore and Backup
• Recovery Time Objective
• Recovery Point Objective
• Recovery Models
• Backup Types
• Install and Configure
• Installation, beyond NEXT NEXT NEXT
• Post-installation “best practices” configuration
• Maintenance
• Database Integrity
• Index Defragmentation
• Tools
• Monitoring and Troubleshooting
• Collecting and using Baselines
• Extended Events
• Error Logs
• Basic Performance Improvement
• Intro to indexing
• Reading execution plans