Skip to content

Tag: Invoke-SqlCmd

PowerShell 1

Module: biz.dfch.PS.System.Data

This module provides Cmdlets that let you work with Microsoft SQL Server database (regular and LocalDB) by utilising System.Data.SqlClient (instead of relying on the buggy ‘SqlServerCmdletSnapin100’ snapin and its ‘Invoke-Sqlcmd’ implementation. You can set a ‘DefaultPrefix’ or an alias to call it the same as the Microsoft SQL Server supplied ‘Invoke-Sqlcmd’. Furthermore you can work with LocalDB instances (as used […]

By Ronald Rink Posted on

PowerShell 1

[biz.dfch.PS.System.Data] Invoke-SqlCmd without the overhead

=== UPDATE 2014-10-19 === I created a separate module that uses the SqlClient where you do not have to specify the command type and where you can also use LocalDB connections. === For the full module and description see my Post Module: biz.dfch.PS.System.Data. === UPDATE 2013-12-21 === added an additional parameter to specify the command type manually === Sometimes we […]

By Ronald Rink Posted on