WP Attachment Download
Almost everybody who is working with WordPress on higher level, and is using it behind borders of simple blogging website system definitely knows plugin Advanced Custom Fields (ACF in following...
Index list
Get information about all existing indexes in given database. This script can be handful when you want to check all indexes with their create scripts and some of useful information...
Collect DBCC CHECKDB results
Get more more handful information about corrupted database. Best practice to check database consistency and integrity on regular basis to prevent more data damage will help you to find out...
Search for value
You want to find some value within whole database, in all tables and columns? You can use this script for searching of value in your database, I found it when...
Disk drives size
Returns information about space on disk drives used by databases in instance. This c an be handful in automation for example before creating or restoring new database. Also can be...
Size of each database
Returns size of all databases all database files with its location and state....
Size summary
Returns summary of all data within SQL Server instance grouped by type. Tempdb database size excluded. Script can be handy during analyze of instance, disk drives sizing, memory sizing etc....
Last schema changes
Shows information about schema changes done in databases by DDL operations. This is quick listing for all databases containing information about last schema changes done in every database.
TIP: If you...
Batch database drop
You need to drop more databases quickly. If you want to drop some database you can use SSMS GUI or T-SQL to drop single database, but if you need to...
Check actual replica
You want to execute script against database only if actual database is primary replica? Sometimes you need to continue execution of batch only when actual database is primary replica on...