Search this site
Skip to main content
Skip to navigation
SQLServerFaiz
About
AWS-POSTGRES AURORA Best Practices
Migration DB2 (LUW) - RDS -DB2
WAL PostgreSQL considerations
Oracle-Scripts
Vector Database & Comparison with open-source vector databases.
AWS managed disaster recovery and managed reader RDS Oracle cross-Region
Software Security Methodologies and tools
AWS Architecture
Cloud services cheat sheet for AWS, Azure and Google Cloud
PostgreSQL vs. SQL Server Detailed Comparison
Oracle-queries
AWS- Partitioning Overview RDS Oracle & Oracle
AWS- Storage for your instance
AWS Security- Principles
AWS-POSTGRESQL-QUERIES
Always On Availability
AlwaysOn Availability- log shipping Solution
AlwaysOn Availability-Solution Error: 1408
Untitled page
Amazon DataBase & Migration
Amazon DataBase & Migration-1
Amazon DataBase - Architecture
AWS - Read replicas, Multi-AZ deployments, and multi-region deployments
AWS -RDS Security Best Practices
Amazon DocumentDB (with MongoDB Compatibility)
AWS - CI/CD (Jenkins)
AWS - ElastiCache for Redis
AWS - OWASP Security Knowledge
AWS - RDS - Database Migration Service
AWS - Redshift
AWS-Redshift Performance Tuning
AWS-Redshift Best practices
AWS-Redshift Maintenance Tables
AWS-Redshift Spectrum
AWS - Static & Dynamic Website & Deploy an Application
AWS - VPC- Create a Web Server and an Amazon RDS Database
AWS -Amazon API Gateway Private Endpoints
AWS -Amazon Kinesis
AWS - Kinesis
Kinesis Firehose
Kinesis Streams
AWS -Amazon Route 53
AWS -EC2 (Amazon Elastic Compute Cloud)
AWS- Auto Scaling EC2-RDS
AWS-Documentation
AWS -RDS -Amazon Relational Database Service
AWS -Amazon RDS for PostgreSQL
AWS -VPC & Security Group
AWS-RDS ORACLE
AWS-RDS ORACLE-monitor the jobs
AWS- Oracle Database to Amazon Redshift
AWS -RDS limitations for Microsoft SQL Server DB Instances
AWS -RDS-Issue
AWS -Best practices for migrating an Oracle database to Amazon RDS PostgreSQL
AWS -WORKSHOP
AWS EMR Amazon
AWS Glue
AWS Glue
AWS Storage
AWS S3 VS EBS STORAGE
AWS Resilient Architecture
Best Practices for Data Protection in the Cloud
AWS Monitoring and Auditing Resources
AWS Load Balancing Service Architecture
AWS-DMS TASK ISSUE,SOLUTION
AWS-Security, Identity, & Compliance services
AWS-Troubleshooting migration
Backup and Restore Related Query
SQL Server Transaction Log Architecture and Management
BIG DATA
BIG DATA - Hadoop
BIG DATA - Hadoop
BIG DATA - Hive
DataNode
Hadoop Cluster
Namenode
What is SPOF (single point of failure in Hadoop)
BIG DATA - HBase
BIG DATA-Architecture
BIG DATA-kafka
Kafka-Case study
Case Study
Cannot find one or more components. Please reinstall application for SSMS
Code that return the recent warning type record in application log
CPU -----SQL SERVER
AWS VPC Architecture
Customer facing skills to represent within the customer’s environment
Project Management-Leadership task
Data Warehouse
Building Modern Data Analytics Architectures
Data Management
Data Warehouse -Data Modelling
Data Lake -Delta Lake
Database log and transaction log for database 'tempdb' is full log_reuse_wait_desc
DataBase Restore Via TDP in SQL Server
Databases & Analytics on AWS
Databases -Types SQL vs NoSQL Database Differences
Databases Related Issue and Solutions
DB Mirroring step by step & troubleshooting
Deadlock Job Configuration
Disaster Recovery in SQL Server
Disaster Recovery Plan (DRP) for [PRODUCT]
Filling up the transactional log of TEMPDB database.
Get computers ping status, IP, OS version, sp version, uptime and last boot gui
Hadoop
How to configure SQL Server to use more than 2 GB of physical memory:
How to find a database's last used date in SQL Server
How to Move Resource Database
How to Script permissions using catalog views in SQL Server 2005
IaaS PaaS SaaS Cloud Computing Models
Internet Information Server (IIS)
ITIL Best Practices
Job Role and Responsible
Kubernetes - Docker Swarm
Kubernetes
Kubernetes Architecture
Linux/Unix Command
Linux - Grep, Awk and Sed
Grep, Awk and Sed
Unix/Linux Command Reference
Unix/Linux Command
Log Shipping -Mirror -Replication Monitor Queries
Log Shipping
Logon failed for login due to trigger execution.Changed database context to 'master'.Changed language setting to us_english. (Microsoft SQL Server, Error: 17892)
Mark Logic- Upgrade Guidelines
Upgrade Guidelines
Migration Ms SQL Server to PostgresSql
Aurora PostgreSql-Command
Miscellaneous Issues
Ms sql server architecture
MS SQL-Database Backup Types and Methodology
MYSQL COMMANDS
MYSQL SERVER
MySQL Replication-Cluster Solutions
Feature Comparison of MySQL HA Solutions
Master Replication Down -Slave replication make Mater
MySQL Replication-Master-Master Replication
MySQL-Connecting Application to the Replication Setup
MySQL-Recover Crashed innodb tables
MySQL-Backup & Restore
MySQL-Configuration File Locations
Configuration File Locations
MySQL- Performance Tuning Settings
Performance Tuning Settings
Operating System & System Memory Topics
ORACLE
Oracle - ASM (Automatic Storage Management)
Oracle - Performance Tuning
Oracle DBA Interview Questions and Answers
Oracle- Performance Tuning
ORACLE-Backup Strategy
Oracle-Data Archive Process
Partitioning-Oracle
Local and Global Index-Oracle
Partitioning
Reading Execution Plans: Oracle
Reading Execution Plans:
ORACLE -RAC (Real Application Clusters )
Performance Monitoring & Optimization Steps
Performance Monitor- Perfmon
Performance Monitor- Perfmon Counters & Details
SQL Server Wait Type Repository
SQL Server Wait -Queries
Performance Monitor- Wait types
Performance Profile of OLTP applications
Performance_Tuning_Waits_Queues ---2005
Permissions (Database Engine)
PL-SQL Query
PostgreSQL® Notes for Professionals
AWS -Aurora PostgreSQL Queries & Failover
PostgreSQL® Notes for Professionals
AWS-ORACLE-RDS MIGRATION
PostgresSQL
PostgreSQL- Issues & Solution
PostgresSQL-Admin
Postgresql-Vacuum Function
Query -Database Size in GB
Raid Level & Isolation Levels in the Sql Server 2008 R2
Rebuild MSDB Database
Relational Database Management System (RDBMS)
Script to export the configuration of SQL Server
SCRIPTS :Job History Cleanup script
Server and Database Transition Information
Showplan Logical and Physical Operators Reference
SQL -Estimate the Size of a Database
SQL -HA & DR Solutions
SQL -UPDATE STATISTICS
SQL Cluster Related Question and Answer
SQL Cluster
SQL Cluster
SQL Job History information script
SQL LOGIN AND OTHER SCRIPTS
SQL SERVER - Top 10 security considerations for your SQL Server
Server and Database Roles
SQL SERVER -DBCC
SQL Server -Installation 2008,2012 R2 on Windows 2008,2012 Standalone and Cluster
SQL SERVER -Max. Worker Threads
SQL SERVER -Moving the Report Server Databases to Another Computer
SQL SERVER -Pages
SQL SERVER 2014. Benefits of upgrading from SQL Server 2005, 2008, 2008R2 and 2012
SQL SERVER 2017 NEW FEATURES
SQL SERVER 2016 -17 NEW FEATURES
SQL SERVER :Query Performance Tuning
SQL SERVER Components
SQL Server Database Migration Checklist
SQL SERVER REPORTING SERVICE MIGRATION
SQL Server DMV/DMFs
SQL Server Performance Counters - Memory Queries
Script to Monitor SQL Server Memory Usage
SQL Server Performance Counters -CPU
SQL Server Performance Counters -Memory
Key Performance Counters and their thresholds for Windows Server
SQL DB 2008 Engine Page Life Expectancy is too low
SQL Server Memory and Troubleshooting
SQL SERVER Performance counters to capture to analyze Memory pressure
SQL SERVER PERFORMANCE TUNNING
SQL Server Ports
SQL Server Query Optimizer
SQL SERVER SERVICE PACK VERSION
sql server updgration
SQL SERVER – Blocking, Deadlocks and troubleshooting
SQL SERVER – Blocking, Deadlocks Queries
SQL SERVER – DMV – sys.dm_os_wait_stats
SQL SERVER – Index
SQL SERVER – Index Seek & Scan
Index Issue
AWS Modern security standards for Networking and Infrastructure
SNOWFLAKE DATA LOADING
AWS -Right Size For Database Instance types
SQL SERVER – ReadErrorLog
SQL SERVER – SSIS
SQL SERVER – SSIS Error & Issues
SQL SERVER –Index,Filtered index ,Fill Factor & Indexes Defragmentation
Online Index Operations Work
SQL SERVER –Replication
SQL SERVER – Transactiona Replication
SQL SERVER –Replication Issues
SQL SERVER –Replication Q &A
SQL Server, Buffer Manager Object
SQL Server- Issue & Solution
SQL Server: Monitor jobs
SQL Trace_event Sequence
SQL-Performance recommendations
SQL-Server-Level Roles
SSRS
TempDb and recommendations
Trace Flags (Transact-SQL)
solating a Long-Running Query with SQL Profiler
Understanding Set Statistics IO output
Using a Dedicated Administrator Connection
Validating database objects after migration using AWS SCT and AWS DMS
Windows PC and servers installation and support
Desktop Support Interview Questions and Answers
ACTIVE DIRECTORY & DOMAIN
windows-server-administration-interview-questions
Windows policy Lock Pages in Memory option and SQL Server instance in VM
SQLServerFaiz
About
AWS-POSTGRES AURORA Best Practices
Migration DB2 (LUW) - RDS -DB2
WAL PostgreSQL considerations
Oracle-Scripts
Vector Database & Comparison with open-source vector databases.
AWS managed disaster recovery and managed reader RDS Oracle cross-Region
Software Security Methodologies and tools
AWS Architecture
Cloud services cheat sheet for AWS, Azure and Google Cloud
PostgreSQL vs. SQL Server Detailed Comparison
Oracle-queries
AWS- Partitioning Overview RDS Oracle & Oracle
AWS- Storage for your instance
AWS Security- Principles
AWS-POSTGRESQL-QUERIES
Always On Availability
AlwaysOn Availability- log shipping Solution
AlwaysOn Availability-Solution Error: 1408
Untitled page
Amazon DataBase & Migration
Amazon DataBase & Migration-1
Amazon DataBase - Architecture
AWS - Read replicas, Multi-AZ deployments, and multi-region deployments
AWS -RDS Security Best Practices
Amazon DocumentDB (with MongoDB Compatibility)
AWS - CI/CD (Jenkins)
AWS - ElastiCache for Redis
AWS - OWASP Security Knowledge
AWS - RDS - Database Migration Service
AWS - Redshift
AWS-Redshift Performance Tuning
AWS-Redshift Best practices
AWS-Redshift Maintenance Tables
AWS-Redshift Spectrum
AWS - Static & Dynamic Website & Deploy an Application
AWS - VPC- Create a Web Server and an Amazon RDS Database
AWS -Amazon API Gateway Private Endpoints
AWS -Amazon Kinesis
AWS - Kinesis
Kinesis Firehose
Kinesis Streams
AWS -Amazon Route 53
AWS -EC2 (Amazon Elastic Compute Cloud)
AWS- Auto Scaling EC2-RDS
AWS-Documentation
AWS -RDS -Amazon Relational Database Service
AWS -Amazon RDS for PostgreSQL
AWS -VPC & Security Group
AWS-RDS ORACLE
AWS-RDS ORACLE-monitor the jobs
AWS- Oracle Database to Amazon Redshift
AWS -RDS limitations for Microsoft SQL Server DB Instances
AWS -RDS-Issue
AWS -Best practices for migrating an Oracle database to Amazon RDS PostgreSQL
AWS -WORKSHOP
AWS EMR Amazon
AWS Glue
AWS Glue
AWS Storage
AWS S3 VS EBS STORAGE
AWS Resilient Architecture
Best Practices for Data Protection in the Cloud
AWS Monitoring and Auditing Resources
AWS Load Balancing Service Architecture
AWS-DMS TASK ISSUE,SOLUTION
AWS-Security, Identity, & Compliance services
AWS-Troubleshooting migration
Backup and Restore Related Query
SQL Server Transaction Log Architecture and Management
BIG DATA
BIG DATA - Hadoop
BIG DATA - Hadoop
BIG DATA - Hive
DataNode
Hadoop Cluster
Namenode
What is SPOF (single point of failure in Hadoop)
BIG DATA - HBase
BIG DATA-Architecture
BIG DATA-kafka
Kafka-Case study
Case Study
Cannot find one or more components. Please reinstall application for SSMS
Code that return the recent warning type record in application log
CPU -----SQL SERVER
AWS VPC Architecture
Customer facing skills to represent within the customer’s environment
Project Management-Leadership task
Data Warehouse
Building Modern Data Analytics Architectures
Data Management
Data Warehouse -Data Modelling
Data Lake -Delta Lake
Database log and transaction log for database 'tempdb' is full log_reuse_wait_desc
DataBase Restore Via TDP in SQL Server
Databases & Analytics on AWS
Databases -Types SQL vs NoSQL Database Differences
Databases Related Issue and Solutions
DB Mirroring step by step & troubleshooting
Deadlock Job Configuration
Disaster Recovery in SQL Server
Disaster Recovery Plan (DRP) for [PRODUCT]
Filling up the transactional log of TEMPDB database.
Get computers ping status, IP, OS version, sp version, uptime and last boot gui
Hadoop
How to configure SQL Server to use more than 2 GB of physical memory:
How to find a database's last used date in SQL Server
How to Move Resource Database
How to Script permissions using catalog views in SQL Server 2005
IaaS PaaS SaaS Cloud Computing Models
Internet Information Server (IIS)
ITIL Best Practices
Job Role and Responsible
Kubernetes - Docker Swarm
Kubernetes
Kubernetes Architecture
Linux/Unix Command
Linux - Grep, Awk and Sed
Grep, Awk and Sed
Unix/Linux Command Reference
Unix/Linux Command
Log Shipping -Mirror -Replication Monitor Queries
Log Shipping
Logon failed for login due to trigger execution.Changed database context to 'master'.Changed language setting to us_english. (Microsoft SQL Server, Error: 17892)
Mark Logic- Upgrade Guidelines
Upgrade Guidelines
Migration Ms SQL Server to PostgresSql
Aurora PostgreSql-Command
Miscellaneous Issues
Ms sql server architecture
MS SQL-Database Backup Types and Methodology
MYSQL COMMANDS
MYSQL SERVER
MySQL Replication-Cluster Solutions
Feature Comparison of MySQL HA Solutions
Master Replication Down -Slave replication make Mater
MySQL Replication-Master-Master Replication
MySQL-Connecting Application to the Replication Setup
MySQL-Recover Crashed innodb tables
MySQL-Backup & Restore
MySQL-Configuration File Locations
Configuration File Locations
MySQL- Performance Tuning Settings
Performance Tuning Settings
Operating System & System Memory Topics
ORACLE
Oracle - ASM (Automatic Storage Management)
Oracle - Performance Tuning
Oracle DBA Interview Questions and Answers
Oracle- Performance Tuning
ORACLE-Backup Strategy
Oracle-Data Archive Process
Partitioning-Oracle
Local and Global Index-Oracle
Partitioning
Reading Execution Plans: Oracle
Reading Execution Plans:
ORACLE -RAC (Real Application Clusters )
Performance Monitoring & Optimization Steps
Performance Monitor- Perfmon
Performance Monitor- Perfmon Counters & Details
SQL Server Wait Type Repository
SQL Server Wait -Queries
Performance Monitor- Wait types
Performance Profile of OLTP applications
Performance_Tuning_Waits_Queues ---2005
Permissions (Database Engine)
PL-SQL Query
PostgreSQL® Notes for Professionals
AWS -Aurora PostgreSQL Queries & Failover
PostgreSQL® Notes for Professionals
AWS-ORACLE-RDS MIGRATION
PostgresSQL
PostgreSQL- Issues & Solution
PostgresSQL-Admin
Postgresql-Vacuum Function
Query -Database Size in GB
Raid Level & Isolation Levels in the Sql Server 2008 R2
Rebuild MSDB Database
Relational Database Management System (RDBMS)
Script to export the configuration of SQL Server
SCRIPTS :Job History Cleanup script
Server and Database Transition Information
Showplan Logical and Physical Operators Reference
SQL -Estimate the Size of a Database
SQL -HA & DR Solutions
SQL -UPDATE STATISTICS
SQL Cluster Related Question and Answer
SQL Cluster
SQL Cluster
SQL Job History information script
SQL LOGIN AND OTHER SCRIPTS
SQL SERVER - Top 10 security considerations for your SQL Server
Server and Database Roles
SQL SERVER -DBCC
SQL Server -Installation 2008,2012 R2 on Windows 2008,2012 Standalone and Cluster
SQL SERVER -Max. Worker Threads
SQL SERVER -Moving the Report Server Databases to Another Computer
SQL SERVER -Pages
SQL SERVER 2014. Benefits of upgrading from SQL Server 2005, 2008, 2008R2 and 2012
SQL SERVER 2017 NEW FEATURES
SQL SERVER 2016 -17 NEW FEATURES
SQL SERVER :Query Performance Tuning
SQL SERVER Components
SQL Server Database Migration Checklist
SQL SERVER REPORTING SERVICE MIGRATION
SQL Server DMV/DMFs
SQL Server Performance Counters - Memory Queries
Script to Monitor SQL Server Memory Usage
SQL Server Performance Counters -CPU
SQL Server Performance Counters -Memory
Key Performance Counters and their thresholds for Windows Server
SQL DB 2008 Engine Page Life Expectancy is too low
SQL Server Memory and Troubleshooting
SQL SERVER Performance counters to capture to analyze Memory pressure
SQL SERVER PERFORMANCE TUNNING
SQL Server Ports
SQL Server Query Optimizer
SQL SERVER SERVICE PACK VERSION
sql server updgration
SQL SERVER – Blocking, Deadlocks and troubleshooting
SQL SERVER – Blocking, Deadlocks Queries
SQL SERVER – DMV – sys.dm_os_wait_stats
SQL SERVER – Index
SQL SERVER – Index Seek & Scan
Index Issue
AWS Modern security standards for Networking and Infrastructure
SNOWFLAKE DATA LOADING
AWS -Right Size For Database Instance types
SQL SERVER – ReadErrorLog
SQL SERVER – SSIS
SQL SERVER – SSIS Error & Issues
SQL SERVER –Index,Filtered index ,Fill Factor & Indexes Defragmentation
Online Index Operations Work
SQL SERVER –Replication
SQL SERVER – Transactiona Replication
SQL SERVER –Replication Issues
SQL SERVER –Replication Q &A
SQL Server, Buffer Manager Object
SQL Server- Issue & Solution
SQL Server: Monitor jobs
SQL Trace_event Sequence
SQL-Performance recommendations
SQL-Server-Level Roles
SSRS
TempDb and recommendations
Trace Flags (Transact-SQL)
solating a Long-Running Query with SQL Profiler
Understanding Set Statistics IO output
Using a Dedicated Administrator Connection
Validating database objects after migration using AWS SCT and AWS DMS
Windows PC and servers installation and support
Desktop Support Interview Questions and Answers
ACTIVE DIRECTORY & DOMAIN
windows-server-administration-interview-questions
Windows policy Lock Pages in Memory option and SQL Server instance in VM
More
About
AWS-POSTGRES AURORA Best Practices
Migration DB2 (LUW) - RDS -DB2
WAL PostgreSQL considerations
Oracle-Scripts
Vector Database & Comparison with open-source vector databases.
AWS managed disaster recovery and managed reader RDS Oracle cross-Region
Software Security Methodologies and tools
AWS Architecture
Cloud services cheat sheet for AWS, Azure and Google Cloud
PostgreSQL vs. SQL Server Detailed Comparison
Oracle-queries
AWS- Partitioning Overview RDS Oracle & Oracle
AWS- Storage for your instance
AWS Security- Principles
AWS-POSTGRESQL-QUERIES
Always On Availability
AlwaysOn Availability- log shipping Solution
AlwaysOn Availability-Solution Error: 1408
Untitled page
Amazon DataBase & Migration
Amazon DataBase & Migration-1
Amazon DataBase - Architecture
AWS - Read replicas, Multi-AZ deployments, and multi-region deployments
AWS -RDS Security Best Practices
Amazon DocumentDB (with MongoDB Compatibility)
AWS - CI/CD (Jenkins)
AWS - ElastiCache for Redis
AWS - OWASP Security Knowledge
AWS - RDS - Database Migration Service
AWS - Redshift
AWS-Redshift Performance Tuning
AWS-Redshift Best practices
AWS-Redshift Maintenance Tables
AWS-Redshift Spectrum
AWS - Static & Dynamic Website & Deploy an Application
AWS - VPC- Create a Web Server and an Amazon RDS Database
AWS -Amazon API Gateway Private Endpoints
AWS -Amazon Kinesis
AWS - Kinesis
Kinesis Firehose
Kinesis Streams
AWS -Amazon Route 53
AWS -EC2 (Amazon Elastic Compute Cloud)
AWS- Auto Scaling EC2-RDS
AWS-Documentation
AWS -RDS -Amazon Relational Database Service
AWS -Amazon RDS for PostgreSQL
AWS -VPC & Security Group
AWS-RDS ORACLE
AWS-RDS ORACLE-monitor the jobs
AWS- Oracle Database to Amazon Redshift
AWS -RDS limitations for Microsoft SQL Server DB Instances
AWS -RDS-Issue
AWS -Best practices for migrating an Oracle database to Amazon RDS PostgreSQL
AWS -WORKSHOP
AWS EMR Amazon
AWS Glue
AWS Glue
AWS Storage
AWS S3 VS EBS STORAGE
AWS Resilient Architecture
Best Practices for Data Protection in the Cloud
AWS Monitoring and Auditing Resources
AWS Load Balancing Service Architecture
AWS-DMS TASK ISSUE,SOLUTION
AWS-Security, Identity, & Compliance services
AWS-Troubleshooting migration
Backup and Restore Related Query
SQL Server Transaction Log Architecture and Management
BIG DATA
BIG DATA - Hadoop
BIG DATA - Hadoop
BIG DATA - Hive
DataNode
Hadoop Cluster
Namenode
What is SPOF (single point of failure in Hadoop)
BIG DATA - HBase
BIG DATA-Architecture
BIG DATA-kafka
Kafka-Case study
Case Study
Cannot find one or more components. Please reinstall application for SSMS
Code that return the recent warning type record in application log
CPU -----SQL SERVER
AWS VPC Architecture
Customer facing skills to represent within the customer’s environment
Project Management-Leadership task
Data Warehouse
Building Modern Data Analytics Architectures
Data Management
Data Warehouse -Data Modelling
Data Lake -Delta Lake
Database log and transaction log for database 'tempdb' is full log_reuse_wait_desc
DataBase Restore Via TDP in SQL Server
Databases & Analytics on AWS
Databases -Types SQL vs NoSQL Database Differences
Databases Related Issue and Solutions
DB Mirroring step by step & troubleshooting
Deadlock Job Configuration
Disaster Recovery in SQL Server
Disaster Recovery Plan (DRP) for [PRODUCT]
Filling up the transactional log of TEMPDB database.
Get computers ping status, IP, OS version, sp version, uptime and last boot gui
Hadoop
How to configure SQL Server to use more than 2 GB of physical memory:
How to find a database's last used date in SQL Server
How to Move Resource Database
How to Script permissions using catalog views in SQL Server 2005
IaaS PaaS SaaS Cloud Computing Models
Internet Information Server (IIS)
ITIL Best Practices
Job Role and Responsible
Kubernetes - Docker Swarm
Kubernetes
Kubernetes Architecture
Linux/Unix Command
Linux - Grep, Awk and Sed
Grep, Awk and Sed
Unix/Linux Command Reference
Unix/Linux Command
Log Shipping -Mirror -Replication Monitor Queries
Log Shipping
Logon failed for login due to trigger execution.Changed database context to 'master'.Changed language setting to us_english. (Microsoft SQL Server, Error: 17892)
Mark Logic- Upgrade Guidelines
Upgrade Guidelines
Migration Ms SQL Server to PostgresSql
Aurora PostgreSql-Command
Miscellaneous Issues
Ms sql server architecture
MS SQL-Database Backup Types and Methodology
MYSQL COMMANDS
MYSQL SERVER
MySQL Replication-Cluster Solutions
Feature Comparison of MySQL HA Solutions
Master Replication Down -Slave replication make Mater
MySQL Replication-Master-Master Replication
MySQL-Connecting Application to the Replication Setup
MySQL-Recover Crashed innodb tables
MySQL-Backup & Restore
MySQL-Configuration File Locations
Configuration File Locations
MySQL- Performance Tuning Settings
Performance Tuning Settings
Operating System & System Memory Topics
ORACLE
Oracle - ASM (Automatic Storage Management)
Oracle - Performance Tuning
Oracle DBA Interview Questions and Answers
Oracle- Performance Tuning
ORACLE-Backup Strategy
Oracle-Data Archive Process
Partitioning-Oracle
Local and Global Index-Oracle
Partitioning
Reading Execution Plans: Oracle
Reading Execution Plans:
ORACLE -RAC (Real Application Clusters )
Performance Monitoring & Optimization Steps
Performance Monitor- Perfmon
Performance Monitor- Perfmon Counters & Details
SQL Server Wait Type Repository
SQL Server Wait -Queries
Performance Monitor- Wait types
Performance Profile of OLTP applications
Performance_Tuning_Waits_Queues ---2005
Permissions (Database Engine)
PL-SQL Query
PostgreSQL® Notes for Professionals
AWS -Aurora PostgreSQL Queries & Failover
PostgreSQL® Notes for Professionals
AWS-ORACLE-RDS MIGRATION
PostgresSQL
PostgreSQL- Issues & Solution
PostgresSQL-Admin
Postgresql-Vacuum Function
Query -Database Size in GB
Raid Level & Isolation Levels in the Sql Server 2008 R2
Rebuild MSDB Database
Relational Database Management System (RDBMS)
Script to export the configuration of SQL Server
SCRIPTS :Job History Cleanup script
Server and Database Transition Information
Showplan Logical and Physical Operators Reference
SQL -Estimate the Size of a Database
SQL -HA & DR Solutions
SQL -UPDATE STATISTICS
SQL Cluster Related Question and Answer
SQL Cluster
SQL Cluster
SQL Job History information script
SQL LOGIN AND OTHER SCRIPTS
SQL SERVER - Top 10 security considerations for your SQL Server
Server and Database Roles
SQL SERVER -DBCC
SQL Server -Installation 2008,2012 R2 on Windows 2008,2012 Standalone and Cluster
SQL SERVER -Max. Worker Threads
SQL SERVER -Moving the Report Server Databases to Another Computer
SQL SERVER -Pages
SQL SERVER 2014. Benefits of upgrading from SQL Server 2005, 2008, 2008R2 and 2012
SQL SERVER 2017 NEW FEATURES
SQL SERVER 2016 -17 NEW FEATURES
SQL SERVER :Query Performance Tuning
SQL SERVER Components
SQL Server Database Migration Checklist
SQL SERVER REPORTING SERVICE MIGRATION
SQL Server DMV/DMFs
SQL Server Performance Counters - Memory Queries
Script to Monitor SQL Server Memory Usage
SQL Server Performance Counters -CPU
SQL Server Performance Counters -Memory
Key Performance Counters and their thresholds for Windows Server
SQL DB 2008 Engine Page Life Expectancy is too low
SQL Server Memory and Troubleshooting
SQL SERVER Performance counters to capture to analyze Memory pressure
SQL SERVER PERFORMANCE TUNNING
SQL Server Ports
SQL Server Query Optimizer
SQL SERVER SERVICE PACK VERSION
sql server updgration
SQL SERVER – Blocking, Deadlocks and troubleshooting
SQL SERVER – Blocking, Deadlocks Queries
SQL SERVER – DMV – sys.dm_os_wait_stats
SQL SERVER – Index
SQL SERVER – Index Seek & Scan
Index Issue
AWS Modern security standards for Networking and Infrastructure
SNOWFLAKE DATA LOADING
AWS -Right Size For Database Instance types
SQL SERVER – ReadErrorLog
SQL SERVER – SSIS
SQL SERVER – SSIS Error & Issues
SQL SERVER –Index,Filtered index ,Fill Factor & Indexes Defragmentation
Online Index Operations Work
SQL SERVER –Replication
SQL SERVER – Transactiona Replication
SQL SERVER –Replication Issues
SQL SERVER –Replication Q &A
SQL Server, Buffer Manager Object
SQL Server- Issue & Solution
SQL Server: Monitor jobs
SQL Trace_event Sequence
SQL-Performance recommendations
SQL-Server-Level Roles
SSRS
TempDb and recommendations
Trace Flags (Transact-SQL)
solating a Long-Running Query with SQL Profiler
Understanding Set Statistics IO output
Using a Dedicated Administrator Connection
Validating database objects after migration using AWS SCT and AWS DMS
Windows PC and servers installation and support
Desktop Support Interview Questions and Answers
ACTIVE DIRECTORY & DOMAIN
windows-server-administration-interview-questions
Windows policy Lock Pages in Memory option and SQL Server instance in VM
SQL SERVER – Index
Below table lists the types of INDEXES available in SQL Server and additional information.
Google Sites
Report abuse
Page details
Page updated
Google Sites
Report abuse