$125

SQL Saturday Pre-con: Operational Foundations for the DBA with Peter Shore

Event Information

Share this event

Date and Time

Location

Location

Microsoft

8900 Keystone Crossing #950

950

Indianapolis, IN 46240

View Map

Refund Policy

Refund Policy

Refunds up to 1 day before event

Event description

Description

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
Share with friends

Date and Time

Location

Microsoft

8900 Keystone Crossing #950

950

Indianapolis, IN 46240

View Map

Refund Policy

Refunds up to 1 day before event

Save This Event

Event Saved