▼
▼
Thursday, 1 December 2022

Generate SQL script from entity framework using powershell/visual studio

›
to run the below command , start PowerShell in visual studio. Select the database project. In PowerShell:   Script-Migration this command wi...
Monday, 28 November 2022

Adding custom prerequisite software to Visual studio installer project

›
 One of my application require asp.net runtime to be installed in the client system to run the application. Visual studio installer project ...
Thursday, 17 February 2022

Raspberry pi: how to find raspberry pi model details

›
In the raspberry pi console type:    pinout output: ,--------------------------------. | oooooooooooooooooooo J8 +==== | 1oooooooooooooo...
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...