▼
▼
Thursday, 25 February 2021

How to give SQL User access to execute Stored procedures and read/write access to database

›
Assumptions: stored procedures and tables are created under schema dbo. in case different schema, change the below code accordingly.   --Cre...
Thursday, 11 February 2021

How to Enable Cors in .net standard API ( or .net core API) for PUT GET and DELETE Methods

›
 Error: Access to fetch at 'https://localhost:44340/api/employee' from origin 'https://localhost:44339' has been blocked by ...
Tuesday, 9 February 2021

Create User Group in Azure using Azure CLI (powershell)

›
Steps1 - Login to the azure account with  right account with azure AD access.  Step 2 - Open CloudShell by clicking the icon on the top righ...
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...