[ CourseBoat.com ] Udemy - 70-462 - SQL Server Database Administration (DBA)

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

No comments yet.