SQL SERVER DBA, Linux and Azure: SQL DBA Scripts

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

7 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
  4. Excellent article, very useful. Thank you!!

    ReplyDelete