Powershell

• Topics

  Started by

  Posts

  Last post

• Powershell script multiple output into SSIS variables

  Hi Guys, How can I store multiple output results from Powershell to variables in SSIS? Thanks. …

  rocky_498

  4 replies

  4 years, 10 months ago

  By: rocky_498

• Scanning to find sql instances/servers

  We use MAPS tool to scan through our domain and then list out our sql servers/instances. How can th…

  mtz676

  1 replies

  4 years, 10 months ago

  By: Michael L John

• How to check if the file exists in S3 bucket.

  Hi, I am trying to build a script to copy sql backups to an S3 bucket.  The structure of the folder…

  Roust_m

  7 replies

  5 years ago

  By: Steve Jones - SSC Editor

• remove lines from flat file with no header

  I have a file that has a delimiter of bar (|) and has no headers. I need a way to remove bad data r…

  Bruin

  4 replies

  5 years ago

  By: Jeffrey Williams

• Need Powershell script to change SQL Server service password

  Need sample Powershell script to change PWDS for SQL Server services (on many SQL Servers). We need…

  Express12

  1 replies

  5 years ago

  By: frederico_fonseca

• Remove-Item quirks

  I am trying to write a script in Powerhsell to run in SQL Agent to maintain a backup archive.  We w…

  dan-572483

  3 replies

  5 years ago

  By: Mr. Brian Gale

• run mssql stored procedure from PS script and capture output

  Can someone share a PS script that will execute a mssql stored procedure and capture all of the out…

  Bruin

  11 replies

  5 years, 1 month ago

  By: frederico_fonseca

• copy file from sharepoint site to Azure storage

  I'm looking to transfer files from sharepoint site to Azure storage. I cannot use Logic apps or Flo…

  khushbu

  1 replies

  5 years, 3 months ago

  By: khushbu

• Cleanup Sysmail -items from msdb

  I took over a SQL instance that never did a cleanup of MSDB. The SysmailItems has close to 25gig of…

  Bruin

  29 replies

  5 years, 3 months ago

  By: Bruin

• Using Powershell to run a script to output a script

  I am building a SQL Agent job to automate refreshing a nonproduction database from a backup of Prod…

  dan-572483

  2 replies

  5 years, 4 months ago

  By: Lowell

• create database if not exists

  Good morning all I am looking to create a sql server database if the database does not exist on my …

  abdalah.mehdoini

  1 replies

  5 years, 4 months ago

  By: John Mitchell-245523

• powershell with sql server help

  Hi All, I wanted to load windows application log into sql server table. I am using below command bu…

  vsamantha35

  5 replies

  5 years, 5 months ago

  By: Ken McKelvey

• Script to validate credentials then start a program

  Hello, I am trying to compile a script to validate users credentials via a.d and then once validate…

  barios

  1 replies

  5 years, 6 months ago

  By: barios

• Finding specific file with dynamic date

  I need to find a file with a specific date in it. The problem is I never know what the date will be…

  Brandie Tarvin

  8 replies

  5 years, 6 months ago

  By: Brandie Tarvin

• multi invoke-sqlcmd in foreach

  Good morning all I'm looking to replace all these invoke-sqlcmd in one through a foreach loop Who h…

  samirca007

  1 replies

  5 years, 6 months ago

  By: samirca007