As part of the services we provide our clients around Microsoft SQL Server we also provide a service that uploads database backup files to Amazon S3 or Azure Blob Storage (applies for On Premise servers). This option is really great and gives you lots of confidence letting you sleep better at nights. it had already …
Download files from Amazon s3 to local folder using Powershell Read More »
In this post I will share how to use the SqlCredential object with Powershell when using SQL Authentication in order to pass the password in a secured way connecting to an instance of SQL Server. First step is a one time step creating a secured encrypted password saved in a text file that we latter …
Use SqlCredential with Powershell to connect to an instance of SQL Server Read More »
When installing a Windows Service remotely as a “Local Service” there are no credentials involved and this is a pretty straight forward task. But if you need to have the service installed under the account of a local user or a domain user then this is somewhat tricky. The security credentials you create using the …
Use PowerShell to Install a Windows Service remotely Read More »
