Microsoft Azure DevOps Boards move or copy tasks between projects

 Hi all,

Today we will go through the different ways to organize the work items in Microsoft Azure DevOps Boards.

Pre-requisites

User should have appropriate permissions in both the projects.

Moving the work items between projects

• Select the required items from Boards -> Work items
• Select the more options icon (...) from any one of the selected work item
• Choose "Open selected items in Queries" options
• 
• Queries page navigation will happen
• Select all the items from query results (Ctrl+A)
• Select the more options icon (...) from any one of the selected work item
• Choose "Move to team project" options
• 
• 
  
• Move work item dialog opens up
• 
• 
  
• Choose appropriate options and click Ok.
• All the items would be listed in moved project queries window.
• Click on "Save items" option.

Copy work items between projects

Export work items

• Select the required work items
• Select the more options icon (...) from any one of the selected work item
• Choose "Open selected items in Queries" options
• 
• Queries page navigation will happen
• Select all the items from query results (Ctrl+A)
• Export the work items to CSV file
• 

Import the work items

• Navigate to the required project boards section where the work items has to be created
• Click on "Import work items" option
• 
• 
  
• Queries page navigation will happen
• 
• 
  
• Choose the exported CSV file and click on "Import" button
• The work items would be listed in queries section
• Click on "Save items"
• Navigate to "Work items" section to view the added work items.

Request you send your comments and feedback below or send mail : psrdotcom@gmail.com

Microsoft Azure DevOps Server move or copy Project Source Code from one organization to another organization

Hi folks,

Today I will explain the process of moving the projects from one organization to another in Azure DevOps Server which includes the source repository code, history of commits, tags.

Pre-requisites

• Git command line tool
• ssh-keygen tool
• Azure DevOps Project access

Environment Setup

1. Create ssh key on your local PC
2. Same user account on both the organization with required permissions (Admin)
3. On Azure DevOps, to go user profile
4. Add the generated SSH pub key of PC to Azure DevOps

Procedure in terminal/command prompt

1. git clone <old org project repo ssh url>

2. cd <project>

3. git branch -a

    a. git checkout <all branches one by one>

4. git fetch --tags

5. git remote rm origin

6. git remote add orgin <new org project repo ssh url>

7. git push origin --all

8. git push --tags

Hope you are able to move/copy the project source code which includes the history of commits and tags.

Please send your comments and feedback to psrdotcom@gmail.com

Microsoft Azure SQL Server Read Only User Creation Deletion

Hi folks,

Today I will explain, how you can easily manage the readonly (view) users in Azure Microsoft SQL Server

Procedure

In Azure SQL Server

CREATE LOGIN [testuser] WITH PASSWORD = 'random_p@$$w0rd';

For master and each DB

Note: You must create the user in master db before creating in other databases

CREATE USER [testuser] FOR LOGIN [testuser]   
    WITH DEFAULT_SCHEMA = [dbo];  
GO

Grant Connect permission

GRANT CONNECT TO [testuser]
GO

Give datareader role to read (view) only

ALTER ROLE db_datareader ADD MEMBER [testuser]
GO

Drop user in DB

DROP USER [testuser]

GO

Drop user in Azure SQL

DROP LOGIN [testuser];
GO

Please send your comments and feedback to psrdotcom@gmail.com

Connect to public hosted Ubuntu server MySQL Docker Image from local MySQL Workbench

Hi folks,

Today I am going to explain the procedure to test the public cloud hosted MySQL docker in Ubuntu Server to your local MySQL WorkBench.

We configured a Ubuntu Server on public cloud and installed docker.
Ping the public IP address to make sure, it is reachable to your pc/laptop.

Configure System

Install MySQL Docker Image

# docker pull mysql/mysql-server:latest

Check the images

#docker images

You should be able to view the downloaded mysql server image

Start the MySQL Server

# docker run --name=mysql1 -p 33061:3306 -d mysql/mysql-server
-d : Run in daemon mode
-p host_port:container_port
--name: container name

The mapped public ubuntu server port is 33061, which is mapped to the mysql server port 3306.

Check the containers

# docker ps

You should be able to view your mysql docker containers with container id and ports information

Get the MySQL root user password

MySQL generates a one-time password for docker container and writes to the log.

• To view the log, execute the following command

# docker logs mysql1

• To get the generate one-time password, filter the log with keyworkd "GENERATED"

# docker logs mysql1 2>&1 | grep GENERATED

• You should be able to get the line like below

GENERATED ROOT PASSWORD: Axegh3kAJyDLaRuBemecis&EShOs

• Copy the one-time password. In the next step, we will use this to login.

Reset MySQL root user password

• Connect to MySQL server

# docker exec -it mysql1 -uroot -p

• Paste the generated root password
• Change the password

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'yourpwd';
mysql> FLUSH PRIVILEGES;

• Though you have the root user credentials, you won't be able to connect.

Root cause: root user belongs to localhost, not for the public host usage
Solution: create another user with all privileges

mysql> CREATE USER 'username'@'%' IDENTIFIED BY 'youpwd';
mysql> GRANT ALL PRIVILEGES on *.* TO USER 'username'@'%' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;

• Exit the mysql

mysql> exit;

• Restart the docker

# docker restart mysql1

Connect from MySQL Workbench

1. Open MySQL Workbench
2. Click on add new connection icon
3. Enter the "Connection name"
4. Enter host name "public IP address" or "URL"
5. Enter username as "dev" (Above created user)
6. Click on Password "Store in vault" button and enter the "dev" user password
7. Click on "Test Connection" button
8. You should be able to view the "Successfully made the SQL Connection" pop-up

Hope this tutorial helps you to get connected with your public hosted mysql docker instance to your local mysql workbench.

Please send your feedback and comments to psrdotcom@gmail.com

Remote desktop connection to Azure AD joined computer device

Hi Folks,

I have an issue of remotely connecting one of the Azure AD joined computer.

Fix is explained below

1. Open "Remote Settings" from "System".
2. You should be able to view "Remote" tab from "System Properties".
3. Uncheck "Allow connections only from computers running Remote Desktop with Network Level Authentication (recommended)" from Remote Desktop section.
4. Open regedit.exe.
5. Navigate to "Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Terminal Server\WinStations\RDP-Tcp".
6. Update "SecurityLayer" key to "0" (Zero) from default 2 (Two).
7. Reboot your system.
8. While taking remote desktop, user "AzureAD\"your work email id" as your username.
9. You should be able to connect your AzureAD joined system remotely from now.

Please send your comments and feedback to psrdotcom@gmail.com