The following query returns the members of the database roles.
SELECT DP1.name AS DatabaseRoleName,
The following query returns the members of the database roles.
SELECT DP1.name AS DatabaseRoleName,
Steps1 - Login to the azure account with right account with azure AD access.
Step 2 - Open CloudShell by clicking the icon on the top right corner.
Step 3 - You'll need to associate CLI session with a Storage account. So follow the instruction and connect with the storage account.Step 4 - Select the PowerShell in the dropdown window
You'll see something like this screenshot:
PS /home/sanjeeb> Connect-AzureAd
Step 6 - type the below code (change the group name as your need):
PS /home/sanjeeb>New-AzureADGroup -Description "siteadmingroup" -DisplayName "siteadmingroup" -MailEnabled $false -SecurityEnabled $true -MailNickName "siteadmingroup"
On success, you'll see the object id like below:
ObjectId DisplayName Description
-------- ----------- -----------
daf23147-8123-dc23-bsb8-d2d2a5224271 siteadmingroup siteadmingroup
Open the powershell in the azure. (Select the correct subscription and create storage location for powershell or select an existing storage account)
Run the below query with correct value inside double quote:
Set-AzDataFactoryV2 -ResourceGroupName "MYResourceGroup" -Name "mydatafactory" -Location "UK South"
Press enter, and you'll be prompted to confirm. Type Y and press Enter.
You should see output like below:
Confirm
A data factory with the name mydatafactory in the resource group MYResourceGroup exists.
Continuing execution may overwrite the existing one.
Are you sure you want to continue?
[Y] Yes [N] No [S] Suspend [?] Help (default is "Y"): Y
DataFactoryName : mydatafactory
DataFactoryId : /subscriptions/e01105ad-822a-447a-2dd0-43124d16223l/resourceGroups/MYResourceGroup/providers/Microsoft.DataFactory/factories/mydatafactory
ResourceGroupName : MYResourceGroup
Location : uksouth
Tags : {}
Identity : Microsoft.Azure.Management.DataFactory.Models.FactoryIdentity
ProvisioningState : Succeeded
RepoConfiguration :
GlobalParameters :
For detail information read: Managed identity for Data Factory - Azure Data Factory | Microsoft Docs
Done!
Now add a new agent job to Build SSIS. Click the + icon.
I've assumed you have already configured domain in azure and have created a domain user.
Create Application in app registration
First of all Create an app registration [myssissqlserver01]
Now Go to the sql server (not the database) and on settings menu, click Active directory Admin
Connect to the database using MS Sql server management studio
Once admin is set , Open MS Sql server management studio and connect to the database.
Since we have added user to active directory admin, the user will have access to master database. So we can choose default database to connect,
Create a user in ssis and add to a suitable role
Create a new query window selecting SSISDB database
execute the below queries. Note that the user name should be identical to the Application name created in App registration section . [ myssissqlserver01]create user [myssissqlserver01] from external provider;
exec sp_addrolemember [db_owner],[myssissqlserver01];
By default, Android studio can not connect to the Azure devops source codes. To connect to the Azure devops, a plugins by Microsoft needs to be installed in the android studio. To install the plugin, follow the below steps:
I wanted to add a new sql user "sqluser" in Azure SQL server to access a database "sanjeeb".
Steps to create a new SQL user.
1) Connect to the Azure sql server with existing user using Microsoft SQL Server Management studio
2) Open new query window under Master database
3) Run the below script
CREATE LOGIN [sqllogin] WITH PASSWORD = 'verystrongpassword#1'
Scenario: I have an NVMe disk with an ext4 partition that was previously used as a directory in a Proxmox server. After reinstalling Proxm...