Skip to main content

Posts

Showing posts from May, 2021

Generate Self Signed Certificate using powershell and install on

Run Following commands in Powershell PS C:\Users\Administrator> $cert = New-SelfSignedCertificate -certstorelocation cert:\localmachine\my -dnsname *.domain.com PS C:\Users\Administrator> $pwd = ConvertTo-SecureString -String 'password' -Force -AsPlainText PS C:\Users\Administrator> $path = 'cert:\localMachine\my\' + $cert.thumbprint PS C:\Users\Administrator> Export-PfxCertificate -cert $path -FilePath d:\powershellcert.pfx -Password $pwd Directory: D:\ Mode LastWriteTime Length Name ---- ------------- ------ ---- -a---- 2/22/2021 8:16 PM 2661 powershellcert.pfx Install the PFX file generated on Server and client machines Please find steps below to install the attached self signed certificate. I have already installed it on IIS. and application is accessible without error on https if certificate is installed. 1. Select Local Machine: 2. Press next 3. Enter password: password...

File Upload : The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

TITLE: SQL Server Import and Export Wizard ------------------------------ The operation could not be completed. ------------------------------ ADDITIONAL INFORMATION: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.Data) ------------------------------ BUTTONS: OK ------------------------------ Solution: Install Microsoft Access Database Engine 2016 Redistributable https://www.microsoft.com/en-us/download/details.aspx?id=54920

Connecting Xamarin Form Application with Dynamics CRM

Microsoft Dynamics CRM: Configure Client in Azure AD for Xamarin App https://dev.to/425show/user-authentication-in-xamarin-with-azure-ad-b2c-4clm User Login / Authentication: https://scaleablesolutions.com/connecting-xamarin-form-application-with-dynamics-crm/ Fetch Data from CRM: https://scaleablesolutions.com/displaying-microsoft-dynamics-crm-records-in-listview-using-xamarin/

SQL : Cross Join and CONCAT_WS

Create Table Structure: CREATE TABLE Meals ( MealName VARCHAR ( 100 ) ) CREATE TABLE Drinks ( DrinkName VARCHAR ( 100 ) ) INSERT INTO Drinks VALUES ( 'Orange Juice' ) , ( 'Tea' ) , ( 'Cofee' ) INSERT INTO Meals VALUES ( 'Omlet' ) , ( 'Fried Egg' ) , ( 'Sausage' ) SELECT * FROM Meals ; SELECT * FROM Drinks   SELECT CONCAT_WS ( '-' , MealName , DrinkName ) AS MenuList FROM Meals CROSS JOIN Drinks

AWS Text Extract : Extract Data from Any Document

Pricing: Availability Zones:  References: https://www.youtube.com/watch?v=5g48uf5sCu8 https://aws.amazon.com/augmented-ai/resources/?blog-posts-cards.sort-by=item.additionalFields.createdDate&blog-posts-cards.sort-order=desc