automation tag

Browse: Wetory / automation

Database restore – preserve permissions

Posts September 7, 2020 by Tomáš RybnickýNo Comments Reading Time: 2 minutes

I've made some updates to standardized database restore solution. Latest version is already available on my GitHub profile. New feature is preserving permissions settings after database restore. Your current database...

Create admin account

Scripts September 26, 2019September 26, 2019 by Tomáš RybnickýNo Comments Reading Time: < 1 minutes

Simply create new account directly in WordPress database. If you have access to WordPress database running on MySQL but not to WordPress admin you can "hack" it....

Add database role(s) in multiple databases

Scripts June 6, 2019September 6, 2019 by Tomáš RybnickýNo Comments Reading Time: < 1 minutes

Add login to same database roles in multiple databases can be time consuming. You find this useful when you need to add some login to instance. Especially when application using...

Jobs overview

Scripts May 30, 2019September 6, 2019 by Tomáš RybnickýNo Comments Reading Time: < 1 minutes

Quick overview of all SQL Agent jobs. You can check how many SQL Agent jobs you have created and their basic information. Returns jobs schedule information and status. Something similar...

Check actual replica

Scripts February 28, 2019September 6, 2019 by Tomáš RybnickýNo Comments Reading Time: < 1 minutes

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...

Byte converter calculator

Tag: automation

Database restore – preserve permissions

Create admin account

Jobs overview

Check actual replica