~Get Your Files Here !

  1 - Introduction

   10 - Downloading AdventureWorks.mp4

   3 - The Udemy Interface.mp4

   5 - Curriculum.mp4

   7 - Downloading SQL Server Developer E9.mp4

   9 - Installing SQL Server Management Studio (SSMS).mp4

  10 - Collect and analyse troubleshooting data

   2 - 11i. Use XEvents (Extended Events).mp4

   4 - 11l. Identify IO v memory v CPU bottlenecks.mp4

  11 - Audit SQL Server Instances

   2 - 12e. Monitor elevated privileges as well as unsolicited attempts to connect.mp4

   4 - Practice Activity Number 8.html

  12 - Plan installation

   2 - 1c. Plan Scale-up vs Scale-out basics.mp4

   4 - 1f. Design the storage for new databases.mp4

  13 - Install SQL Server and related services

   2 - 1b, 2b, 2c, 4a, 4b. Design the installation of SQL Server and its components.mp4

   4 - 2a. Test connectivity.mp4

   6 - Practice Activity 9.html

  14 - Implement a migration strategy

   2 - 3b. Migrate Security.mp4

   4 - 3e. Migrate systems and data from other sources.mp4

  15 - Install SQL Server, related services and additional SQL Server components

   2 - 4c. SSIS Security.mp4

   4 - 4e. Filetable.mp4

  16 - Well done

   2 - Bonus Lecture.mp4

  2 - Backup and Restore - Part 1

   10 - 13c and 13f. Perform backup restore based on strategies inc. backup redundancy.mp4

   12 - Practice Activity Number 1.html

   3 - Backing up Database, and problem with Restoring.mp4

   5 - 13a. Different backup models - theory.mp4

   7 - 13a and 14c. Point in Time Recovery.mp4

   9 - 13g and 13h. Back up an SQL Server environment and system databases.mp4

  3 - Manage logins and server roles

   10 - Practice Activity Number 2.html

   3 - 17e. Create and maintain user-defined server roles.mp4

   5 - 18b. Fixed Database-Level Roles.mp4

   7 - Creating and Using Schemas.mp4

   9 - 18c. Protect objects from being modified.mp4

  4 - Implement and maintain indexes

   2 - 15d. Implement indexes.mp4

   4 - Fragmentation, reorganize and rebuild in SSMS.mp4

   6 - 15g. Optimise indexes (full, filter index).mp4

   8 - 15h. Statistics (full, filter) force or fix queue.mp4

  5 - Import and export data

   2 - Bulk Insert.mp4

  6 - Manage SQL Server Agent - Part 1

   2 - 5b. Administer jobs and alerts.mp4

   4 - What happens when a job runs And running a RAISERROR WITH LOG.mp4

   6 - 11j. Create alerts on critical server condition.mp4

  7 - Manage and configure databases

   10 - 6i. DBCC.mp4

   12 - Practice Activity Number 5.html

   3 - 6a. Creating database with multiple file groups.mp4

   5 - 6g. Partitioning in theory.mp4

   7 - Partitioning in practice using T-SQL, and testing partitioning.mp4

   9 - 6h. Manage log file growth.mp4

  8 - Compression

   2 - 6e. Sparse columns.mp4

   4 - Practice Activity Number 6.html

  9 - Identify and resolve concurrency problems

   2 - 10d. Diagnose deadlocking - practice; 10h. kill processes.mp4

   4 - 10a. Examine deadlocking issues using the SQL server logs using trace flags.mp4