Search this site

Embedded Files

Generative AI Applications on AWS
About
- AWS-POSTGRES AURORA Best Practices
Data Analytical Architecture
IBM Db2- Rebind Package [Stored procedure or user-defined function (UDF)]
DMS-Parallel-load boundaries
ORACLE : DBA Commands for Datagaurd, GoldenGate
DB2 Queries
DB2-AWS Db2(luw) DATABASE MIGRATION STRATEGIES
Migration DB2 (LUW) - RDS -DB2
DB2-SQL-Queries
DB2(LUW) RDS- Buffer pool and Tablespace Troubleshooting
DB2- Drop a DB2 Schema
DB2-Errors and Soloutions
DB2-AWS DMS endpoint connection issue
DB2 RDS -USER & LOGIN
AWS-AI (Artificial-Intelligence)
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
Amazon DataBase & Migration
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 -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 - 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
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
Operating System & System Memory Topics
ORACLE
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
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

Generative AI Applications on AWS
About
- AWS-POSTGRES AURORA Best Practices
Data Analytical Architecture
IBM Db2- Rebind Package [Stored procedure or user-defined function (UDF)]
DMS-Parallel-load boundaries
ORACLE : DBA Commands for Datagaurd, GoldenGate
DB2 Queries
DB2-AWS Db2(luw) DATABASE MIGRATION STRATEGIES
Migration DB2 (LUW) - RDS -DB2
DB2-SQL-Queries
DB2(LUW) RDS- Buffer pool and Tablespace Troubleshooting
DB2- Drop a DB2 Schema
DB2-Errors and Soloutions
DB2-AWS DMS endpoint connection issue
DB2 RDS -USER & LOGIN
AWS-AI (Artificial-Intelligence)
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
Amazon DataBase & Migration
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 -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 - 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
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
Operating System & System Memory Topics
ORACLE
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
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

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