Skip to content

Instantly share code, notes, and snippets.

View Seddryck's full-sized avatar

Cédric L. Charlier Seddryck

41 followers · 17 following
View GitHub Profile
@Seddryck
Seddryck / audit-login-query.sql
Created December 30, 2016 16:00
Query extended events about login changes (creation, permissions, roles, ...)
declare  @LogFilePath varchar(255);
 
select
    @LogFilePath=log_file_path
from
    sys.server_file_audits
where
    name='Audit Login Changes';
 
set @LogFilePath=@LogFilePath +'*.sqlaudit';
@Seddryck
Seddryck / audit-login-setup.sql
Created December 30, 2016 16:02
Setup extended events about login changes (creation, permissions, roles, ...)
use [master];
go
 
create server audit
    [Audit Login Changes]
to file
(   FILEPATH = N'N:\Trace\'
    , MAXSIZE = 1024 MB
    , MAX_FILES = 10
    , RESERVE_DISK_SPACE = OFF
@Seddryck
Seddryck / appveyor.yml
Last active January 20, 2018 14:03
Install Azure Cosmos DB Emulator on AppVeyor
install:
- ps: Start-FileDownload 'https://aka.ms/cosmosdb-emulator' -FileName 'c:\projects\cosmos-db.msi'
- cmd: cmd /c start /wait msiexec /i "c:\projects\cosmos-db.msi" /qn /quiet /norestart /log install.log
- ps: Start-Process "start-emulator.cmd"
- ps: .\wait-connect-cosmosdb.ps1
@Seddryck
Seddryck / Character.FromHtmlEntity.pq
Created March 28, 2018 04:04
Function to translate en html entity (such as ♣ or À) to the equivalent character
shared Character.FromHtmlEntity = (entity as text) =>
let
list =
{
[Name="Agrave", Number=192]
, [Name="Aacute", Number=193]
, [Name="Acirc", Number=194]
, [Name="Atilde", Number=195]
, [Name="Auml", Number=196]
, [Name="Aring", Number=197]
@Seddryck
Seddryck / latest.genbi.ps1
Created October 12, 2019 21:08
Download the latest version of Genbi.exe from GitHub releases
param(
[switch]$pre = $false,
[Parameter(Mandatory = $false)] $zipfilePath = 'C:\Projects\genbi.zip'
)
$latestRelease = Invoke-WebRequest https://api.github.com/repos/seddryck/nbi/releases$(If (!$pre) {"/latest"}) -Headers @{"Accept"="application/json"}
$json = $latestRelease.Content | ConvertFrom-Json
write-host $json[0]
write-host 'latest version:' $json[0].tag_name
$url = $json[0].assets | ? { $_.Name -Match "Genbi" } | % browser_download_url
write-host 'url:' $url