DmitriyVlasov

Latency numbers every programmer should know

L1 cache reference ......................... 0.5 ns
Branch mispredict ............................ 5 ns
L2 cache reference ........................... 7 ns
Mutex lock/unlock ........................... 25 ns
Main memory reference ...................... 100 ns             
Compress 1K bytes with Zippy ............. 3,000 ns  =   3 µs
Send 2K bytes over 1 Gbps network ....... 20,000 ns  =  20 µs
SSD random read ........................ 150,000 ns  = 150 µs

Read 1 MB sequentially from memory ..... 250,000 ns = 250 µs

DmitriyVlasov

// https://msdn.microsoft.com/ru-ru/library/system.windows.forms.powerstatus(v=vs.110).aspx
// http://www.codeproject.com/Articles/30414/Getting-Started-in-F-A-Windows-Forms-Application
open System
open System.Drawing
open System.Windows.Forms

type MainForm() as form = 
  inherit Form()
  // Define private variables

DmitriyVlasov

OS X Screencast to animated GIF

This gist shows how to create a GIF screencast using only free OS X tools: QuickTime, ffmpeg, and gifsicle.

Instructions

To capture the video (filesize: 19MB), using the free "QuickTime Player" application:

DmitriyVlasov

#I "../lib"
#r "FSharp.Markdown.dll"
#r "FSharp.Literate.dll"
#r "Deedle.dll"

open System.IO
open Deedle
open Deedle.Internal
open FSharp.Literate
open FSharp.Markdown

DmitriyVlasov

Памятка по сочетаниям клавиш окна редактирования DAX формул Microsoft Power BI

Базовое редактирование

Клавиша		Описание
Ctrl+X		Вырезать строку (Пустое выделение)
Ctrl+C		Скопировать строку (Пустое выделение)
Alt+↑	Alt+↓	Перемещает текущую строку вверх / вниз
Shift+Alt+↑	Shift+Alt+↓	Копирует строку и вставляет её выше / ниже

DmitriyVlasov

Sparkline Line =
// Sample get from: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2018-feature-summary/
// Formared width: http://www.daxformatter.com/

// Issue: SparlineMeasure var won't work when referenced (all bars end up 100%)
// Issue: Refactor to avoid nested SUMMARIZEs
// Issue: Negative values currently will not appear
VAR SparklineMeasure =
    SUM ( Sales[SalesAmount] ) // don't use this below per issue above
VAR SparklineMeasureTarget =

DmitriyVlasov

Sparkline Line = 

// Static line color - use %23 instead of # for Firefox compatibility
VAR LineColor = "%2301B8AA"

// "Date" field used in this example along the X axis
VAR XMinDate = MIN('Table'[Date])
VAR XMaxDate = MAX('Table'[Date])

// Obtain overall min and overall max measure values when evaluated for each date

DmitriyVlasov

// Пример использования функции получения Производственного календаря:
//
//  источник взят отсюда: http://data.gov.ru/opendata/7708660670-proizvcalendar
//  На момент 24.05.2018 в календаре содержатся описание праздников с 1999 года по 2025 год.
//
// let
//    PROD_СALENDAR_URL =
//      "https://data.gov.ru/opendata/7708660670-proizvcalendar/data-20181017T0930-structure-20181017T0930.csv?encoding=UTF-8",
//   ProductionCalendar = getProductionCalendar( PROD_СALENDAR_URL )
// in

DmitriyVlasov

html,
body {
    font-size: 16px;
}

.main-container {
    display: flex;
    width: 100%;
    height: 100%;
    justify-content: center;

DmitriyVlasov

// На большом объеме данных так работает плохо!!!

var date_time_text = format( 'fact_data'[moment]; "dd.MM.yyyy hh:00:00" )
var current_date = DATEVALUE( date_time_text ) 
var current_time = timeVALUE( date_time_text )
var curent_datetime = current_date + current_time
return curent_datetime