• Lesson.No : 03
  • 00:16:31

  • 2 Introduction to SQL Server 2014 Database Administration

  • Play

Course Lessons

  1. 1- 0 Course Layout
  2. 2- 1 SQL Server Service
  3. 3- 2 Introduction to SQL Server 2014 Database Administration
  4. 4- 3 SQL Server 2014 Administration Tools
  5. 5- 4 How Data Is Stored in SQL Server
  6. 6- 5 Creating and Managing Filegroups In SQL Server
  7. 7- 6 Database Options in SQL Server
  8. 8- 7 System Database in SQL Server
  9. 9- 8 Genrate Script Button in SQL Server
  10. 10- 9 Copy Or Move database options in SQL Server
  11. 11- 10 Shrink database in SQL Server
  12. 12- 11 Understanding SQL Server Recovery Models
  13. 13- 12 Demo for log file behavior in the Full recovery model
  14. 14- 13 Backup Types
  15. 15- 14 Planning Backup Strategies
  16. 16- 15 Demo Full Bacup
  17. 17- 16 Demo Full to multiple backup sets to decrease backup time
  18. 18- 17 backup Database Options in SQL Server
  19. 19- 18 Restore differential Backup in SQL Server
  20. 20- 19 Restore Transaction Log Backup in SQL Server
  21. 21- 20 Restore at Point in SQL Server
  22. 22- 21 Clear Transaction Log in SQL Server
  23. 23- 22 Restore without data lose Tail Log
  24. 24- 23 Introduction to SQL Server Security
  25. 25- 24 Create logins in SQL Server
  26. 26- 25 Managing Server Level Roles
  27. 27- 26 Managing Database Users
  28. 28- 28 Managing Database Users and Roles
  29. 29- 30 Managing Application Roles
  30. 30- 31Ownership Chains
  31. 31- 32 Introduction to Transferring Data in SQL Server
  32. 32- 33 Import and Export Wizard in SQL Server
  33. 33- 34 SQL Server Integration Services Demo
  34. 34- 35 Disable constraints to Inhance Bulk Insert
  35. 35- 36 Demo for bcp Bulk Copy Program
  36. 36- 37 Bulk Insert Demo
  37. 37- 38 Open RowSet Demo
  38. 38- 39 Activity Monitor Demo for Concurncey Problems Lock Deadlock Block
  39. 39- 27 Managing dbo and guest Access
  40. 40- 29 How to Add dbowner User for your application in SQL Server
  41. 41- 40 Querying Dynamic Management Views
  42. 42- 41 Introduction for SQL Server Agent
  43. 43- 42 Operator in SQL Server Agent
  44. 44- 43 Jobs in SQL Server Agent
  45. 45- 44 View Jobs History in SQL Server Agent
  46. 46- 45 Save Jobs as Script File
  47. 47- 46 Job Step Security Contexts Proxy
  48. 48- 47 Configuring Multi Server Jobs
  49. 49- 48 Alert in SQL Server
  50. 50- 49 1 Performance Condition Alert
  51. 51- 49 2 Performance Condition Alert
  52. 52- 50 Alert History
  53. 53- 51 Use the DBCC CHECKDB command
  54. 54- 52 Maintaining Indexes Introduction
  55. 55- 53 Maintaining Indexes Demo
  56. 56- 54 SQL Server Maintenance Plans Wizard
  57. 57- 55 SQL Server Profile Demo
  58. 58- 56 Database Engine Tuning Advisor Demo
  59. 59- 57 Configure Database Mail in SQL Server Demo
  60. 60- 58 SQL Server Auditing Data Server and DB
  61. 61- 59 Buffer Pool Extension in SQL Server New Feature
  62. 62- 60 What and Why Use Replication in SQL Server
  63. 63- 61 Types of Replication in SQL ServerP1
  64. 64- 62 How to Install SQL Server Production Enviroment
  65. 65- 63 Implementing Replication Step1 Create a Publication Snapshot
  66. 66- 63 Implementing Replication Step2 Create a Subscription Snapshot
  67. 67- 64 Implementing Replication Transactional Pub
  68. 68- 65 Monitor replication
  69. 69- 66 How to Restore Master Database
  70. 70- 67 Move the existing tempdb files to the new location in SQL Server
  71. 71- 70 High Availability in SQL Server