SQL Server 2019 : Administration SQL Server Part 2

Master SQL Server Performance: Indexing & Database Configuration

Unlock the power of SQL Server with this comprehensive course, combining two of my most popular courses on Udemy! Learn to optimize your database for peak performance and gain essential SQL administration skills.

Part 1: SQL Server Indexing – Boost Performance & Avoid Over-Indexing

Is your SQL Server running slow? Discover the critical role of indexes in accelerating query execution. This chapter demystifies indexes, covering:

• Clustered vs. Non-Clustered Indexes: Understand the fundamental differences and when to use each.
• Table SCAN vs. Table SEEK: Learn how indexes enable faster data retrieval.
• Covering Indexes: Optimize query performance by including all necessary data in the index.
• Avoiding Over-Indexing: Prevent performance degradation by understanding when not to index the entire table.
• Index Maintenance: Remove duplicate indexes, understand single indexes, and the importance of index consolidation and Columnstore Indexes.
• Filtered Indexes: Utilize filtered indexes and their impact on the cache plan.
• SARGable Queries: Learn what it means for queries to be "SARGable" and how to write them.
• Choosing the Right Clustered Index: Make informed decisions for optimal data organization.
• Index Fragmentation: Understand why fragmentation occurs and how to effectively remove it.
• FILLFACTOR & Page Splits: Manage storage efficiently with these key parameters.
• Index Rebuild vs. Reorganize: Choose the right maintenance strategy for your database.
• ABORT_AFTER_WAIT: Understand this option and its implications.

This in-depth exploration will empower you to significantly improve SQL Server performance without unnecessary disk storage costs.

Part 2: SQL Server Database Configuration & Modification

Go beyond basic SQL and learn how to fine-tune your SQL Server environment for optimal operation. This section covers:

• Autogrow Optimization: Learn how to configure autogrow to prevent performance bottlenecks.
• Database Creation Options: Discover a wide range of options available when creating a new database.
• Parallelism (MAXDOP): Control query parallelism for improved resource utilization.
• Database Management: Learn to create, configure, and modify databases (including attaching files).
• Query Store: Utilize the Query Store for performance analysis and troubleshooting.
• Broker Service: Understand and activate the Broker service for asynchronous messaging.
• Database Ownership: Learn the impact of changing database ownership.
• TARGET RECOVERY Time: Understand and manage recovery time objectives.

This 2.5-hour course is designed for Tech Leads, developers, aspiring DBAs, and anyone working with SQL Server who wants to take their skills to the next level. With concise, under 10-minute video lessons, you'll quickly grasp essential concepts and avoid common pitfalls. Join over 4,000 satisfied students who have rated my courses 4.4/5!