▼
▼
Wednesday, 29 September 2021

How to push changes to github after password authentication is deprecated

›
I tried to check-in some code to my github repository after more than 6 months today. I found that normal username and password for authenti...
Saturday, 11 September 2021

simple use of Record in c#9 and newer versions

›
 c# 9 introduces a new keyword Record which makes an object immutable. Properties in the record can be initialised at the time of creation o...

init only property in c#9 or later versions

›
 c# 9 introduces new Init-Only property that allow to make immutable properties in a class. This means the property with "init" ke...
Friday, 14 May 2021

How to check roles for sql users

›
  The following query returns the members of the database roles. SELECT  DP1.name  AS  DatabaseRoleName,        isnull  (DP2.name,  'No ...
Thursday, 22 April 2021

Search by keyword in Stored procedure, Views, Functions And Tables

›
Purpose: The [util].[SearchAll] stored procedure searches for a specified string ( @strFind ) in the following database objects: Procedures...
Tuesday, 20 April 2021

Find table and column name in MSSQL

›
It is time consuming job to browse each and every tables and columns to find required tables  and it's even difficult to search columns ...
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 ...