Powershell

• Topics

  Started by

  Posts

  Last post

• Get latest build from sqlserverbuilds.blogspot.com

  I needed a method to test whether all my SQL servers were patched, so I created a script that reads…

  ildjarn.is.dead

  1 replies

  4 years, 3 months ago

  By: ildjarn.is.dead

• Ransomware trojan enters via Powershell script contained in Word macros

  It's translated from a German security researcher web page, so it isn't easy to read but it is impo…

  Wayne West

  5 replies

  4 years, 4 months ago

  By: Jeff Moden

• Loading large JSON file into a Data Table to Bulk Copy into SQL Server Table

  We have a JSON file with 10M records to bulk copy load into a SQL Server table. The Powershell code…

  sadie

  4 replies

  4 years, 4 months ago

  By: frederico_fonseca

• Export table to csv including varbinary datatype

  I'm exporting all tables in a databases to individual csv files using the code below and it's worki…

  ReamerXXVI

  3 replies

  4 years, 4 months ago

  By: Ken McKelvey

• double check if file exists in S3 bucket directory

  Hello, I did google this, and not sure if I am doing it right or maybe just missing one minor thing…

  Siten0308

  2 replies

  4 years, 4 months ago

  By: Siten0308

• Refresh Power BI Report Server Dataset with Powershell and SQL Agent

  Hi, I have had the below script running for approx 12 months and after a power BI Upgrade on Friday…

  david_h_edmonds

  2 replies

  4 years, 4 months ago

  By: david_h_edmonds

• SSAS - wrong information from sqlserver module

  Dear fellow DBAs I use powershell sqlserver module to collect information about SSAS. I realized th…

  iz

  1 replies

  4 years, 5 months ago

  By: iz

• ftp script to upload files

  Does anyone have a ftp upload script they could share that has the following requirements. 1) Promp…

  Bruin

  8 replies

  4 years, 5 months ago

  By: Bruin

• Powershell syntax error in SQL server Agent job

  Hi, I am running below code, running fine in PS terminal and ISE.  When I am running it from SQL ag…

  sdbjakeer

  3 replies

  4 years, 6 months ago

  By: Jeffrey Williams

• PS script works in ISE but fails in SQL JOB step with a syntax error

  I need to copy a subset of rows from a table on a (sql2016) server, to a table on a (sql2008r2) ser…

  mstjean

  6 replies

  4 years, 6 months ago

  By: Jeffrey Williams

• Using powershell to strip RTF tags and return text.

  Hi, We've been looking to pull the text from a table in a vendor DB that stores in RTF format. I fo…

  PretendDBA

  2 replies

  4 years, 6 months ago

  By: PretendDBA

• Get data from last line and merge into data stream before removing

  This script reads thru a file and removes the last line, but before it does that can I grab a value…

  Bruin

  3 replies

  4 years, 7 months ago

  By: Bruin

• Server Documentation

  I'm looking for a powershell script to gather the following information from my server that has mul…

  rr_littletons

  1 replies

  4 years, 7 months ago

  By: rr_littletons

• Find Sheet name if Not exist stop and email issue

  I have a process that uses an xcel file and looks for the default Sheet1. There are times when some…

  Bruin

  4 replies

  4 years, 7 months ago

  By: Bruin

• when use dbachecks, it has error: unable to find type [Pester.outputtypes]

  hi there: When I type invoke-dbcCheck, it pops up error below: Unable to find type [Pester.otuputTy…

  huishi.ca

  1 replies

  4 years, 7 months ago

  By: Ant-Green