til

Today I learned

A collection of concise write-ups on small things I learn day to day across a variety of languages and technologies. These are

things that don't really warrant a full blog post. Idea stolen from jbranchaud/til

Categories

• Docker
• Excel
• Github
• GoogleDocs
• Powershell
• R
• SQL Server

---

Docker

• Test

Excel

• Change dateformat from m/d/yyyy to mm/dd/yyyy in Excel

Github

• Adding images to Github readme files
• Migrate your code with the GitHub Importer

GoogleDocs

• Import any table or list from any URL into Google Spreadsheets

Powershell

• Making a parameter mandatory in a powershell file
• tree command

R

• Vectors
• Loading Data from SQL Server
• Head and Tail

SQL Server

• alter database scoped configuration
• Improving temp table and table variable performance using memory optimization
• Lead with date breaks but not with datetime
• new autogrow options in SQL Server 2016
• STRING_SPLIT()
• Truncate Table Partitions
• Emoji's in SSMS output