yorek

 private static void LoadFiles(string test)
   {
       LoadFile(LoadFVECS, $"c:\\Temp\\vector\\{test}\\{test}_base.fvecs", $"{test}_base", num:1000000, dim:128);
       LoadFile(LoadFVECS, $"c:\\Temp\\vector\\{test}\\{test}_query.fvecs", $"{test}_query", num:10000, dim:128);
       LoadFile(LoadIVECS, $"c:\\Temp\\vector\\{test}\\{test}_groundtruth.ivecs", $"{test}_groundtruth", num:10000, dim:100);
   }

private static void LoadFile(Func<BinaryReader, int, string> FileLoader, string file, string tablename, int num, int dim)
    {
        Console.WriteLine($"Reading file {file}...");

yorek

create or alter function dbo.CalculateSum(@a as int, @b as int)
returns int
with schemabinding
as
begin
	return @a + @b
end
go

create table dbo.WithPersistedUDF

yorek

export curVer=`printf "%03d%03d%03d" $(az --version | grep 'eventgrid' | awk '{gsub(/[()]/, "", $2); print $2}' | tail -1 | tr '.' ' ')`
export reqVer=`printf "%03d%03d%03d" $(echo '0.5.0' | tr '.' ' ')`
if [[ curVer -lt reqVer ]] ; then
    echo "error" >&2
    exit 1
fi

yorek

{
  "type": "file",
  "connection": "wasbs://CONTAINER@ACCOUNT_NAME.blob.core.windows.net",
  "config": null,
  "workspaces": {
    "root": {
      "location": "/",
      "writable": false,
      "defaultInputFormat": null,
      "allowAccessOutsideWorkspace": false

yorek

/*
	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

Login-AzureRmAccount

Select-AzureRmSubscription -Subscription <your-subscription-id>

$servers = Get-AzureRmSqlServer

foreach($s in $servers) {
    $databases = Get-AzureRmSqlDatabase -ServerName $s.ServerName -ResourceGroupName $s.ResourceGroupName
    foreach ($d in $databases)
    {

yorek

use tempdb
go

drop table if exists dbo.City;
drop table if exists dbo.Country;
drop table if exists dbo.Continent;

create table dbo.Continent
(
	continent_id int not null primary key,

yorek

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

# 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

Invoke-WebRequest https://aka.ms/installazurecliwindows -OutFile AzCliLatest.msi
.\AzCliLatest.msi /passive