SQL Server Optimum Environment

Title: SQL Server Optimum Environment
Subtitle: Set up the best environment for your database
Description: Databases are essential in the business world, we all have databases that are critical to the organization. When it comes to storing and querying data, SQL Server is the top choice for many businesses and data professionals. It’s used for a range of projects--from Enterprise Resource Planning (ERP) to mini Human Resources (HR) solution systems. In this hands-on course, you will learn step-by-step how to prepare an optimum environment for SQL Server. The course will review best practices for SQL Server configuration, PowerShell basics, advanced hardware resource planning, performance tuning techniques, high availability and disaster recovery designs, and the importance of documentation.
What you'll learn — and how you can apply it
By the end of this live, hands-on, online event, you’ll understand:
● SQL Server Configuration Best Practices.
● Basics of PowerShell to monitor SQL Server and Windows.
● Advance Hardware Resource Planning for SQL Server.
● Technique of Performance Tuning with Minimal Effort.
● Basics of High Availability and Disaster Recovery Designs.
● Importance of Documentation.
And you’ll be able to:
● Prepare a host server for SQL Server.
● Perform best practices on Windows and SQL Server configuration.
● Monitor and alert SQL Server and Windows Activities.
● Tune Problematic Workloads and Queries.
● Implement High Availability and Disaster Recovery (HADR) best practice designs.
● Document SQL Server environment.
This event is for you because...
● You are an accidental SQL Server DBA.
● You work with problematic SQL Server databases.
● You need to deploy a new set of SQL Server environments.
● You are interested in providing an optimum environment for SQL Server.
● You want to become an SQL Server DBA with deep technical knowledge.
Prerequisites
What prior knowledge or experience is necessary?
● Basic knowledge of T-SQL and PowerShell scripting.
● Basic Knowledge of Windows Server 2012 or later versions.
● Some familiarity with SQL Server administrative tasks such as backup, restore, and configuration.
● Some familiarity with SQL Server Management Studio.