در بخش اول آموزش تصویری مقیاس‌گذاری SQL Server 2012 و در بخش دوم SQL Server 2014 ، ایجاد، مدیریت و سازماندهی پایگاههای داده به منظور بهبود عملکرد اس‌کیواِل سِـروِر در راستای کنترل تراکم اطلاعات مربوطه در بستر مباحث متنوع و کاربُردی تدریس شده است. این دوره‌ی آموزشی برای هر کسی که مسئولیت یا فعالیتی در باب بهبود کارایی و سازماندهی‌های مربوط به حجم کار اس‌کیواِل سِـروِر دارد مناسب است.
محتوای آموزش:
1- مبحث Top Scalability Issues با اس‌کیواِل سِـروِر 2012
2- رفع مشکلات مربوط به تراکم اطلاعات و حجم پایگاههای داده
3- اقدامات مهم برای مقیاس‌گذاری
4- معماری و طراحی برنامه‌های کاربردی
5- معماری و طراحی پایگاه‌داده
6- استراتژی فهرست‌سازی و تعمیر و نگهداری
تولید کننده: Pluralsight
تاریخ انتشار: 27-03-2014
سطح: متوسط
مدت زمان آموزش: 3 ساعت و 54 دقیقه
مدرس: Glenn Berry
فهرست کامل سرفصل‌ها و عناوین آموزش (به همراه زمان دقیق آنها) Part 1:
Introduction - 00:23:31
Introduction - 03:14
Top Scalability Issues with SQL Server 2012 - 02:35
Postponing the Scaling Decision - 03:47
Application Architecture and Design Issues - 04:38
Database Architecture and Design Issues - 03:10
Indexing Strategy and Maintenance - 03:35
Summary - 01:33
Course Structure - 00:55
Top Scalability Issues with SQL Server 2012 - 00:10:35
Introduction - 02:29
Largest SQL Server Implementations and Your Nightmare - 02:04
Top Scalability Issues with SQL Server 2012 - 01:44
Handling Scalability Issues - 02:04
Summary - 01:19
What is Next? - 00:52
Postponing the Scaling Decision - 00:52:46
Introduction - 01:37
Postponing the Scaling Decision - 00:43
Preventing Scalability Problems - 01:36
Finding Your Bottlenecks and Improving Them - 02:18
Demo: Sample 911 Emergency Script Part 1 - 10:52
Demo: Sample 911 Emergency Script Part 2 - 14:38
Using Diagnostic Tools to Find Bottlenecks - 03:45
Common Performance Bottlenecks - 02:27
Working with Consultants - 01:18
Working with Developers - 01:30
Demo: The Bad Man Queries - 05:49
Working with Stakeholders - 01:58
Summary and Return on Investment - 02:46
What is Next? - 01:21
Application Architecture and Design - 00:43:53
Introduction - 02:13
Application Architecture and Design Issues - 02:08
Application Refactoring - 02:28
Overuse of ORM Code Generators - 01:24
Using Ad Hoc T-SQL from the Application - 01:46
Overuse of XML Data - 01:31
SQL Server Scalar User-Defined Functions - 01:47
Demo: T-SQL Scalar UDFs - 06:12
Too Much Business Logic in the Database - 01:22
Using DML Triggers for Application Logic - 01:28
Using CLR Assemblies for Application Logic - 01:44
Requesting Too Much Data from the Database 02:04
User-Controlled, Long-Running Transactions - 01:19
Overuse of New SQL Server Features - 01:52
Doing Row-by-Agonizing-Row Processing - 02:07
Demo: Set-Based vs. RBAR Processing - 03:10
Not Having a Data Archiving Strategy - 01:32
Not Having a Reporting Strategy - 01:58
Not Using Middle-Tier Caching - 02:10
Common Middle-Tier Caching Tools - 01:22
Summary - 01:22
What is Next? - 00:44
Database Architecture and Design - 00:54:18
Introduction - 01:48
Database Architecture and Design Issues - 00:59
Using Default Database Properties - 04:28
Demo: Creating a New Database - 06:38
Data File Physical Layout - 02:31
Transaction Log File Physical Layout - 02:54
Transaction Log File Configuration - 02:57
Poor Database Normalization - 01:31
Lack of Check Constraints - 01:32
Lack of Foreign Keys - 01:22
Heap Tables - 01:23
Inappropriate Data Types - 01:50
Wide Data Types - 01:59
Poor Query Design (1) - 02:04
Demo: Implicit Conversions - 05:18
Poor Query Design (2) - 02:25
SQL Server is a Database Server! - 03:21
Not Using T-SQL Stored Procedures - 02:56
Overuse of ORM Query Generators - 01:47
Additional ORM Query Considerations - 01:38
Summary - 01:33
What is Next? - 01:15
Indexing Strategy and Maintenance - 00:49:53
Introduction - 01:24
Common Indexing Issues - 01:27
Too Many Indexes - 02:23
Demo: Finding Unused Indexes - 01:47
Having High Impact Missing Indexes - 02:59
Demo: Finding Missing Indexes - 06:11
Finding Missing Index Warnings - 01:11
Missing Index Warning Example - 00:37
Demo: Finding Missing Index Warnings - 02:25
Database Tuning Advisor Issues - 01:15
Demo: Using the DTA Command-Line Utility - 03:40
Having Poorly-Maintained Indexes - 01:20
Improper Index Maintenance - 01:54
Using the SQL Maintenance Plan Wizard - 01:50
Common XML Index Issues - 01:37
Common Spatial Index Issues - 01:36
Not Using Data Compression - 01:49
Data Compression Considerations - 01:44
Demo: Data Compression - 09:52
Not Using Columnstore Indexes - 01:18
Course Summary - 01:24
فهرست کامل سرفصل‌ها و عناوین آموزش Part 1:
Introduction
Introduction
What This Course Covers
Course Structure
Database Configuration Settings
Introduction
Statistics-related Database Properties
Recovery Model and Compatibility Level
Undesirable Database Properties
Miscellaneous Settings to Consider
Demo - Checking Database Properties
Database Filegroup Considerations
Database File Layout Considerations.mp4
Database File Size and Growth Settings
Demo - Finding Files That Have Percent Growth
Demo - Changing Database Properties with T-SQL
Module Summary
Instance Configuration Settings
Introduction
Operating System Issues
Negotiated Versions of SMB
Lock Pages in Memory (LPIM)
Perform Volume Maintenance Tasks
Demo - Granting OS Rights to SQL Server
Windows Page File Size
Global Trace Flags
Tempdb Configuration Settings
Instance-level Configuration Settings
Demo - Changing Instance-level Configuration Settings with T-SQL
Best Practices for Performance and Scalability
Module Summary
Storage Subsystem Issues
Introduction
Common Storage Subsystem Issues
Common SQL Server Workload Types and I-O Access Patterns
Demo - I-O Related DMV Queries
Common DMV I-O Query Result Patterns
Sizing Your Storage Subsystem
Choosing Storage Types and Subsystem Design Tips
CrystalDiskMark 5.1 and Microsoft DiskSpd
Demo - CrystalDiskMark 5.1
Demo - Microsoft DiskSpd
Module Summary
Hardware Issues
Introduction
Common Hardware Issues
Key BIOS Settings
PCIe Throughput Limits
Power Management
BIOS Power Management and Using CPU-Z
Demo - Using CPU-Z
Demo - Windows Power Plan Setting
Processor Selection for SQL Server
Intel Tick-tock Release Strategy
Intel Processor Family Tree
Preferred Haswell-EP and Haswell-EX Processors
Module Summary
Scaling up SQL Server
Introduction
Windows Server and SQL Server License Limits
Diminishing Returns of Scaling Up
Planning a Hardware Migration
Resist Temptation to Upgrade-in-place
Smoothly Migrating to New Hardware
Database Mirroring vs. Log Shipping
Module Summary
Scaling Out SQL Server
Introduction
SQL Server 24 Availability Groups
Transactional Replication
Peer-to-peer Replication
Distributed Partitioned Views
Service-oriented Database Architecture (SODA)
Data Dependent Routing (DDR)
Scale Out Realities to Remember
Module Summary
New Scalability Features in SQL Server 24
Introduction
Buffer Pool Extensions
Demo - Buffer Pool Extensions
Resource Governor Enhancements
Demo - Resource Governor Enhancements
Clustered Columnstore Indexes
Demo - Clustered Columnstore Indexes
Delayed Durability
Demo - Delayed Durability
New Cardinality Estimator
Demo - New Cardinality Estimator
Module Summary
Where to Go Next and Course Summary
Exercise Files
نکات:
1- این آموزش به زبان انگلیسی است.
2- آموزش به صورت فیلمهای جداگانه برای هر فصل است.
3- فرمت فایلها MP4 است.
4- فایل های دانلودی قابلیت تعمیر با WinRAR در صورت دانلود ناقص را دارا می باشند.