SQL Server Tools and Installation
  • SQL Server Tools and InstallationMy First Lecture
  • SQL Server 2012 Components and Their Uses
  • Planning SQL Server Installation
  • Installing SQL Server 2012
  • Demo - Installing SQL Server 2012
  • Demo - Exploring the Installed Components
  • Quiz
  • Conclusion
Managing the Database Server
  • Managing the Database Server
  • Server Properties and sp configure
  • Demo - Viewing Server Properties and Using sp configure
  • Advanced Options
  • Demo - Enabling Advanced Options, and Viewing and Modifying Them
  • CPU and Memory Architectures
  • Demo - Working with CPU Affinity and Memory Configurations
  • Configuring Database Mail
  • Demo - Set up Database Mail
  • Quiz
  • Conclusion
Managing Databases
  • Managing Databases
  • Types of Databases
  • Demo - Creating User and Contained Databases
  • System Databases
  • Database Options
  • Demo-Looking at Auto Close and Auto Shrink and Checking Disk Space of a Database
  • Demo - Moving between File Groups
  • Recovery Models
  • Changing_Recovery_Model_Demo_04
  • Quiz
  • Conclusion
SQL Server Security
  • SQL Server Security
  • Security Model and Types of Accounts in SQL Server
  • Demo - Using Accounts in SQL Server
  • Server Roles
  • Demo - Managing Server Roles
  • Managing Permissions
  • Demo - Using GRANT and DENY
  • Database Roles and Permissions
  • Demo - Using Database Roles
  • Quiz
  • Conclusion
Advanced Security in SQL Server
  • Advanced Security in SQL Server
  • Working with Digital Certificates
  • Private and Public Keys
  • Certificate Based Logins
  • Demo - Creating Certificate Based Logins
  • Auditing and Policies
  • Demo - Creating and Viewing Audits
  • Policy Based Management
  • Demo - Setting up Policy Based Management
  • Encryption and Compression
  • Demo - Using TDE and Compression
  • Quiz
  • Conclusion
Working with Indexes and Files
  • Working with Indexes and Files
  • Understanding Indexes
  • Adding_an_Index_to_a_Table_Demo
  • Introduction to Full Text Indexing
  • Setting_up_FTI_and_Querying_Using_FTS_Demo
  • Column Store Index
  • Using_a_Column_Store_Index_Demo
  • Setting_up_New_iFilters_for_FTI_Demo
  • Setting_up_a_New_FILETABLE_Demo_05
  • Quiz
  • Conclusion
Maintaining Reliability of SQL Server Installations
  • Maintaining Reliability of SQL Server Installations
  • Detaching and Attaching Databases
  • Detach and Attach a Database_Demo
  • Database Backup and Restoration
  • Backup_Restore_and_Scheduling_of_Backup_Demo
  • High Availability
  • Set_up_an_SQL_Server_Cluster_Demo
  • Quiz
  • Conclusion
Optimizing Servers
  • Optimizing Servers
  • Benchmarking Server Performance
  • Using_Resource_Governor_and_PerfMon_Demo
  • DMVs and SQL Profiler
  • Using_DMVs_Demo_02
  • Using_SQL_Profiler_Demo_03
  • Optimizing Indexes
  • View_Index_Statistics_Demo_04
  • View_and_Rebuild_Index_to_Reduce_Fragmentation_Demo_05
  • Quiz
  • Conclusion
Troubleshooting Errors in SQL Server
  • Troubleshooting Errors in SQL Server
  • SQL Server Errors and Handling Issues
  • Using_DBCC_Demo_01
  • Traces
  • Using_Trace_Flags_Demo_02
  • Extended Events