- SQL Server DBA Responsibilities
- Microsoft SQL Server Support Lifecycle
- How skip the reboot while installing SQL server or SQL patching using powershell or command prompt
- Differences B/W ENTERPRISE VS STANDARD EDITION FEATURES AND BENEFITS on SQL Server
- Differences B/W LogShipping Vs Mirroring Vs Transaction Replication in SQL server
- Configuring the mirroring in SQL SERVER
- Grant view defination access for all Stored Procedures in SQL server using SQL script
- Clear/Remove SQL Server Services from Services.msc
- SQL Server Database backup verify script
- Script to get disabled jobs list in SQL Server
- Backup, Restore percentage status script
- Script: list all Usernames, Roles for all the databases in SQL server
- MySQL database migration from one server to another server
- Last cluster failover sql script to find
- Using Power shell script to get Disk space report for multible servers in HTML format via DB alert
- How to Install SQL Server on Red Hat- Linux
- SQL Server System Databases
- Find who dropped, created or altered the table, SP or any object
- Executing a SQL statement from command prompt:
- Collation levels and default collation
- SP in Fundamental level
- T-SQL TRANSACT STRUCTURED QUERY LANGUAGE
- How to move system databases from one location to another location in SQL server
- SQL server SSIS Notes
- T-SQL Generate attach and detach database script for all User Databases On a SQL Instance
- SQL-Server-Notes
- MS SQL SERVER DBA NOTES
- SQL Server Reporting Services Configuration Manager
- SQL Server Database Migration Checklist
- Database 'DBA' cannot be opened. It is in the middle of a restore. (SQL Server, Error: 927)
- How To Find The Highest Salary In SQL Server
- How to Install SQL Server on Linux CentOS 7 - SQL Server on Linux
- SP in Fundamental level in SQL Server
- TRANSACT STRUCTURED QUERY LANGUAGE(T-SQL Commands)
- Litespeed Installation Steps
- Finding Fragmentation script in SQL Server
- SQL SERVER – ERROR MESSAGES (severity levels)
- SQL Server Reporting Service Start Error 1053 The Service Did Not Respond
- MySQL Frequently Using Commands
- SQL Server service does not start successfully because of a logon failure
- T-SQL – whether the databases are configured for mirroring or not
- T-SQL – Checking SQL Server Version and Service Packs
- DBA Regular usage scripts-SQL DBA
- Log File full-Troubleshooting
- Services Failed to start in windows
- Unable to Restore the backup files in SQL Server
- ORPHAN USERS FIND AND FIX SCRIPT in SQL Server
- To change all databases to Simple Recovery except system databases
- SQL_Login_Expired_script (T-SQL Script to find When will a SQL login password expire?)
- Sql server stopped reasons and checks
- Performance issues
- Disk drive full-Troubleshooting
- SQL Server is running slow reasons and checks to troubleshoot
- Database Issues - Troubleshooting
- Application is running slow
- SUSPECT DATABASE in SQL Server
- AlwaysON - Prerequisites -Every SQL DBA must know!
- Shrink Operation- Internally what happens?
- What is an execution plan?
- Log File Architecture in SQL Server
- Editions Of SQL Server
- Upgrade SQL Server Evaluation edition to license Edition of SQL Server
- Scripting Out the Logins, Server Role Assignments, and Server Permissions
- Scripting Out the Database / Object Level Permissions in SQL Server
- Sending query results to Excel through e-mail in SQL Server
- Sending query results to HTML Format through e-mail in SQL Server
- Performance DMV Queries in SQL Server T-SQL scripts
- To Drop All Linked Server:
- T-SQL Query to find currently running jobs in SQL Server
- Script for monitor blocking in SQL Server
- Queries taking longest elapsed time in SQL Server
- Get table row count for all tables in a database
- Page Life Expectancy
- What is Buffer Cache Hit Ratio and script
- How many sockets does my machine have -SQL Server?
- How many tasks are currently waiting?
- SQL Queries taking longer than normal to complete in SQL Server
- Steps to Database Refresh
- .NET Unhandled Exception error when running installing SQL Server 2012
- How to Reverse Log Shipping Roles in SQL Server
- Post patching checks in SQL Server
- Dump a specific table or few rows in MySQL Server
- How to get the complete backups information of a particular database in SQL Server
- How to display execution plans present in procedure cache in SQL Server
- T-SQL Script to know current sessions status in SQL Server
- List all the foreign keys referencing a database in SQL Server
- Query to find IP, port , connection details of SQL server
- Script Generates A script to Create all Logins, Server Roles in SQL Server
- Script To Collect Performance Metrics From SQL Server Query Analyzer
- Detailed Blocking Information With Query Information In SQL Server
- How To Find Current Running Transaction In Sql Server
- TOP 5 CPU-CONSUMING STATEMENTS In SQL Server
- Transaction Filling Log Space in SQL Server
This blog is to learn and share SQL DBA, Linux and Azure knowledge among people by Bandaru Ajeyudu
SQL DBA Scripts
Subscribe to:
Posts (Atom)
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+ .
ReplyDeleteWow thanks lot good site to learn SQL server can you please post performance wide like wait status , long run queries andand execut plan ---n+ .
ReplyDeleteOk sure... Thanks
ReplyDeleteGood to learn and easy to understand, thanks
ReplyDeleteVery Userful. Thanks.
ReplyDelete