- Azure
- _Introduction of azure
- _Storage types of azure
- _Creating azure account
- _Creating database in azure portal
- _Migrating on-prem database to azure
- _Azure: Creating login and assigning permission
- _Export backpac file from on prem
- _Import bacpac file into azure from on premises
- Windows Server
- _Prerequisites of WinOS
- _Partitioning HD
- _Formatting HD
- _Windows file systems
- _Pagefile in windows
- _Overview of perfmon
- _Windows server 2019 installation
- _Shortcuts of WinOS
- _SQL crash dump analysis
- _Analyse windows crash dumps
- SQL on Linux
- _Creating bootable linux
- _ Prerequisites of SQL on Linux
- _ Installing linux OS
- _Online SQL Installation
- _Offline SQL Installation
- _ Location of SQL Files
- _ Different ways of connecting to SQL Server
- _Migration from on Premises windows to Linux
- T-SQL
- _TSQL: SQL languages
- _Constraints
- _Identity column
- _Keys
- _Normalization
- _Aggregate functions
- _Joins
- SQL: Installations
- _Introduction of SQL Server
- _Prerequisites for SQL Server
- _SQL Server Comparisons
- _SQL Server Installation Types
- _Graphical Installation
- _Command Line Installation
- _Installation via ConfigFile
- _Slipstream Installation
- _SQL Server Client Installation
- _SQL Service Pack Installation
- _SQL Server Configuration Manager
- _Querying using SQLCMD
- SQL: Configurations
- _Best Practices for SQL Server
- _Authentication modes of SQL Server
- _System Databases
- _System database movement
- _Contained Database
- _Architecture of SQL Server
- _DAC Connection in SQL Server
- _Recovery Models
- _Permissions:Maintaining Users
- _Permissions:Maintain Roles
- _Permissions:Object Permissions
- _Error log in SQL Server
- _sp_configure parameters
- _Steps before uninstalling SQL Server Service Packs
- _Steps before uninstalling SQL Server
- SQL: bkp,restore & monitoring
- _Database Backup Options
- _Types Of Backup
- _Recovery phases
- _Restore Options
- _Restore File & Filegroup
- _Page Restore
- _Point In Time Restore
- _Piecemeal Restore
- _Configure Backup Automation
- _DBCC
- _DBCC Shrinking Databases
- _Resolving Corruption using DBCC
- _DBCC Reading Log File
- _Link Server Introduction
- _Link Server:SQL to SQL
- _LinkServer: SQL to Oracle
- _Deadlock Introduction
- _Deadlock Graph
- _Exporting Data
- _Daily Monitoring TSQL Queries
- _Database Migration
- _Upgrade SQL Server
- High Availability
- _*****LogShipping*****
- _Prerequisites of Logshipping
- _Configuring LogShipping
- _DR Drill
- _Clearing Old Log Shipping History
- _*****DatabaseMirroring*****
- _Mirroring Prerequisites
- _Configure Database Mirroring
- _Mirroring T-SQL Scripts
- _***SQL Replication***
- _Prerequisites & types
- _Setting Up Transactional Replication
- _Adding new articles to existing Transactional Replication
- _***SQL Server cluster***
- _Prerequisites
- _Hardware & Software Requiremnet
- _AD & IP Requirements
- _Quorum configuration
- _Installing SQL Server Failover Cluster Instance
- _Adding a node to the cluster
- _Removing a Node From a Cluster
- _**Always On***
- _Prerequisites for Installing SQL Server AlwaysOn
- SSIS
- _SSIS Introduction
- _ssis from one view table to another
- _ssis package schedule
- SQL performance tuning
- _Areas of Performance Tuning
- _Wait type:CXPACKET & CXCONSUMER
- _Perfmon: CPU Counters & Thresholds
- _Perfmon: Memory Counters & Thresholds
- _Identifying Disk IO issues using SQL
- _Perfmon: Analyzing DISK IO issue
- _Analyzing Memory Pressure Using SQL Server
- _Duplicate indexes observations
- About Me