Skip to content

Instantly share code, notes, and snippets.

View Associative Grouping using Graph Tables.sql
IF db_id('demo') IS NULL
CREATE DATABASE demo
GO
USE demo
GO
-- Nodes
DROP TABLE IF EXISTS SupplierNodes;
CREATE TABLE SupplierNodes
@NJLangley
NJLangley / profile.ps1
Last active May 16, 2019
PowerShell Profile
View profile.ps1
Import-Module posh-git;
# PoshGit settings
$GitPromptSettings.DefaultPromptBeforeSuffix.Text = '`n'
@NJLangley
NJLangley / cloudSettings
Last active Jun 12, 2019
Visual Studio Code Settings Sync Gist
View cloudSettings
{"lastUpload":"2019-06-12T22:53:20.627Z","extensionVersion":"v3.2.9"}
View ssms_colours_only.vssettings
<UserSettings>
<ApplicationIdentity version="14.0"/>
<ToolsOptions>
<ToolsOptionsCategory name="Environment" RegisteredName="Environment"/>
</ToolsOptions>
<Category name="Environment_Group" RegisteredName="Environment_Group">
<Category name="Environment_FontsAndColors" Category="{1EDA5DD4-927A-43a7-810E-7FD247D0DA1D}" Package="{DA9FB551-C724-11d0-AE1F-00A0C90FFFC3}" RegisteredName="Environment_FontsAndColors" PackageName="Visual Studio Environment Package">
<PropertyValue name="Version">2</PropertyValue>
<FontsAndColors Version="2.0">
<Theme Id="{A4D6A176-B948-4B29-8C66-53C97A1ED7D0}"/>
@NJLangley
NJLangley / Signing Stored Procedures for Server Level Permissions Demo Code.sql
Last active Oct 24, 2017
Signing Stored Procedures for Server Level Permissions Demo Code
View Signing Stored Procedures for Server Level Permissions Demo Code.sql
/*********************************************************************************************************************
****
**** Demo script for signing stored procedures with certificates
****
**** Provided as is, run at you on risk, and not on a production server!
****
*********************************************************************************************************************/
You can’t perform that action at this time.