2016
Udemy
09:18:33
English
SQL Administration Part 2 will benefit the student by providing the necessary guide lines for enhancing SQL Server performance by utilizing indexes, reviewing DMVs for analysis, and setting up performance counters for gathering resource metrics; and also I will explain a handful of utilities to gather information about SQL Server internals, such as SQL Profiler, Database Tuning Advisor (DTA), Extended Events, SQL performance monitor, Activity monitor, and teach about partitions, creating contained database for recovery, reviewing SQL server logs and by installing SQL Server 2014 as the newer SQL version.The student will not only add to the knowledge gained bur SQL Administration Part 1, but get prepared for the next course SQL Administration Part 3 – the high availability solutions.
├── 001 Introduction.mp4
├── 002 Install SQL Server 214.mp4
├── 003 Install SQL Suite.mp4
├── 004 Clustered Index.mp4
├── 005 Create non cluster index.mp4
├── 006 Composite Index.mp4
├── 007 Use or not use indexes.mp4
├── 008 Deciding factors in creating indexes.mp4
├── 009 using sql profler for indexes.mp4
├── 010 Reorganize and Rebuild Indexes.mp4
├── 011 Into To SQL Profiler.mp4
├── 012 SQL Profiler longest running query.mp4
├── 013 Audit logins.mp4
├── 014 SQL Profile with Index Tuning.mp4
├── 015 SQL Profiler Best Practice.mp4
├── 016 SQL Server Side Trace.mp4
├── 017 Database Engine Tuning Advisor.mp4
├── 018 Statistics.mp4
├── 019 Activity Monitor.mp4
├── 020 SQL Performance Monitor.mp4
├── 021 SQL Performance hardware issues.mp4
├── 022 SQL Performance Monitoring Hardware CPU.mp4
├── 023 SQL Performance Monitoring Hardware memory.mp4
├── 024 SQL Performance Monitoring Hardware disks.mp4
├── 025 23 SQL Perfmon scehdule.mp4
├── 026 DMV.mp4
├── 027 Block and Locks.mp4
├── 028 BLOCKING.mp4
├── 029 Deadlock.mp4
├── 030 Extended Events.mp4
├── 031 Extended Events via TSQL.mp4
├── 032 Database Snapshots.mp4
├── 033 Import Export Data.mp4
├── 034 BCP.mp4
├── 035 Partition.mp4
├── 036 Partition part 2.mp4
├── 037 Partition 3.mp4
├── 038 Contained datababase Part 1.mp4
├── 039 Contained datababase Part 2.mp4
├── 040 Policy Based Management.mp4
├── 041 Linked Servers.mp4
├── 042 SQL server and agent logs.mp4
└── 043 SQL ADMINISTRATION PART 3.mp4
Download File Size:2.35 GB
|
