Tools

In this page, I’d like to list almost all tools I’ve been used so far in my professional work, but also for my private purposes. I will describe each position in a few words soon, post some basic information, quick review or useful hints about them.
This list will be extended in the future. Also, if you use some worth-mention tool – let me know about it. Let’s share our knowledge!

Last Update: 21/06/2018

Not only Microsoft Data Platform

  • Microsoft SQL Server Management Studio 17.x (aka SSMS) (free) [link]
  • Microsoft SQL Server Data Tools [link]
  • SQL Sentry Plan Explorer (it’s free now!) [link]
  • Redgate SQL Search 2 (free) [link]
  • Redgate SQL Compare [link]
  • Devart dbForge Studio for SQL Server [link]
  • Microsoft Power BI Desktop (free) [link]
  • SCD Merge Wizard (free) [link]
  • RStudio (free) [link]
  • PowerShell

Very useful scripts

Azure (mainly)

  • Microsoft AzCopy [link]
  • Microsoft Azure Storage Explorer [link]
  • Microsoft Data Migration Assistant (DMA) [link]
  • Microsoft Data Warehouse Migration Utility (in Preview since 09/2015) [link]

Daily routines

  • Microsoft Visual Studio 2015, 2017
  • Git
  • Microsoft Office (including OneNote, yeah!)
  • NotePad ++ [link]
  • Visual Studio Code [link]
  • KeePass 2 1Password [link]
  • Slack
  • Total Commander [link]

Online tools

  • Microsoft Azure Portal [link]
  • Microsoft Azure Machine Learning Studio [link]
  • Regexper [link]
  • Devart SQL Formatter for SQL Server [link]
  • SQL Server Statistic Parser [link]

Certainly, I’ve been forgotten about few of them.
If you don’t want to miss any update of this page – please do follow me on Twitter. I’ll tweet once it happened.
@SQLPlayer

Cheers,
Kamil Nowinski