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