automation Archives

View the role assigned to each user (Report Server)

By adminPosted on July 20, 2022

Question : Is there anyway I could list down the roles assigned to each user on the different folders on […]

By adminPosted on June 30, 2022

Question : The MongoDB docs state that one can use the mongo client console to initialize replica sets by running […]

By adminPosted on June 14, 2022

Question : I have been using this script from Kenneth Fisher to get the server permissions. — Server Permissions SELECT […]

By adminPosted on May 27, 2022

Question : I have a Windows batch file which extracts some data from a remote system and then imports it […]

By adminPosted on May 24, 2022

Question : I am using the below command in my batch file and running it via task scheduler. osql -S […]

By adminPosted on May 21, 2022

Question : I have a job that runs a package with specific parameters as you can see on the picture […]

By adminPosted on May 21, 2022

Question : I need to create an automatic backup of all databases from PostgreSQL ( running on a Windows machine […]

By adminPosted on May 19, 2022

Question : I need help in generating a automated script for database where I can give parameters for database name, […]

By adminPosted on April 6, 2022

Question : I am an administrator for a bunch of SSAS Instances. Sometimes I need to install or migrate SSAS […]

By adminPosted on March 29, 2022

Question : TLDR; What’s the easiest way to automate a mongodb backup of a 20-gig DB? We run mongo on […]