Productivity Tools

Tools written by an IT business manager, a passionate developer.

Select SQL View

It allows to quickly select view or table from SQL Server.

Select-SQLView -Name "[misc].[Movies]" -DatabaseName PawelDT -ServerName .\sql2019


The same data as above in SQL


You could save your server name and database name in the MasterConfiguration so it won’t be needed to pass them later.

Select-SQLView -Name "[misc].[Movies]"

The module allows also to add where and order by with suffix keyword.

sq "me.raport" -Suffix 'where expenseid=1889' -Verbose

Alias SQ

Module imports also alias sq.

sq "[misc].[Movies]"