Skip to content
  • Home
  • About
  • Blog
  • Contact
  • Oracle
  • SQL Server
  • MongoDB
  • Home
  • About
  • Blog
  • Contact
  • Oracle
  • SQL Server
  • MongoDB
SQL Server - DBA - 1
SQL Server - DBA - 2
SQL Server - DBA - 3
SQL Server - DBA - 1
 
      • Introduction to System Databases
      • SQL Server Data and Log Files
      • Configuring Auto Growth and sizing of transaction log
      • What is virtual log file (VLF)
      • Create a SQL database
      • The importance of Tempdb
      • Attach and detach a database
      • Introduction to SQL Server Backups
      • Full Database Backup
      • Transaction Log Backups
      • Differential Backups
      • Backup strategy for various scenarios
      • Introduction to SQL Server Database Restore
      • Restore database with GUI
      • Restore database using differential
      • Recovery state in restores
      • Recovery mode with tail log backup
      • Backup using Maintenance plan
      • Backup Admin database using Maintenance plan
      • Maintenance Plan Tasks
      • Shrinking a database
      • The importance of using SQL Server Agent
      • Multi Server Administration
      • The importance of DBCC CheckDB
      • Setting up SQL Database Mail
      • Error Message Severity Levels
      • Login in SQL Server
      • Managing security with T SQL
      • Selecting Authentication or Mixed Mode security
      • Accessing SQL Server using SQL Login
      • Understanding SQL Server Roles
      • Managing SQL Server Permissions
      • Best Practice to Secure the SQL Server
      • SQL Server Security Scripts
SQL Server - DBA - 2

 

    • What is a Clustered Index
    • When to Use or Not use Indexes
    • Reorganize and Rebuild Indexes
    • SQL Profiler Best Practice
    • SQL Server Side Trace
    • SQL Server Database Engine Tuning Advisor
    • SQL Server Statistics
    • Activity Monitor in SQL Server
    • SQL Server Performance Monitor
    • SQL Server Optimization
    • Dynamic Management Views (DMVs)
    • SQL Server Locks, Blocking, and Deadlocks
    • SQL Server Extended Events
    • Extended Event via T-SQL
    • SQL Server Database Snapshots
    • SQL Server Import and Export
    • SQL Server Bulk Copy Program (BCP)
    • SQL Server Partitioning
    • SQL Server Contained databases
    • SQL Server Policy-Based Management (PBM)
    • SQL Server Linked Servers
    • SQL Server logs and SQL Agent logs
SQL Server - DBA - 3

 

    • Configure Domain Controller and Active Directory for SQL Server
      SQL Server Installation For HA
      SQL Server Log Shipping
      Log shipping Manual Failover
      Solving problems of orphaned users when moving a Database from Source to Destination
      Monitoring Log Shipping
      Database Mirroring
      SQL Server Database Mirroring Monitoring
      SQL Server Replication Step by Step
      SQL Server AlwaysOn
      SQL Server Backup Database on Secondary Replicas
      Implementing Backup on Secondary Replicas (AlwaysOn Availability Groups)
Top 50 SQL Blog
  • SQL Server In-Memory OLTP Overview -2
  • SQL Server In-Memory OLTP Overview – 1
  • SQL Server Cardinality Estimation
  • SQL Server Automatic tuning
  • SQL Server Statistics
  • SQL Server Resource Governor
  • Upgrading Databases using Query Tuning Assistant
  • Using SQL Server Management Studio
  • Partitioned Tables and Indexes
  • SQL Server Execution Plans
  • Database Engine Tuning Advisor
  • Intelligent query processing in SQL databases
  • Top Reasons for Slow Performance
  • SQL Server 2019 Performance Tuning
  • Security features of SQL Server on Linux
  • High availability for SQL Server containers
  • Troubleshoot SQL Server on Linux
  • SQL Server Replication on Linux
  • Performance best practices for SQL Server on Linux
  • Upgrade Availability Groups on Linux
  • Always On Availability Group on Linux
  • Availability Group Configurations
  • Always On Availability Groups on Linux
  • Failover Cluster Instances – SQL Server on Linux
  • SQL Server on Linux VDI client SDK Specification
  • Twitter
  • Facebook
  • Instagram
  • Pinterest
  • RSS
© 2020 iSqlPlus - All Rights Reserved.