How To create SSIS user in Azure SQL server

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]

Set up Active directory Admin in sql server

Now Go to the sql server (not the database) and on settings menu, click Active directory Admin

Click Set Admin and add your domain account. (in case you don't have domain configured , Configure a new domain and create a domain user first)

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];

How to find first weekday in the month in MSSQL

declare @n datetime = dateadd(mm,0,getDate())

   declare @FirstWeekDayOfMonth int

   SELECT @FirstWeekDayOfMonth= CASE

         WHEN Datename(dw, Dateadd(dd, -Datepart(dd, @n) + 1, @n)) = 'Saturday' THEN Day(Dateadd(dd, -Datepart(dd, @n) + 3, @n))

         WHEN Datename(dw, Dateadd(dd, -Datepart(dd, @n) + 1, @n)) = 'Sunday' THEN Day(Dateadd(dd, -Datepart(dd, @n) + 2, @n))

         ELSE Day(Dateadd(dd, -Datepart(dd, @n) + 1, @n))

       END 

   select @FirstWeekDayOfMonth

Note: to find out first day of next month , change  first line to dateadd(mm,1,getDate()) 

1st day of next N month , change the first line to dateadd(mm,n,getDate())

Unit test c#: Create Fake Httpcontext to bypass Null exception for User object

 Microsoft Visual studio Test Framework

Requirement: Nuget package Moq 4.13.0.0 (or later)

Settings in visual studio: Menu->Tools->Options ->Debugging->General

Tick "Use Managed Compatibility Mode"

Code: (copied from stackoverflow)

Step 1: 

Create a new class FakeHttpContext and paste the below code. Change the Returns value to whatever user name you need.

public static class FakeHttpContext

    {

        public static void SetFakeContext(this Controller controller)

        {

            var httpContext = MakeFakeContext();

            ControllerContext context =

            new ControllerContext(

            new RequestContext(httpContext,

            new RouteData()), controller);

            controller.ControllerContext = context;

        }

        private static HttpContextBase MakeFakeContext()

        {

            var context = new Mock<HttpContextBase>();

            var request = new Mock<HttpRequestBase>();

            var response = new Mock<HttpResponseBase>();

            var session = new Mock<HttpSessionStateBase>();

            var server = new Mock<HttpServerUtilityBase>();

            var user = new Mock<IPrincipal>();

            var identity = new Mock<IIdentity>();

            context.Setup(c => c.Request).Returns(request.Object);

            context.Setup(c => c.Response).Returns(response.Object);

            context.Setup(c => c.Session).Returns(session.Object);

            context.Setup(c => c.Server).Returns(server.Object);

            context.Setup(c => c.User).Returns(user.Object);

            user.Setup(c => c.Identity).Returns(identity.Object);

            identity.Setup(i => i.IsAuthenticated).Returns(true);

            identity.Setup(i => i.Name).Returns("sanjeeb");

            return context.Object;

        }

    }

Step 2: 

Initialize the Fakehttpcontext in test initialize function. 

FakeHttpContext.SetFakeContext(usersController);

Accessing SMB share from Raspberry pi (or linux)

 Install smbclient :

sudo apt update 

sudo apt install smbclient

List the share items in the server: 

smbclient -L host

for example: smbclient -L 192.168.0.30

you need to enter password.then you'll see the result like this:

Domain=[WORKGROUP] OS=[Windows 6.1] Server=[Samba 4.9.5-Debian]

 Sharename       Type      Comment
 ---------       ----      -------
 print$          Disk      Printer Drivers
 RaspberrypiShare Disk      
 IPC$            IPC       IPC Service (Samba 4.9.5-Debian)
 pi              Disk      Home Directories
Domain=[WORKGROUP] OS=[Windows 6.1] Server=[Samba 4.9.5-Debian]

 Server               Comment
 ---------            -------
 RASPBERRYPI          Samba 4.9.5-Debian

 Workgroup            Master
 ---------            ------- 

To browse Shared folder :

smbclient \\\\192.168.0.30\\RaspberrypiShare pa$$w0rd

Temperature/CPU/Memory info of Raspberry Pi in console

 Open the console/terminal in the desktop or

Connect to the raspberry pi via ssh and type in the below command


For temperature:
/opt/vc/bin/vcgencmd measure_temp

For CPU info:
cat /proc/cpuinfo

For Memory info:
cat /proc/meminfo

Add Python(or Java or anything) to Environment variables

After installation of python in windows 10, python is not added to environment variable by default. If you want to use cmd for python, then python installed path must be configured in the environment variable. 

When you type python in cmd, you'll see the below message:

Follow the below steps to add python to environment:

1) Open System in Control panel

2) Click Advanced system settings

3)Click Environment Variables

4) Select Path in User Variables and click edit

5) Either create new and type in the path of Python installed location or Browse the folder using browse button in the above screenshot.

6) Click OK and close the Environment variables settings window and all other opened windows. 

7) Start a new command prompt and type python to test. 

Done!

Add Azure Devops plugins in Android Studio for Git or TFVC Version control

 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:

1) Open a project in Android studio
2) go to File --> Setting
3) go to Plugins

4) Search for azure devops

5) Click Install
6) Restart the Android studio.
7) Menu->VCS->Checkout from Version Control -> Azure Devops Git

8)Click Sign in ... 

9) Follow the wizard to connect the project.

Create Azure SQL User and add a sql role

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' 
   

4) Open new query window under database "sanjeeb"

5) Run the below script

CREATE USER [sqluser]

FOR LOGIN [sqllogin]

WITH DEFAULT_SCHEMA =  dbo

GO

-- Add user to the database owner role

EXEC sp_addrolemember N'db_owner', N'sqluser'

GO

6) You've now created a user login "sqllogin", user account "sqluser" and added the user to "db_owner role"

7) Connect to the database using the new user login account. 

login: sqllogin

password:verystrongpassword#1

8) Click Options and select Connection properties tab

9) input Connect to database = sanjeeb

10) Click connect

Scrollable readonly EditView in Kotlin

 Scrollable readonly EditView in Kotlin

In the view xml file: 
<EditText
        android:id="@+id/etResult"
        android:layout_width="match_parent"
        android:layout_height="343dp"
        android:background="@color/backgroundColor"
        android:backgroundTint="#00000000"
        android:ems="10"
        android:enabled="true"
        android:fontFamily="sans-serif-condensed"
        android:gravity="start|top"
        android:hint="@string/blankfoldermessage"
        android:importantForAutofill="no"
        android:inputType="none"
        android:paddingTop="2dp"
        android:singleLine="false"
        tools:targetApi="o" />

in the kotlin file (init function): 

etResult.keyListener = null

this will allow the edit text to be multiline, not editable but scrollable. 

Simple use of Timer in Kotlin

the code below will set the button to clickable after 30 sec:

btnOk.isClickable=false

Timer().schedule(timerTask {

    btnOk.isClickable=true

}, 1000*30)

the above code runs in a separate thread, 

so the UI is responsive while running this code.