
Popular Posts
-
Following are the steps for adding articles to existing Transactional Replication without initializing old entries : Adding articles to exi...
-
Authentication modes to connect to SQL Server Authentication mode of a SQL Server instance decides how the SQL Server authenticates the user...
-
The information on deadlock in this blog is get from my final year of engineering book, Database System Concepts - 7th edition by Henry F....
-
Contained database: Contained Databases is a new feature which was initially introduced in SQL Server 2012. A contained database is a data...
-
What is DR Drill? DR Drill is an activity which involves actions which are taken to overcome data loss after disaster for example if prim...
Popular Tags
Azure
(8)
Backup Database
(3)
Clustering
(7)
Crash Dumps
(2)
DBCC
(4)
Deadlock
(2)
Link Server
(3)
Log Shipping
(4)
Maintenance
(1)
Migration
(3)
Mirroring
(3)
Monitoring
(1)
Performance Tuning
(11)
Permissions
(3)
Post Installations
(5)
Prerequisites
(1)
Replication
(3)
Restore Database
(6)
SQL Installations
(7)
SQL on Linux
(8)
SQL Uninstallations
(2)
SSIS
(4)
T-SQL
(7)
Windows Server
(7)
- 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