Change default directory for Windows command prompt and Powershell when running with admin privileges

 Hi all,

It's been a while since I posted things.

Here is my previous post where the non-admin user changes the default directory for the command prompt and PowerShell.

https://psrdotcom.blogspot.com/2022/03/change-default-directory-of-windows.html

But in this post, I will be explaining about running the command prompt / powershell with admin rights and setting the default directory. Because, when you are running with admin privileges, it by default goes to the SYSTEM32 folder of Windows.

Environment

I use the command prompt and PowerShell, which are pinned to the taskbar of Windows.

Run the application with the admin rights

• Right-click on the application icon -> click on Properties
• Go to the "Compatibility" tab
• Check "Run this program as administrator"

Run the shortcut with the admin rights

• Right-click on the shortcut icon -> click on Properties
• Go to the "Shortcut" tab
• Click on the "Advanced" button
• Check "Run this program as administrator"

Change the command prompt default directory

• We need to have a .bat file with the following content
• @echo off
• cd <default_directory>

Now use the .bat file in the shortcut properties

• Right-click on the shortcut icon -> click on Properties
• Go to the "Shortcut" tab
• In the "Target" field append the below text
• /k "batfile_dirpath\batfile.bat"

Change the PowerShell default directory

• Right-click on the shortcut icon -> click on Properties
• Go to the "Shortcut" tab
• In the "Target" field append the below context after powershell.exe

• -NoExit -command "& {Set-Location <default_directory>}"

• Click on "OK"

Hope, this helps you to reduce the frequent directory changes in the command prompt and PowerShell.

Feel free to provide 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

My first WebAssembly program

Hi folks,

Today, I am going to explain how to setup and write a sample program.

WebAssembly enables high performance applications on web pages. WebAssembly natively runs on browser along with HTML, CSS, JavaScript and approved by W3C (World Wide Web Consortium).

To know more about WebAssembly, go through the official webiste https://webassembly.org/

Pre-requisites

1. Git
2. CMake
3. Host system compiler
• Windows - Visual Studio 2017 +
• Linux - GCC
• Mac - XCode
4. Python 2.7.x

After downloading and installing the pre-requisites, make sure git, cmake and python are accessible in path.

Install

1. Open Terminal/PowerShell with Admin rights
2. Get the emsdk files

• git clone https://github.com/emscripten-core/emsdk.git

3. Navigate to the downloaded folder emsdk

• cd emsdk

4. Install (Note: On PowerShell execute this command, Set-ExecutionPolicy -ExecutionPolicy RemoteSigned -Scope LocalMachine)

• ./emsdk install latest

5. Activate

• ./emsdk activate latest

Create Sample HTML file

• Create folder
• mkdir hello
• Navigate to the folder
• cd hello
• Create a file hello.c and place the following code

#include
int main(int argc, char ** argv) { printf("Hello PSR!\n");}

Convert C file to HTML

emcc hello.c -o hello.html

Run WebServer (Optional)

Run emrun webserver to serve the html pages.

emrun --no_browser --port 8080 .

Hope, the tutorial is useful. Happy coding.

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

Eclipse Java Scrapbook: Run, Debug, Test Code Expressions and Statements Without Running Entire Project

Hi friends,

A very useful utility for developers who are using eclipse as their IDE is Java Scrapbook.

What is scrapbook?

Sometimes, you might think like running a statement or expression or loop without running the entire code or project. You want to try something without disturbing the existing code.

Scrapbook answers the above and lot more.

Scrapbook can be used to inspect, execute, debug your statements, expressions, loops and etc.

Creating Eclipse IDE

New -> Java -> Java Run/Debug -> Scrapbook Page

Inspecting Snippet

To inspect an snippet like 2+3, Just type 2+3 and Click on "Run->Inspect" as per your requirement. It will display the result in a pop-up.

Execute Statements

If you want to try some statements, you can execute it by performing "Run->Execute"

Debug Statements

You can put breakpoint and debug your code.

I liked it very much because we no need to run the entire project to test/try a sample code.

Hope all the developers will like this feature.

Note: Please send your feedback to psrdotcom@gmail.com