hfleitas

//txt on svrs, common dbo gen log, atlasbridge, bogaboo proc info,

#connect cluster('demo12.westus.kusto.windows.net').database('sqlbi')

print ("Welcome")

print now()

// 8 machines in Azure
.show cluster

hfleitas

#connect cluster('demo12.westus.kusto.windows.net').database('GitHub') 

// Basics
// 1.2 Billions records 
GithubEvent
| count 

// Sample 
GithubEvent
| take 10

hfleitas

#connect cluster('demo12.westus.kusto.windows.net').database('sqlbi')

.show tables details
| where TableName startswith "BIAzure"
| summarize sum(TotalOriginalSize), sum(TotalExtentSize) by TableName
| extend CompressionRatio = sum_TotalOriginalSize/sum_TotalExtentSize  
// ~30TB of data in 3 different tables (traces and perormance counters)
// Data is compressed and indexed (x10.2 for traces, x21-34 for performance counters)
// Compressed data and index are persisted to blob and cached on SSD

hfleitas

// #connect cluster('igniteadxsource.eastus2').database('Occupancy')

#connect cluster('adxpm10774.eastus').database('IoTAnalytics')

print("😍 ML 🤖")

// Python UnSupervised Learning
//Create a cusotm UDF to run K-Means clustering using Python plugin
.create-or-alter function with (folder = "Python") kmeans_sf_OccupDetc(tbl:(*),k:int,features:dynamic,cluster_col:string) {
    let kwargs = pack('k', k, 'features', features, 'cluster_col', cluster_col);

mbcrump

Demos

Demo Name	Source
VS2019 – Search Functionality	https://visualstudio.microsoft.com/downloads/
VS2019 – New Project Experience	https://visualstudio.microsoft.com/downloads/
VS2019 – Code cleanup/Refactor	https://github.com/mbcrump/CodeCleanup
VS2019 – Dev Command Prompt for PowerShell	Coming Soon!
.NET Core 3 - Greenshot	https://github.com/greenshot/greenshot/
.NET Core 3 - - dotnet try demo	https://github.com/dotnet/try

SQLDBAWithABeard

[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12
Set-ExecutionPolicy Bypass -Scope Process -Force; iex ((New-Object System.Net.WebClient).DownloadString('https://chocolatey.org/install.ps1'))

choco install chocolatey -y
choco install 1password -y
choco install azure-data-studio -y
choco install azure-functions-core-tools-3 -y
choco install azure-cli -y
choco install bicep -y
choco install chocolatey-core.extension -y