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

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