SQL DBA Scripts


  1. SQL Server DBA Responsibilities
  2. How skip the reboot while installing SQL server or SQL patching using powershell or command prompt
  3. Differences B/W ENTERPRISE VS STANDARD EDITION FEATURES AND BENEFITS on SQL Server
  4. Differences B/W LogShipping Vs Mirroring Vs Transaction Replication in SQL server
  5. Configuring the mirroring in SQL SERVER
  6. Grant view defination access for all Stored Procedures in SQL server using SQL script
  7. Clear/Remove SQL Server Services from Services.msc
  8. SQL Server Database backup verify script
  9. Script to get disabled jobs list in SQL Server
  10. Backup, Restore percentage status script
  11. Script: list all Usernames, Roles for all the databases in SQL server
  12. MySQL database migration from one server to another server
  13. Last cluster failover sql script to find
  14. Using Power shell script to get Disk space report for multible servers in HTML format via DB alert
  15. SQL Server Database migration checklist
  16. How to Install SQL Server on Red Hat- Linux
  17. SQL Server System Databases
  18. Find who dropped, created or altered the table, SP or any object
  19. Executing a SQL statement from command prompt:
  20. Collation levels and default collation
  21. SP in Fundamental level
  22. T-SQL TRANSACT STRUCTURED QUERY LANGUAGE
  23. How to move system databases from one location to another location in SQL server
  24. SQL server SSIS Notes
  25. T-SQL Generate attach and detach database script for all User Databases On a SQL Instance
  26. SQL Server Database Migration Checklist
  27. Database 'DBA' cannot be opened. It is in the middle of a restore. (SQL Server, Error: 927)
  28. How To Find The Highest Salary In SQL Server

4 comments:

  1. Wow thanks lot good site to learn SQL server can you please post performance wide like wait status , long run queries andand execut plan ---n+ .

    ReplyDelete
  2. Wow thanks lot good site to learn SQL server can you please post performance wide like wait status , long run queries andand execut plan ---n+ .

    ReplyDelete
  3. Good to learn and easy to understand, thanks

    ReplyDelete