Skip to content

Instantly share code, notes, and snippets.

View jibinpb's full-sized avatar

Jibin jibinpb

  • London, United Kingdom
View GitHub Profile
@jibinpb
jibinpb / allow_blob_public_access-azure_portal.png
Last active August 20, 2020 11:11
`allow_blob_public_access` is not reflecting while upgrading provider version 1.44 to 2.23
allow_blob_public_access-azure_portal.png
@jibinpb
jibinpb / download.ps1
Created April 27, 2020 08:41
SQL Server Management Studio Download via PowerShell
[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12
# SQL Server Management Studio (SSMS)
$url = "https://download.microsoft.com/download/f/e/b/feb0e6be-21ce-4f98-abee-d74065e32d0a/SSMS-Setup-ENU.exe"
$output = "SSMS-Setup-ENU.exe"
Invoke-WebRequest -Uri $url -OutFile $output
@jibinpb
jibinpb / ServiceFabric_gMSA_security.json
Created December 24, 2018 02:16
Security JSON for ServiceFabric Cluster Configuration
"security": {
"ClusterCredentialType": "Windows",
"ServerCredentialType": "Windows",
"WindowsIdentities": {
"ClustergMSAIdentity" : "gMSA_Account_Name@contoso.com",
"ClusterSPN" : "ServiceFabric/servicefabric.intranet.contoso.com",
"ClientIdentities": [{
"Identity": "CONTOSO\\ServiceFabricAdminGroup",
"IsAdmin": true
},{
@jibinpb
jibinpb / set_spn_for_ServiceFabric.ps1
Created December 24, 2018 02:01
"setspn" for ServiceFabric
## Replace this value with new gMSA Name
## $gMSAName = 'gMSA_Account_Name'
setspn -S ServiceFabric/servicefabric.intranet.contoso.com $gMSAName
@jibinpb
jibinpb / azure_maps_typeahead.html
Last active August 25, 2019 15:19
Location Autocomplete using Azure Maps & typeahead.js
<div id="remote">
<input class="typeahead" type="text" placeholder="Type Here">
</div>
@jibinpb
jibinpb / typeahead_bower.sh
Created November 21, 2018 05:54
Location Autocomplete using Azure Maps & typeahead.js
bower install jquery
bower install typeahead.js
@jibinpb
jibinpb / spacy_test.ipynb
Last active August 27, 2018 02:24
spaCy Test Entity
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@jibinpb
jibinpb / select_node_and_edge.sql
Created August 1, 2018 05:28
SQL Server GDB - Select from Edge and Node
SELECT
entity1.Name AS [Parent],
entity2.Name AS [Subsidiary],
s.HoldingPercentage,
s.EffectiveDate
FROM [Entity] entity1, [Subsidiaries] s, [Entity] entity2
WHERE MATCH(entity1-(s)->entity2);
@jibinpb
jibinpb / insert_node_and_edge.sql
Created August 1, 2018 05:22
SQL Server GDB - Insert Data to Node and Edge
DECLARE @ParentNodeId nvarchar(1000), @ChildNodeId nvarchar(1000)
DECLARE @EntityNodeDetails table(NodeId nvarchar(1000));
-- Insert the Facebook as parent organization
INSERT dbo.Entity ([Name], [Code], [Type])
OUTPUT INSERTED.$node_id
INTO @EntityNodeDetails
VALUES ('Facebook, Inc.', 'FB', 'Public')
-- Get inserted nodeId to variable
SELECT TOP 1 @ParentNodeId=NodeId FROM @EntityNodeDetails
@jibinpb
jibinpb / create_node_and_edge.sql
Created August 1, 2018 05:15
SQL Server GDB - Create Node And Edge Tables
IF OBJECT_ID('dbo.Entity', 'U') IS NOT NULL
DROP TABLE dbo.Entity
GO
-- Create Entity as NODE table
CREATE TABLE dbo.Entity
(
[ID] INTEGER PRIMARY KEY IDENTITY,
[Name] VARCHAR(100) NOT NULL,
[Code] VARCHAR(100) NULL,