Skip to content

Instantly share code, notes, and snippets.

View yorek's full-sized avatar
:octocat:
Working from home

Davide Mauri yorek

:octocat:
Working from home
409 followers · 77 following
View GitHub Profile
@yorek
yorek / stackoverflow-dapper-50091943.cs
Created May 2, 2018 06:25
Return a single JSON from SQL Server and map it into a custom object
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using Dapper;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
namespace stackoverflow_dapper_50091943
{
@yorek
yorek / Microsoft.PowerShell_profile.ps1
Last active April 6, 2018 00:18
Powershell Profile
# Taken from https://joonro.github.io/blog/posts/powershell-customizations.html
# and https://hodgkins.io/ultimate-powershell-prompt-and-git-setup
Import-Module posh-git
Import-Module Get-ChildItemColor
Import-Module PSReadLine
$global:GitPromptSettings.BeforeText = '['
$global:GitPromptSettings.AfterText = '] '
@yorek
yorek / update-az-cli.ps1
Created March 13, 2018 04:02
Powershell Script to download and update AZ CLI 2.0
Invoke-WebRequest https://aka.ms/installazurecliwindows -OutFile AzCliLatest.msi
.\AzCliLatest.msi /passive
@yorek
yorek / get-latest-object-version.sql
Last active December 20, 2017 21:09
get-latest-object-version
USE tempdb
GO
/*
Generate Sample Data
*/
DROP TABLE IF EXISTS dbo.[Sample]
GO
WITH cte AS
@yorek
yorek / OAuth2Middleware.cs
Last active December 14, 2021 05:50
ASP.NET Core 2 Custom OAuth2 Authentication
using System;
using System.Collections.Generic;
using System.Linq;
using System.Net.Http;
using System.Net.Http.Headers;
using System.Security.Claims;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Authentication;
using Microsoft.AspNetCore.Authentication.OAuth;
using Newtonsoft.Json.Linq;
@yorek
yorek / access-json-file.sql
Last active October 1, 2019 06:55
Access to JSON file content using T-SQL
/*
Create the Database Master Key, if needed
*/
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'My-L0ng&Str0ng_P4ss0wrd!';
GO
/*
Create database scoped credentials to store the Shared Access Signature (SAS)
needed to access the Azure Blob Container. More info on Azure Blob SAS here:
@yorek
yorek / azure-functions-save-form-data-to-sql-azure.sql
Last active April 5, 2017 07:06
T-SQL to support yorek/azure-functions-save-form-data-to-sql-azure.csx
/*
Expected JSON:
{
"Subject": "Form's Subject",
"FirstName": "Davide",
"LastName": "Mauri",
"EmailAddress": "[email protected]",
"OtherField1": "OtherValue1",
@yorek
yorek / azure-functions-save-form-data-to-sql-azure.csx
Last active July 6, 2018 12:11
Save JSON data into SQL Azure using Azure Functions
#r "Newtonsoft.Json"
using System;
using System.Net;
using System.Net.Mail;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using Dapper;
using Newtonsoft.Json;
@yorek
yorek / get-r-home.sql
Last active April 13, 2016 11:55
Get installation directory for MRO in SQL Server 2016
execute sp_execute_external_script
@language = N'R',
@script = N'OutputDataSet <- data.frame(R.home());'
with result sets (([R.home()] nvarchar(max) not null));
@yorek
yorek / Linux Static IP
Last active August 29, 2015 14:23 — forked from fernandoaleman/Linux Static IP
## Configure eth0
#
# vi /etc/sysconfig/network-scripts/ifcfg-eth0
DEVICE="eth0"
NM_CONTROLLED="yes"
ONBOOT=yes
HWADDR=A4:BA:DB:37:F1:04
TYPE=Ethernet
BOOTPROTO=static