SQL Server Administration Part 2 (Size: 2.41 GB)
| | | 018 Statistics.mp4 | 50.98 MB |
| | | 032 Database Snapshots.mp4 | 61.37 MB |
| | | 041 Linked Servers.mp4 | 28.78 MB |
| | | 013 Audit logins.mp4 | 55.58 MB |
| | | 012 SQL Profiler longest running query.mp4 | 49.3 MB |
| | | 002 Install SQL Server 214.mp4 | 72.21 MB |
| | | 035 Partition.mp4 | 84.67 MB |
| | | 010 Reorganize and Rebuild Indexes.mp4 | 71.22 MB |
| | | 025 23 SQL Perfmon scehdule.mp4 | 29.8 MB |
| | | 026 DMV.mp4 | 72.12 MB |
| | | 016 SQL Server Side Trace.mp4 | 84.78 MB |
| | | 021 SQL Performance hardware issues.mp4 | 60.3 MB |
| | | 019 Activity Monitor.mp4 | 59.14 MB |
| | | 014 SQL Profile with Index Tuning.mp4 | 50.25 MB |
| | | 004 Clustered Index.mp4 | 87.2 MB |
| | | 008 Deciding factors in creating indexes.mp4 | 95.63 MB |
| | | 009 using sql profler for indexes.mp4 | 77.97 MB |
| | | 038 Contained datababase Part 1.mp4 | 57.18 MB |
| | | 022 SQL Performance Monitoring Hardware CPU.mp4 | 71.05 MB |
| | | 017 Database Engine Tuning Advisor.mp4 | 44.6 MB |
| | | 027 Block and Locks.mp4 | 56.8 MB |
| | | 015 SQL Profiler Best Practice.mp4 | 13.3 MB |
| | | 011 Into To SQL Profiler.mp4 | 69.33 MB |
| | | 043 SQL ADMINISTRATION PART 3.mp4 | 18.4 MB |
| | | 031 Extended Events via TSQL.mp4 | 59.68 MB |
| | | 037 Partition 3.mp4 | 65.53 MB |
| | | 006 Composite Index.mp4 | 98.88 MB |
| | | 023 SQL Performance Monitoring Hardware memory.mp4 | 42.91 MB |
| | | 039 Contained datababase Part 2.mp4 | 48.16 MB |
| | | 033 Import Export Data.mp4 | 52.8 MB |
Description
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.
Related Torrents
| torrent name |
size |
seed |
leech |
|
|
71.36 MB |
20 |
3 |
|
|
33.67 MB |
14 |
7 |
|
|
14.77 MB |
1 |
0 |
|
|
577.98 MB |
1 |
0 |
|
|
2.35 GB |
1 |
0 |
Sharing Widget