PowerShell – Knowledgebase

Change linked service / dataset connection string in an Azure Data Factory with PowerShell after deployment

5 February, 2019 Roel van Lisdonk 0 Comments 1 category

When you connect an Azure Data Factory to GIT it will create json files per linked service, but the json file will contain some part of the connection string. If you want to change the

How to create an IIS application pool and web site on Windows 10 with PowerShell and Visual Studio Code

18 August, 2016 Roel van Lisdonk 0 Comments 1 category

Tasks to create an IIS application pool and web site on Windows 10 with PowerShell and Visual Studio Code: Install the Visual Studio Code plugin PowerShell 0.6.2 Create a file iis.configuration.ps1 in Visual Studio Code:

Fix: Visual Studio 2013 / 2014–SQL Server 2014 – The term ‘Invoke-Sqlcmd’ is not recognized as the name of a cmdlet

6 May, 2015 Roel van Lisdonk 0 Comments 1 category

Note When you want to run / edit / debug PowerShell scripts inside Visual Studio 2013 / 2015 you will have to install the “PowerShell Tools for Visual Studio” Visual Studio extension found at:

drop and create SQL Server tables based on an array with table names by using PowerShell

5 May, 2015 Roel van Lisdonk 0 Comments 1 category

# Add table names to the "$tables" array in the order they should be created. $tables = @( "dbo.Person", "dbo.Settings", "dbo.SmsStatus", "dbo.Sms" ) # Create a table if it does not exist. # It

Use formatting–f, when writing to the output console with PowerShell

5 May, 2015 Roel van Lisdonk 0 Comments 1 category

If you want to format a string when echoing to the screen, use parentheses. Echo("This is {0} " -f "a test.") Will output: This is a test. Note http://stackoverflow.com/questions/17623644/what-is-the-difference-between-echo-and-write-host-in-powershell echo is an alias

ASP .NET MVC4 / Web Api – Create users and roles for SimpleMembershipProvider with PowerShell and C#

15 April, 2013 Roel van Lisdonk 0 Comments 1 category

If you are using the SimpleMembershipProvider for FormAuthentication in a ASP .NET MVC4 / Web Api project, the following PowerShell / C# code can be used to create and delete users and roles. Create an

How to create an object from a C# *.cs file in PowerShell 3.0 and call a function on it.

26 February, 2013 Roel van Lisdonk 0 Comments 1 category

If you want to create an object based on the C# code in a *.cs file, by using PowerShell 3.0 you can use the following C# and PowerShell code: Create a folder "C:\Temp"

Run PowerShell or batch file remotely

8 February, 2013 Roel van Lisdonk 0 Comments 1 category

To configure Windows PowerShell to receive remote commands in DEV http://www.howtogeek.com/117192/how-to-run-powershell-commands-on-remote-computers/ Start Windows PowerShell with the "Run as administrator" option. On server: enable-psremoting On server: Set-ExecutionPolicy Unrestricted On server: Set-Item wsman:\localhost\client\trustedhosts * (allows any

How to start a process / application on an other computer from C#, by using PowerShell remoting

19 November, 2012 Roel van Lisdonk 3 Comments 1 category

You van execute a process on an other machine from C#, by using the code below: Example for calling the function var rc = new RemotingComponent(null); rc.RunRemoteProcess ( @"MyMachine1", "MyMachine1\Administrator", "MyPassword1", @"C:\Windows\System32\notepad.exe", string.Empty

Using C# in PowerShell to move files

29 December, 2010 Roel van Lisdonk 0 Comments 1 category

Screedump form Windows PowerShell ISE Code $source = @" using System; using System.Collections.Generic; using System.Text; using System.IO; namespace Rvl.Demo.Common { public class MoveFiles { public static void Move()

Tag: PowerShell