Questions tagged [automation]
The automation tag has no usage guidance.
87
questions
0
votes
1
answer
54
views
how can I add the date and time on the autogrowth query below?
while trying to prevent autogrowth from happening,
I got this nice script here.
however, if it does happen, I need to know how to find it out.
that I can do using this very nice script by Max Vernon.
...
1
vote
2
answers
106
views
error when re-applying the permissions script into the original database - sql server
when I run the following script:
-- ——— SCRIPT GRANTS for Object Privileges—————
IF OBJECT_ID('[sys].[sysrowsets]') IS NOT NULL GRANT CONTROL on [sys].[sysrowsets] to [db_myrole_BA]
I get this ...
2
votes
1
answer
75
views
how to set in-transit encryption sql server?
today I had to check if in-transit Encryption was up and running in a particular server (sql server) and if not then set it up.
the way it is done is:
In SQL Server Configuration Manager, expand SQL ...
0
votes
1
answer
35
views
Postgres: automatic action (increment count of foreign key) after update
How to automate an update in a table, after a change in another table ?
Say (please see below) I have a table countries, and a table cities. How to make that, when adding a city in table cities, the ...
0
votes
1
answer
29
views
How to auto-shutdown postgresql with timeout?
I have here a simple PostgreSQL instance, generated by a build script. The goal is to make it automatically safe shutdown, if it has no new connection request for a while (like 5 min or so).
What is ...
0
votes
0
answers
43
views
Can my database LDF and MDF files go into this directory?
Is there a way to determine, given a drive and a directory, if a CREATE DATABASE command would succeed? There are basically two questions here.
1. How do you determine if a simple command like this ...
2
votes
0
answers
23
views
Is there an algorithmic way to identify potential primary key foreign key relationships in postgres
I have a lots of tables in postgres with a lots of columns per each table. I need to write a program in such a way that it can identify the columns that can be a potential primary and foreign key pair....
0
votes
0
answers
62
views
Using dbatools powershell module with azure automation hybird worker groups
We want to use dbatools powershell module with azure automation . We already have dbatools module on hybird worker group machines . We tested the code we want to run by directly logging into the ...
0
votes
1
answer
487
views
Error with dbatools
Trying to export SQL Objects via DBAtools in Powershell.
Get-DbaAgentJob -SqlInstance 'TestServer01' -Job 'mydatabase-daily-backup' | Export-DbaScript -FilePath C:\temp\mydatabase-daily-backup.sql
...
0
votes
0
answers
29
views
Managing database Users when restoring backups across environments
I have numerous Azure SQL Server Databases that teammates backup and restore. The issue we're running into is regarding the Users on these databases. We have Azure AD Groups that contain the ...
1
vote
1
answer
62
views
How to list the permissions needed for a role / user to run a query / view successfully (in an automated manner)?
Suppose I have queries / views like this:
select
internal.companies._cid,
internal.companies.name,
src1.employees.year,
src1.employees.count
from internal.companies
join src1....
0
votes
1
answer
152
views
Create a schema for each user in a group
I'm trying to find a way to create a schema within a database, for each user in a group...
The goal is to automatize the creation process for a structure in a school.
Say, each class is a database, ...
0
votes
1
answer
256
views
How to daily download and merge a csv file and update on Google sheets?
Disclaimer: I’m not sure if this question goes on here. I’ve trying to solve this issue for quite a while and I don’t think there is another way other than using a python script.
I need to solve this ...
0
votes
1
answer
151
views
Setting up reporting and alerting in SQL Server through TSQL and Powershell
I am trying to automate monitoring on SQL Server through PowerShell and TSQL, to get alerts through mail whenever some issue is there.
I have gone through many articles over the internet and tried the ...
1
vote
0
answers
102
views
Can you synchronize user accounts with specific DB permissions with records found in a table?
Background / Current Setup
I have a database in a SQL server that uses row level security to determine what records a user has access to.
Users will have two methods to interact with the database. ...