Tools

In this page, I’d like to list almost all the 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: 17/03/2020

Not only Microsoft Data Platform

  • Microsoft SQL Server Management Studio 18.x (aka SSMS) (free) [link]
  • Microsoft SQL Server Data Tools [link]
  • Azure Data Studio [link] – Not only for databases in Azure!
  • SQL Sentry Plan Explorer (it’s free now!) [link]
  • Redgate SQL Search (free) [link]
  • Redgate SQL Compare [link]
  • Devart dbForge Studio for SQL Server [link]
  • Microsoft Power BI Desktop (free) [link]
  • Docker [link]
  • SCD Merge Wizard (free) [link]
  • RStudio (free) [link]
  • PowerShell
  • Postman [link]
  • Robo 3T [link] – works with MongoDB / Cosmos DB MongoDb API

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