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
94. Audit SQL modifications and get notified in SQL Server
95. When windows server last rebooted?
96. How To Find "Last Checkdb Run For All Databases" in SQL server
97. AlwaysOn – The secondary database doesn’t come automatically when the primary instance of SQL Server goes down
98. List All the Stored Procedure Modified in Last Few Days
99. Sending Missing backup status report through e-mail in SQL Server
100. T-SQL query to get tables size in GB with no of rows in SQL Sever
101. How to start sql server without tempdb
102. How to find the Linked Servers in SQL Server
103. Backup failed error Error: 3041, Severity: 16, State: 1
104. Database RESTORE error Msg 3183, Level 16, State 2, Line 1
105. The mirror database has insufficient transaction log data
106. How can you find the stored procedure used by SQL Job
107. T-SQL scripts to find out when last stats update happened ?
108. Analyzing Linux Logs:
109. SQL Server Reporting Services Migration
110. Using FILEPROPERTY to check for free space in a database
111. DDL CREATE_DATABASE EVENT alert via mail
112. Length specified in network packet payload did not match number of bytes read; the connection has been closed. Please contact the vendor of the client library.
113. Sql Server : A connection was successfully established with the server, but then an error occurred during the login process. The certificate chain was issued by an authority that is not trusted
114. DBA_Blocking_Alerts script
115. Index--Missing Index on database Notification Mail
116. Most active database in sql server
117. Script to Identifying possible CPU pressure via signal wait time
118. Top 10 Wait States in SQL Server
119. KILL all the connections for a database in SQL Server
120. SP who3 script to check processes in SQL server
121. How applications generally connect to database?
122. Check list for before Migration?
123. CDC (CHANGE DATA CAPTURE)
124. SQL Server WAITING TYPES
125. Log Shipping Article
126. DBCC (DATABASE CONSOLE COMMANDS) COMMANDS
127. STORED PROCEDURES IN SQL SERVER
128. DMV’S [DYNAMIC MANAGEMENT VIEWS]
129. TEMPDB ARCHITECTURE
130. EXECUTION PLAN
131. SQL Script: How To Find Index Fragmentation
132. SQL Server Database migration checklist
133. Check for CPU Pressure in SQL Server
134. Show Database ID in SQL Server
135. How to schedule and automate backups of SQL Server databases in SQL Server Express
136. Delete files older than n days using Powershell script
137. Get last reboot time for a host using powershell script
138. Send email with attachments using PowerShell script
139. Get CPU utilization for a host using PowerShell Script
140. Configure Alerts for disk I/O errors using t-sql
141. Should I Keep Autoshrink On?
142. Databases Last Accessed
143. SQL Server script to get a list of all jobs that access a database in SQL server?
144. SQL Server DBA: Database in Recovery Pending state
145. How many IP Addresses we require for setting up Active\Passive SQL Server cluster?
146. How many IP Addresses we require for setting up Active\Active SQL Server cluster with Analysis services?
147. Creating, backing up, and restoring a database in SQL Server on Linux OS
148. About Update stats and Indexing Optimize in SQL Server
149. Using SQL Server script to get list of users and their database roles in SQL Server
150. Finding an object in server in SQL Server using SP_MSFOREACHDB
151. Generate & change all SQL DB(s) to a different compatibility level - Alter SQL Compatibility level
152. Delete Bakups older than 1 day in SQL Server
153. create a tample table to gather the information of error log files in SQL Server
154. Error 22022: SQLServerAgent is not currently running so it cannot be notified of this action
155. Enable the SQL Server Agent in Linux
156. T-SQL Script to get SQL Data & Log Files Free Space & Space Used of all databases
157. Notification --Email SP Results in SQL Server
158. TempDB-Move TempDB Script in SQL Server
159. Retrieve SSRS report schedule info through SQL
160. T-SQL query to get tables size in GB with no of rows in SQL server
161. About Blocking in SQL Server
162. Configure Deadlock Alert Using T-SQL in SQL Server
163. DB_Growth status Report Alert
164. Database Growth status report for All DB(s) via Email in SQL Server
165. Database last updated and last_select_query_update_script
166. Tune inefficient queries in SQL Server
167. Improve the index design-- Review missing indexes
168. Review bad indexes
169. Find largest tables. Usually, we can prioritized index design based on slow queries that could be referencing one or more largest tables.
170. Backup Report via Email using Power Shell Script.
171. How to Manage a Very Large Database in SQL Server
172. Database level roles in Azure SQL Database
173. SQL Server – Get Size of All Databases in MB and GB
174. DIFFERENCES BETWEEN SQL SERVER CLUSTERED INDEX SCAN AND INDEX SEEK
175. Change data capture in onprem and Azure sql database
176. New in SQL Server 2022 – Generate_Series
177. Getting Database Backup History In SQL Server
178. SQL DBA Checklist/Activities
179. New security server roles in SQL SERVER 2022
180. Who is a DBA?
181. Page Life Expectancy, Buffer Cache Hit Ratio
182. New and Enhanced Features in SQL Server 2022
183. SQL Server - Choosing Between AWS EC2 vs AWS RDS
184. Availability Group issues fixed with Alerts
185. How much memory is each SQL Server database using?
186. How to Remove “Restricted User” in SQL Server
187. T-SQL Scripts for Troubleshooting Common Issues with SQL Server