Database Administration Scripts

The best trouble-shooting data capture query (is not Xevent), in fact, is my Active Session history together with Running Differential wait stats time-based capture, presented since HASSUG Dec. 2012 and WISSUG Nov. 2015.
Joseph Sack, Ian Stirk etc. SQL Server Book online on MSDN have many T-SQL example scripts.
Sam Alapati, Darl Kuhn, Kevin Loney, Thomas Kyte, Richard Niemiec , etc. Oracle online documentation that you can find many example scripts have good Oracle example scripts. Ignore Don. Burleson's poorly organized con script books (wasted money, not organized, there is no book, just some undocumented script files)
I have 700+ SQL Server 2005/2008 DBA scriptlets I often used. (including automatic refresh, automatic PIT recovery, database management ....)
I have 600+ Oracle DBA scriptlets I often used. (including duplicate database script, duplicate to standby script, Configure/setup Data Guard Primary and failover Standby script. RMAN automatic PIT recovery, database management....)
I also started studying MySQL scripts, administration, performance tuning, and Microsoft Azure, Azure SQL database.
---------------------------------------------------------------------------------------------------------------------------------------------------
Powershell script to report HTML email failed jobs, failed backup, generate restore scripts. See SQL Saturday #308 presentation.

Powershell script to record CPU, Memory, disk IO, host and SQL Server performance data into a Datawarehouse database with partitioned tables. See Dec. 11, 2012 presentation.
Powershell script to monitor database and server disk space, email notification or alert on high water mark. See Dec. 11, 2012 presentation.
Example of Improving T-SQL performance 8250% -Write T-SQL code with performance in mind Jason S. Wong, Nov. 15, 2009
Automated refresh of QA/Test/Dev databases with PIT data without costly software.
Delete, Insert, Update large number of records from production without blocking, timeout, T-log space issues.
SQLServer 2008/5 monitor blocking-blocked query with detail like query-text, query-plan , last wait type etc.
T-SQLCLR C# code to get hostname from IP
Find missing, redundant, unused, indexes .... after SQL Saturday #57, Jan. 29, 2010.
Find Page Latch, Page IO Latch, Lock contention .... after SQL Saturday #57, Jan. 29, 2010.
Find active sessions with detailed info .... after SQL Saturday #57, Jan. 29, 2010.
A SP auto-generating restore/recovery script using dynamic SQL with input parameters Nov. 5, 2009, The generated script is to be used for PIT full recovery or used for refresh QA or standby.
Automated Index defrag T-SQL script Jason S. Wong, Nov. 5, 2009. I have a newer version for SQL2012 with fillfactor as a parameter and allowing LOB column defrag online. (http://www.sqlservercentral.com/scripts/68671 )
Automated databases refresh with T-SQL Jason S. Wong, Nov. 5, 2009 (http://www.sqlservercentral.com/scripts/backup+restore+log+shipping/68673/)
Automatic generated restore-recovery script for refresh from host1:db1 to host2:db2 Jason S. Wong, Nov. 19, 2010
Find Backupset with T-SQL 2008/2005 Jason S. Wong, Nov. 5, 2009 (http://www.sqlservercentral.com/scripts/Backup+Restore/68676/)
Example of auto-generated T-SQL script with T-SQL (this case is a shrink command) Jason S. Wong, Sep. 30, 2009 . (http://www.sqlservercentral.com/scripts/68336 )
The danger of select in SQL Server -- where can it go wrong? Jason S. Wong, Sep. 22, 2010
How to Partition Table with T-SQL 2008/2005 Jason S. Wong, Nov. 5, 2009, before you partition you should prove first the choosen partition key columns will benefit in your query scenario. (http://www.sqlservercentral.com/Contributions/Edit/68675)
T-SQL technique for a huge insert..select not blocking Jason S. Wong, Jun. 28, 2010 (http://www.sqlservercentral.com/scripts/T-SQL/70446/)
T-SQL DBA script to monitor your database disk space Jason S. Wong, Jun. 8, 2010, after SQLPASS presentation Houston
Find Foreign Key Table from PK Table Jason S. Wong, Sep. 30, 2009 (http://www.sqlservercentral.com/Contributions/Edit/68346)
Search for a Text String in All Stored Procedures Jason S. Wong, Sep. 30, 2009 (http://www.sqlservercentral.com/Contributions/Edit/68347 )
more other codes such as Replication Monitoring query .... will be published coming soon.