Home

Download files with PowerShell

• 3 Ways to download files with powershell
  • https://blog.jourdant.me/3-ways-to-download-files-with-powershell/
• Download file with PowerShell
  • https://teusje.wordpress.com/2011/02/19/download-file-with-powershell/

Building a Daily Systems Report Email With PowerShell

• https://www.simple-talk.com/sysadmin/powershell/building-a-daily-systems-report-email-with-powershell/

Reading and parsing CSV

• http://www.heikniemi.net/hardcoded/2010/01/powershell-basics-1-reading-and-parsing-csv/

List of one-liner Powershell commands

• https://www.simple-talk.com/sysadmin/powershell/powershell-one-liners-variables,-parameters,-properties,-and-objects/

Accepting Command Line Parameters

• https://technet.microsoft.com/en-us/magazine/jj554301.aspx

Running SQLPS in normal PS window

• Copy to clipboard

  Add-PSSnapin SqlServerCmdletSnapin100
  Add-PSSnapin SqlServerProviderSnapin100

• http://stackoverflow.com/questions/33172754/powershell-invoke-sqlcmd-and-sqlps

Getting data in and out of SQL Server

• https://blogs.technet.microsoft.com/heyscriptingguy/2010/11/01/use-powershell-to-collect-server-data-and-write-to-sql/

Issues

• Could not load file or assembly 'Microsoft.SqlServer.BatchParser
  • Error message when you run a 32-bit version of SQL Server 2008 on an Itanium-based version of Windows
    • https://support.microsoft.com/en-us/kb/956178
  • Might be the SQL Server is 32bit and the Windows is 64bit.
    • https://social.msdn.microsoft.com/Forums/sqlserver/en-US/4d682289-9e06-4dd3-aff3-d08ad437896d/file-or-assembly-microsoftsqlserverbatchparser-error?forum=sqldatabaseengine
  • Microsoft SQL Server 2008 Service Pack 3 Feature Pack
    • https://www.microsoft.com/en-us/download/details.aspx?id=27596