|
|
1 - 10d. Diagnose blocking, live locking and deadlocking - theory.mp4
|
MP4
|
29.1 MB
|
|
|
1 - 11a, 11c. Collect trace data by using SQL Server Profiler.mp4
|
MP4
|
27.2 MB
|
|
|
1 - 12a. implement a security strategy for auditing; 12c. configure server audits.mp4
|
MP4
|
39.3 MB
|
|
|
1 - 17c. Create login accounts.mp4
|
MP4
|
20.2 MB
|
|
|
1 - 1l. Choose the right hardware; 1a. Evaluate Installation Requirements.mp4
|
MP4
|
18 MB
|
|
|
1 - 3a. Restore versus detach attach.mp4
|
MP4
|
14.2 MB
|
|
|
1 - 4b. Configure full-text indexing.mp4
|
MP4
|
32.4 MB
|
|
|
1 - 5a. Create, maintain and monitor jobs.mp4
|
MP4
|
28.3 MB
|
|
|
1 - 6b, 7a. Database configuration autoclose, autoshrink, recovery models.mp4
|
MP4
|
48.7 MB
|
|
|
1 - 6e. Page and Row Data Compression.mp4
|
MP4
|
36.5 MB
|
|
|
1 - 9a. Install an instance; 7b. Install Default and named instances.mp4
|
MP4
|
21.2 MB
|
|
|
1 - Congratulations.mp4
|
MP4
|
7.7 MB
|
|
|
1 - Introduction.mp4
|
MP4
|
29.7 MB
|
|
|
1 - Restoring a Database.mp4
|
MP4
|
46.7 MB
|
|
|
1 - Transfer data.mp4
|
MP4
|
42.9 MB
|
|
|
1 - What are indexes.mp4
|
MP4
|
55.1 MB
|
|
|
10 - 13c and 13f. Perform backup restore based on strategies inc. backup redundancy.mp4
|
MP4
|
48.6 MB
|
|
|
10 - 6i. DBCC.mp4
|
MP4
|
16.2 MB
|
|
|
10 - Downloading AdventureWorks.mp4
|
MP4
|
13.2 MB
|
|
|
10 - Practice Activity Number 2.html
|
HTML
|
1.2 KB
|
|
|
11 - 13d and 14b. Recover from a corrupted drive.mp4
|
MP4
|
34.1 MB
|
|
|
11 - 6d, 19d. Implement and configure contained databases and logins.mp4
|
MP4
|
37.2 MB
|
|
|
12 - Practice Activity Number 1.html
|
HTML
|
1.2 KB
|
|
|
12 - Practice Activity Number 5.html
|
HTML
|
614.4 B
|
|
|
2 - 10d. Diagnose deadlocking - practice; 10h. kill processes.mp4
|
MP4
|
24.3 MB
|
|
|
2 - 11i. Use XEvents (Extended Events).mp4
|
MP4
|
20.3 MB
|
|
|
2 - 12e. Monitor elevated privileges as well as unsolicited attempts to connect.mp4
|
MP4
|
34 MB
|
|
|
2 - 15d. Implement indexes.mp4
|
MP4
|
26.7 MB
|
|
|
2 - 17d. Manage access to the server, 17b. secure the SQL server using server roles.mp4
|
MP4
|
31.6 MB
|
|
|
2 - 1b, 2b, 2c, 4a, 4b. Design the installation of SQL Server and its components.mp4
|
MP4
|
49.4 MB
|
|
|
2 - 1c. Plan Scale-up vs Scale-out basics.mp4
|
MP4
|
12.3 MB
|
|
|
2 - 3b. Migrate Security.mp4
|
MP4
|
13.6 MB
|
|
|
2 - 4c. SSIS Security.mp4
|
MP4
|
15 MB
|
|
|
2 - 5b. Administer jobs and alerts.mp4
|
MP4
|
11.5 MB
|
|
|
2 - 6a. Design multiple file groups.mp4
|
MP4
|
22.9 MB
|
|
|
2 - 6e. Sparse columns.mp4
|
MP4
|
20 MB
|
|
|
2 - Bonus Lecture.mp4
|
MP4
|
12.4 MB
|
|
|
2 - Bulk Insert.mp4
|
MP4
|
13.5 MB
|
|
|
2 - Looking around SSMS and how to generate T-SQL.mp4
|
MP4
|
40.8 MB
|
|
|
2 - Welcome to Udemy.html
|
HTML
|
921.6 B
|
|
|
3 - 10c. Monitor via DMV or other MS product; 10e. diagnose waits.mp4
|
MP4
|
27.1 MB
|
|
|
3 - 11b, 11f, 11g, 11h. Collect performance data by using System Monitor.mp4
|
MP4
|
32.5 MB
|
|
|
3 - 12b. Configure an audit; 12d. Track who modified an object.mp4
|
MP4
|
31.8 MB
|
|
|
3 - 15k. Columnstore Indexes.mp4
|
MP4
|
48.2 MB
|
|
|
3 - 17e. Create and maintain user-defined server roles.mp4
|
MP4
|
25.6 MB
|
|
|
3 - 1d. Plan for capacity; 1i. Windows-Level and Service Level Security.mp4
|
MP4
|
15.6 MB
|
|
|
3 - 3c. Migrate from a previous version; 3d. Migrate to new hardware.mp4
|
MP4
|
9 MB
|
|
|
3 - 4a. Set up and configure all SQL Server components, including Visual Studio SSDT.mp4
|
MP4
|
66.5 MB
|
|
|
3 - 4d. Filestream.mp4
|
MP4
|
34.7 MB
|
|
|
3 - 6a. Creating database with multiple file groups.mp4
|
MP4
|
21.9 MB
|
|
|
3 - Backing up Database, and problem with Restoring.mp4
|
MP4
|
41 MB
|
|
|
3 - Fragmentation - theory.mp4
|
MP4
|
47.8 MB
|
|
|
3 - RAISERROR and Create Event Alerts.mp4
|
MP4
|
18.7 MB
|
|
|
3 - The Udemy Interface.mp4
|
MP4
|
9.8 MB
|
|
|
4 - 10a. Examine deadlocking issues using the SQL server logs using trace flags.mp4
|
MP4
|
53.6 MB
|
|
|
4 - 11l. Identify IO v memory v CPU bottlenecks.mp4
|
MP4
|
8.7 MB
|
|
|
4 - 19c. Create Database User Accounts.mp4
|
MP4
|
20.8 MB
|
|
|
4 - 1f. Design the storage for new databases.mp4
|
MP4
|
17.3 MB
|
|
|
4 - 2a. Test connectivity.mp4
|
MP4
|
10.1 MB
|
|
|
4 - 3e. Migrate systems and data from other sources.mp4
|
MP4
|
7.8 MB
|
|
|
4 - 4e. Filetable.mp4
|
MP4
|
31.4 MB
|
|
|
4 - 6c. Manage file space, including adding new filegroups and moving objects.mp4
|
MP4
|
66 MB
|
|
|
4 - Changing Recovery Model.mp4
|
MP4
|
16 MB
|
|
|
4 - Do you want auto-translated subtitles in more languages.html
|
HTML
|
2.2 KB
|
|
|
4 - Fragmentation, reorganize and rebuild in SSMS.mp4
|
MP4
|
44.3 MB
|
|
|
4 - Practice Activity Number 6.html
|
HTML
|
409.6 B
|
|
|
4 - Practice Activity Number 8.html
|
HTML
|
716.8 B
|
|
|
4 - What happens when a job runs And running a RAISERROR WITH LOG.mp4
|
MP4
|
13.8 MB
|
|
|
5 - 10g. Know What Affects Performance.mp4
|
MP4
|
24.5 MB
|
|
|
5 - 13a. Different backup models - theory.mp4
|
MP4
|
42.8 MB
|
|
|
5 - 18b. Fixed Database-Level Roles.mp4
|
MP4
|
27.1 MB
|
|
|
5 - 2d. Configure an OS disk.mp4
|
MP4
|
18.5 MB
|
|
|
5 - 5b. Adding operators to jobs and alerts.mp4
|
MP4
|
31.9 MB
|
|
|
5 - 6g. Partitioning in theory.mp4
|
MP4
|
23.7 MB
|
|
|
5 - Curriculum.mp4
|
MP4
|
54.5 MB
|
|
|
5 - Fill factor.mp4
|
MP4
|
21.9 MB
|
|
|
5 - Practice Activity Number 7.html
|
HTML
|
819.2 B
|
|
|
6 - 11j. Create alerts on critical server condition.mp4
|
MP4
|
9.4 MB
|
|
|
6 - 13a. Different backup models - practice in SSMS.mp4
|
MP4
|
35.6 MB
|
|
|
6 - 15g. Optimise indexes (full, filter index).mp4
|
MP4
|
15.6 MB
|
|
|
6 - Databases - Resources.html
|
HTML
|
307.2 B
|
|
|
6 - Partitioning in practice using the GUI.mp4
|
MP4
|
49.6 MB
|
|
|
6 - Practice Activity 9.html
|
HTML
|
204.8 B
|
|
|
6 - User Database-Level Roles.mp4
|
MP4
|
48.3 MB
|
|
|
7 - 13a and 14c. Point in Time Recovery.mp4
|
MP4
|
52 MB
|
|
|
7 - 15c. Identify unused indexes.mp4
|
MP4
|
22 MB
|
|
|
7 - Creating and Using Schemas.mp4
|
MP4
|
25.2 MB
|
|
|
7 - Downloading SQL Server Developer E9.mp4
|
MP4
|
34.8 MB
|
|
|
7 - Partitioning in practice using T-SQL, and testing partitioning.mp4
|
MP4
|
33.3 MB
|
|
|
7 - Practice Activity Number 4.html
|
HTML
|
921.6 B
|
|
|
8 - 13e. Manage a multi-TB database; 14d. File group restore.mp4
|
MP4
|
28.4 MB
|
|
|
8 - 15h. Statistics (full, filter) force or fix queue.mp4
|
MP4
|
20.6 MB
|
|
|
8 - Creating access to server database with least privilege.mp4
|
MP4
|
28 MB
|
|
|
8 - Installing SQL Server Developer E9.mp4
|
MP4
|
22.1 MB
|
|
|
8 - Using NORECOVERY and RECOVERY.mp4
|
MP4
|
56.1 MB
|
|
|
9 - 13g and 13h. Back up an SQL Server environment and system databases.mp4
|
MP4
|
27.5 MB
|
|
|
9 - 18c. Protect objects from being modified.mp4
|
MP4
|
8.9 MB
|
|
|
9 - 6h. Manage log file growth.mp4
|
MP4
|
25.6 MB
|
|
|
9 - Installing SQL Server Management Studio (SSMS).mp4
|
MP4
|
12.1 MB
|
|
|
9 - Practice Activity Number 3.html
|
HTML
|
512 B
|
|
|
AdventureWorks2014.bak
|
BAK
|
44.6 MB
|
|
|
Bonus Resources.txt
|
TXT
|
307.2 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
