jDBA

 

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/

How to delete rows in a table are same identical rows in all the fields where clause column –> https://www.sqlserverblogforum.com/dba/how-to-delete-rows-in-a-table-are-same-identical-rows-in-all-the-fields-where-clause-column/

 

Leave a Reply

%d bloggers like this: