saostad

let fnDateTable = (StartDate as date, EndDate as date, FYStartMonth as number) as table =>
  let
    DayCount = Duration.Days(Duration.From(EndDate - StartDate)),
    Source = List.Dates(StartDate,DayCount,#duration(1,0,0,0)),
    TableFromList = Table.FromList(Source, Splitter.SplitByNothing()),   
    ChangedType = Table.TransformColumnTypes(TableFromList,{{"Column1", type date}}),
    RenamedColumns = Table.RenameColumns(ChangedType,{{"Column1", "Date"}}),
    InsertYear = Table.AddColumn(RenamedColumns, "Year", each Date.Year([Date]),type text),
    InsertYearNumber = Table.AddColumn(RenamedColumns, "YearNumber", each Date.Year([Date])),
    InsertQuarter = Table.AddColumn(InsertYear, "QuarterOfYear", each Date.QuarterOfYear([Date])),

saostad

CREATE UNIQUE NONCLUSTERED INDEX INDEX_NAME_HERE
ON TABLE_NAME_HERE(FIELD_NAME_HERE)
WHERE FIELD_NAME_HERE IS NOT NULL;

saostad

// This script shows how to use M language (Power Query Formula Language) 
// to read data from GitHub API v4 using a POST request.
// This can come in handy when building PowerBI reports that utilize GraphQL endpoints for loading data.

let
    Source = Web.Contents(
	"https://api.github.com/graphql",
	[
		Headers=[
			#"Method"="POST",

saostad

const axios = require('axios')
const qs = require('querystring')

...

const requestBody = {
  name: 'Akexorcist',
  age: '28',
  position: 'Android Developer',
  description: 'birthdate=25-12-1989&favourite=coding%20coding%20and%20coding&company=Nextzy%20Technologies&website=http://www.akexorcist.com/',

saostad

folder name to keep all:

• [logs]
• [docs]
• [dist]
• [bin]
• [genearated]
• [src] parent folder
  • [services] io related codes
  • [helpers] small functions to data massage
• [templates]

saostad

Safest way to clean up boot partition - Ubuntu 14.04LTS-x64, Ubuntu 16.04LTS-x64

Reference

Case I: if /boot is not 100% full and apt is working

1. Check the current kernel version

$ uname -r 

saostad

Pushing to Multiple Git Repos

If a project has to have multiple git repos (e.g. Bitbucket and Github) then it's better that they remain in sync.

Usually this would involve pushing each branch to each repo in turn, but actually Git allows pushing to multiple repos in one go.

If in doubt about what git is doing when you run these commands, just

saostad

{
  // Place your global snippets here. Each snippet is defined under a snippet name and has a scope, prefix, body and
  // description. Add comma separated ids of the languages where the snippet is applicable in the scope field. If scope
  // is left empty or omitted, the snippet gets applied to all languages. The prefix is what is
  // used to trigger the snippet and the body will be expanded and inserted. Possible variables are:
  // $1, $2 for tab stops, $0 for the final cursor position, and ${1:label}, ${2:another} for placeholders.
  // Placeholders with the same ids are connected.
  // Example:
  "Print to console": {
    "scope": "javascript,typescript,typescriptreact",

saostad

#include <Windows.h>
#include <WinCred.h>
#include <iostream>

using namespace std;

main()
{
	PCREDENTIALA cred;

saostad

import { AuthenticationProvider } from "@microsoft/microsoft-graph-client";
const axios = require("axios").default;
const qs = require("qs");
const msGraph_AuthUrl = process.env.msGraph_AuthUrl;
const msGraph_client_id = process.env.msGraph_client_id;
const msGraph_client_secret = process.env.msGraph_client_secret;
const msGraph_tenant_id = process.env.msGraph_tenant_id;
export class MyAuthenticationProvider implements AuthenticationProvider {
  /**
   * This method will get called before every request to the msgraph server