▼
▼
Wednesday, 27 January 2021

Generate Managed Identity Using Powershell for Azure DataFactory

›
Open the powershell in the azure. (Select the correct subscription and create storage location for powershell or select an existing storage ...
Tuesday, 26 January 2021

Create a batch file to copy/move files from network folder

›
Create a batch file (.bat) and paste the below code:  @echo off set DAYS=7 robocopy \\192.168.0.30\sanjeebapp\data\in E:\sanjeebapp\data\in\...
Thursday, 21 January 2021

Create Build/Release Pipeline for SSIS in Azure SQL server

›
Create a new pipeline in devops. Select the source: Select an empty template Select Get Sources in the left panel: Now add a new agent job t...
Monday, 11 January 2021

How to modify Login in Azure SQL server

›
 for example, the login name is 'mysqluserlogin' 1) Enable the disabled login: ALTER LOGIN mysqluserlogin ENABLE ; 2) Change the lo...
Wednesday, 6 January 2021

How to create XSD schema from MSSQL Database table

›
 You'll need Microsoft SQL Server Management Studio to run the below query.  Select the database where you want to run the query against...
Wednesday, 11 November 2020

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...
Tuesday, 22 September 2020

How to find first weekday in the month in MSSQL

›
declare @n datetime = dateadd(mm,0,getDate())    declare @FirstWeekDayOfMonth int    SELECT @FirstWeekDayOfMonth= CASE          WHEN Dat...
Monday, 7 September 2020

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->Op...

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: ...

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...