SQL DBA Scripts

1. SQL Server DBA Responsibilities
2. Microsoft SQL Server Support Lifecycle
3. How skip the reboot while installing SQL server or SQL patching using powershell or command prompt
4. Differences B/W ENTERPRISE VS STANDARD EDITION FEATURES AND BENEFITS on SQL Server
5. Differences B/W LogShipping Vs Mirroring Vs Transaction Replication in SQL server
6. Configuring the mirroring in SQL SERVER
7. Grant view defination access for all Stored Procedures in SQL server using SQL script
8. Clear/Remove SQL Server Services from Services.msc
9. SQL Server Database backup verify script
10. Script to get disabled jobs list in SQL Server
11. Backup, Restore percentage status script
12. Script: list all Usernames, Roles for all the databases in SQL server
13. MySQL database migration from one server to another server
14. Last cluster failover sql script to find
15. Using Power shell script to get Disk space report for multible servers in HTML format via DB alert
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-Notes
27. MS SQL SERVER DBA NOTES
28. SQL Server Reporting Services Configuration Manager
29. SQL Server Database Migration Checklist
30. Database 'DBA' cannot be opened. It is in the middle of a restore. (SQL Server, Error: 927)
31. How To Find The Highest Salary In SQL Server
32. How to Install SQL Server on Linux CentOS 7 - SQL Server on Linux
33. SP in Fundamental level in SQL Server
34. TRANSACT STRUCTURED QUERY LANGUAGE(T-SQL Commands)
35. Litespeed Installation Steps
36. Finding Fragmentation script in SQL Server 
37. SQL SERVER – ERROR MESSAGES (severity levels)
38. SQL Server Reporting Service Start Error 1053 The Service Did Not Respond
39. MySQL Frequently Using Commands
40. SQL Server service does not start successfully because of a logon failure
41. T-SQL – whether the databases are configured for mirroring or not
42. T-SQL – Checking SQL Server Version and Service Packs
43. DBA Regular usage scripts-SQL DBA
44. Log File full-Troubleshooting
45. Services Failed to start in windows
46. Unable to Restore the backup files in SQL Server
47. ORPHAN USERS FIND AND FIX SCRIPT in SQL Server
48. To change all databases to Simple Recovery except system databases
49. SQL_Login_Expired_script (T-SQL Script to find When will a SQL login password expire?)
50. Sql server stopped reasons and checks
51. Performance issues
52. Disk drive full-Troubleshooting
53. SQL Server is running slow reasons and checks to troubleshoot
54. Database Issues - Troubleshooting
55. Application is running slow
56. SUSPECT DATABASE in SQL Server
57. AlwaysON - Prerequisites -Every SQL DBA must know!
58. Shrink Operation- Internally what happens?
59. What is an execution plan?
60. Log File Architecture in SQL Server
61. Editions Of SQL Server
62. Upgrade SQL Server Evaluation edition to license Edition of SQL Server
63. Scripting Out the Logins, Server Role Assignments, and Server Permissions
64.  Scripting Out the Database / Object Level Permissions in SQL Server
65. Sending query results to Excel through e-mail in SQL Server
66. Sending query results to HTML Format through e-mail in SQL Server
67. Performance  DMV Queries in SQL Server T-SQL scripts
68. To Drop All Linked Server:
69. T-SQL Query to find currently running jobs in SQL Server
70. Script for monitor blocking in SQL Server
71. Queries taking longest elapsed time in SQL Server
72. Get table row count for all tables in a database
73. Page Life Expectancy
74. What is Buffer Cache Hit Ratio and script
75. How many sockets does my machine have -SQL Server?
76. How many tasks are currently waiting?
77. SQL Queries taking longer than normal to complete in SQL Server
78. Steps to Database Refresh
79. .NET Unhandled Exception error when running installing SQL Server 2012
80. How to Reverse Log Shipping Roles in SQL Server
81.  Post patching checks in SQL Server
82. Dump a specific table or few rows in MySQL Server
83. How to get the complete backups information of a particular database in SQL Server
84. How to display execution plans present in procedure cache in SQL Server
85. T-SQL Script to know current sessions status in SQL Server
86. List all the foreign keys referencing a database in SQL Server
87. Query to find IP, port , connection details of SQL server
88.  Script Generates A script to Create all Logins, Server Roles in SQL Server
89. Script To Collect Performance Metrics From SQL Server Query Analyzer
90. Detailed Blocking Information With Query Information In SQL Server
91.  How To Find Current Running Transaction In Sql Server
92. TOP 5 CPU-CONSUMING STATEMENTS In SQL Server
93. Transaction Filling Log Space in SQL Server