SQL Server 2022 Administration

SQL Server 2022 Management: Essential Skills for IT Professionals

This course provides practical, hands-on training in SQL Server 2022 management, designed for IT professionals, data analysts, and anyone responsible for maintaining SQL Server databases. We'll cover the configurations, methods, and best practices applicable to over 85% of SQL Server installations, enabling you to build more resilient and efficient systems.

Led by Mike Bennyhoff, an experienced SQL Server administration professional with a proven track record of assisting over 75 clients including HP and Rolls-Royce, this course focuses on practical application and efficient problem-solving. You'll gain the skills to optimize performance without getting bogged down in extensive database theory.

Course Outline:

• Introduction to SQL Server: Understand the fundamentals of SQL Server and its role in modern data management.

• Setup & Connectivity:

  • SQL Server Setup: Learn the process of installing and configuring SQL Server.
  • VMware: Setting up SQL Server on VMware environments.
  • Connecting To SQL Server: Methods for connecting to your SQL Server instance.
  • SQL Server Connection Manager: Utilizing the Connection Manager for streamlined connections.
  • Sample DB's: Working with sample databases for practice.

• The Absolute Essentials: Master core management tasks.

  • Backups: Explore different backup types, understand SQL recovery modes, and learn how to verify backup consistency.
  • Indexes: Learn about various index types, index maintenance strategies, and how to optimize index plans for performance.
  • Statistics: Understand the importance of statistics and how to maintain them for query optimization.
  • RAM: Configure and monitor RAM settings in SQL Server for optimal performance.
  • Settings & User Administration:
    • Parallelism: Configure parallelism settings, including the cost threshold and max degree of parallelism.
    • User Administration: Create and manage users (SA, DBO), disable accounts, and control user roles.
    • SQL Mail & SQL Alerts:
      • Database Mail: Set up and configure Database Mail for email notifications.
      • Operators: Configure operators to manage email notifications.
      • Database Alerts: Create alerts for specific error numbers and test their functionality.

• Jobs & Activity Monitor: Automate tasks and monitor performance.

  • Jobs: Automate tasks using SQL Server Agent jobs, including scheduling and monitoring.
  • Activity Monitor: Utilize Activity Monitor to track server performance, identify bottlenecks, and kill blocked processes.
  • Performance Dashboard: Learn how to open and view the Performance Dashboard to gain insights into server health. Understand current waits, disk, and CPU utilization.

• SQL Server Licensing:

  • SQL Server Licensing: Understand different SQL Server licensing options.
  • SQL Server Licensing + Costs: Learn about the costs associated with SQL Server licensing.
  • SQL Server on VMware & AWS (Amazon Web Services): Deploying and licensing SQL Server in cloud environments.

This course will equip you with the knowledge and skills to effectively manage SQL Server environments, ensuring optimal performance, reliability, and security.