jDBA

Advertisements

 

This page will link the DBA day to day (dtd) activities and scripts to refer back, some environment does not allow copy and past between servers.

SQL server connection and blocking finding script.

https://www.sqlserverblogforum.com/dba/sql-server-connection-and-blocking-finding-script/

Find latest SQL server backup from history.

https://www.sqlserverblogforum.com/scripts/find-the-latest-backup-in-sql-server/

Drive space check SQL server steps and scripts.

https://www.sqlserverblogforum.com/dba/drive-space-check-sql-server-steps-and-scripts/

Backup restore steps using T-SQL.

https://www.sqlserverblogforum.com/backuprestore/step-by-step-backuprestore-using-t-sql/

Load SQL error log to table for a quick read.

https://www.sqlserverblogforum.com/dba/load-sql-error-log-to-a-table/

Move database between drives.

https://www.sqlserverblogforum.com/dba/move-database-between-drives/

SQL server reports GUI Object table deleted history and CPU RAM IO.

https://www.sqlserverblogforum.com/dba/sql-server-reports-gui-schema-change-history-and-cpu-ram-io/

Topics and Concepts:

Basics for freshers

https://www.sqlserverblogforum.com/basics-for-freshers/sql-servers-basics/

SQL server internal architecture for freshers

https://www.sqlserverblogforum.com/internals/sql-server-internal-architecture/

Understanding SQL server recovery models and backup types

https://www.sqlserverblogforum.com/internals/sql-server-recovery-models-and-backup-types/

 

Leave a Reply

%d bloggers like this: