Pay Vijayawada Municipal Corporation Water bill and Property Tax Online

Hi Vijayawada residents,

Do not stand in the big queue/line for paying the property tax and water bill.

Now you can pay property tax and water bill online. 

Citizen Services Home Page

Click the below link to view all online payment links for Citizen services

https://vijayawada.cdma.ap.gov.in/en/citizeservice

Water Bill Payment Procedure

1. After clicking the above link, click "Click here to pay your Water charges"

2. Enter any one of the following search fields like Assessment number or old assessment number

3. Click on "Search"

4. The search result appears if you enter valid input as below

5. Click on the actions and select "Collect Charge" as shown in below image

6. You would be redirected to a page where you have to do the following

1. Amount
2. Select payment gateway
3. Accept terms and conditions
4. Click on "Pay Online"

7. After clicking on "Pay Online" button, you would be redirected to the below page

8. Click on "Online Payment"

9. Then the following screen will come

10. Click on "SBI" button

11. Now you would be taken to SBI payments page, where you have to select the type of payment mode

12. Click on the appropriate mode and perform the payment

• The credit card and netbanking charges differ from the screenshot (image) above

13. Once the payment is successful, you will get "Generate Receipt" button

14. Click on it and download the payment receipt.

Property Tax (PT) Payment Procedure

1. After clicking the citizen service link, click "Click here to pay your Property taxes"

2. Enter your assessment number (new or old) 

3. You would be redirected to a page where you have to do the following

1. Amount
2. Select payment gateway
3. Accept terms and conditions
4. Click on "Pay Online"

4. After clicking on "Pay Online" button, you would be redirected to the below page

5. Click on "Online Payment"

6. Then the following screen will come

7. Click on "SBI" button

8. Now you would be taken to SBI payments page, where you have to select the type of payment mode

9. Click on the appropriate mode and perform the payment

• The credit card and netbanking charges differ from the screenshot (image) above

10. Once the payment is successful, you will get "Generate Receipt" button

11. Click on it and download the payment receipt.

Hope this blog post help you to do the online payment.

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

Connect or Mount USB Storage drives in Windows Linux Sub System

Hi folks,

This post will explain the process of connecting / mounting USB devices to Windows Linux Sub Systems

Mount removable media (e.g. E:)

$ sudo mkdir /mnt/e
$ sudo mount -t drvfs E: /mnt/e

Unmount

$ sudo umount /mnt/e

Send your comments and feedback to psrdotcom@gmail.com

Flutter Android Release Failure [INSTALL_FAILED_NO_MATCHING_ABIS] issue fix

Hi folks,

Today I will let you know the flutter issue of Failure [INSTALL_FAILED_NO_MATCHING_ABIS] and its fix.

Procedure

• Add the following config in your app/build.gradle

android {

    splits {

           abi {

                 enable true

                 reset()

                 universalApk true

               }

    }

}

flutter {

    source '../..'

}

Release AppBundle / APK

• Run the following command to generate appbundle

flutter build appbundle

• Run the following command to generate apk

flutter build apk

References

https://developer.android.com/studio/build/configure-apk-splits#configure-abi-split

https://developer.android.com/guide/app-bundle

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

Free and discounted tools or software for Student Developers

Hi All,

Today I will share information of the tools which are free or less price for the student developers.

1. https://education.github.com/pack - Every student must subscribe to this
2. https://github.com/AchoArnold/discount-for-student-dev
3. https://github.com/ripienaar/free-for-dev
4. https://techcrunch.com/2019/08/20/github-adds-21-new-partners-to-its-free-student-developer-pack/
5. https://dzone.com/articles/20-pro-developer-tools-with-great-student-discount

Hope my links are useful for all the students.

And for the teachers also, the GitHub provides pack.

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

Send email from Microsoft excel with customized sheet data

Hi folks,

Have you ever faced requirement where you have to send email from an excel with excel data. If you are in that situation, this blog makes your life easier.

Pre-requisites

Send customized excel data of each row as an email. You should have data in each row and you should know have recipient e-mail address

You should have configured e-mail client like outlook, mail of desktop

Procedure

1. Use Hyperlink function of excel
• Syntax
• =HYPERLINK("mailto:"&e-mailCellNo&"?subject="&subjectCellNo&"&body="&bodyCellNo&"%0A","Send email")
• Help
• Cellno in syntax should point to your data cell number
• %0A - New line
• mailto - The recipient mail address
• subject - the text
• body - the body text
• Note
• If you have any special characters, then use ENCODEURL function
• Don't put the ENCODEURL function in HYPERLINK function
• Make sure, ENCODEURL output points to a different cell and use that cell number in HYPERLINK
2. Use $ to use the same cell data repeatedly
3. After doing the hyperlink to a cell, you should be able to view "Send email"
4. Click on the send email
5. Opens the configured/default e-mail client by filling the recipient, subject and body content from excel sheet
6. Click on "send" or "Ctrl+Enter" keyboard shortcut to send email

Hope, this helps you to explore excel and send email with excel data to many recipients with single click

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

Microsoft SQL Server 2019 Express Docker image Example

Hi Folks,

Today I am going to explain the procedure for connecting to a Microsoft SQL Server 2019 Express edition docker image

Pre-requisites

1. Docker Desktop
2. Windows OS
3. Powershell/command prompt

Procedure

Get and run docker image

> docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=<Your_Password>" -e "MSSQL_PID=Express" --name "<Your_SQL_Server_Name>" -p 1433:1433 -d mcr.microsoft.com/mssql/server:2019-latest

Command information

Remove the "MSSQL_PID=Express" to run other version of SQL Server

Replace 2019 with required SQL Server version

Password should be atleast 8 characters with capital, small, numeric, special character combination

Use different port if you already have a local sql server

Name should not contain spaces

Check for docker container

> docker ps

You should able to see the container with your SQL Server name at the end in running status

Connect to SQL Server

docker exec -it "<Your_SQL_Server_Name>" /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P "<Your_Password>"

You should be able to see "1>" prompt

Command information

Use the SQL Server name or user the container ID

Use database and play around with table(s)

Important

Multiple commands can be entered one after one, but to execute the set of command(s), you need give "GO" command.

Create Database

CREATE DATABASE SampleDB

GO

List all databases

SELECT Name from sys.Databases

GO

Start using the database

USE SampleDB

GO

Create table

CREATE TABLE UserInfo ( Id INT, Name VARCHAR(64))

GO

Insert values

INSERT INTO UserInfo (1, 'ABC')

GO

Retrieve table contents

SELECT * FROM UserInfo

GO

Exit from SQL Server

QUIT

Hope you are able to run the SQL Server Docker image.

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