
Popular Posts
-
Deploying SQL Server manually can be a lengthy and error prone process as need to go through all the different setup screens presented by th...
-
Inserting data from one SQL Server Database view or table to another SQL table To do so, please drag and drop the data flow task from the to...
-
Following are some commands to check the Location of MSSQL Files, Services, Ports, Error log in linux: Start, restart, stop services: To sta...
-
Memory (or simply RAM) is the memory or information storage in a computer that is used to store running programs and data for the programs....
-
Sr. No. SQL Best Practices Reason 1 Enabling Trace Flags Globally 1117 To Enable Data Files grow equally in case of Autogrow. 1118 To Reduce...
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