jfperry
  • About
  • Database Administrator Consultants

Daily Archives: February 2, 2014

You are browsing the site archives by date.

Understanding PowerShell’s Profile files

February 2, 2014 4:15 pm \ by John Perry

Start here.

Windows Powershell – console

PS C:UsersJohn> $PSHome
C:WindowsSystem32WindowsPowerShellv1.0

Windows Powershell (x86) – console

PS E:MSSQLPS> $PSHome
C:WindowsSysWOW64WindowsPowerShellv1.0

PowerGUI

  • Deciding Between One or Multiple PowerShell Profiles

Other questions:

  • Powershell issue – 32-bit vs 64-bit
Posted in: PowerShell

How to unblock PS1 files e.g. from a Zip file

February 2, 2014 3:46 pm \ by John Perry

If you have PS 3.0 + you can use Unblock-File.

If you have PS 2.0 use Andy’s function in Unblocking Files with PowerShell.

Posted in: PowerShell

Categories

Backups Coding Configuration Documentation DOS ERRORs ETL ETL Excel Files HTML MAC master_admin Performance Permissions PowerShell Reports Services SQL SQLAgent SQL Server SSIS Uncategorized WEB Windows

Archives

February 2014
S M T W T F S
 1
2345678
9101112131415
16171819202122
232425262728  
« Jan   Mar »

Recent Posts

  • SQL: Last backups for all databases
  • SQL Agent: Use a batch file to run RoboCopy
  • DOS: For each file greater than date time run Command
  • SSMS: Ctrl-E ^E stops executing query
  • PowerShell: Remove brackets from all file names in folder

Tags

Audit Debugging Lesson Setup

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Pages

  • About
  • Database Administrator Consultants

Archives

  • December 2019
  • October 2019
  • August 2019
  • May 2019
  • April 2019
  • March 2019
  • February 2019
  • August 2018
  • July 2018
  • May 2018
  • April 2018
  • March 2018
  • January 2018
  • October 2017
  • September 2017
  • July 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • August 2016
  • July 2016
  • May 2016
  • April 2016
  • March 2016
  • February 2016
  • January 2016
  • December 2015
  • November 2015
  • July 2015
  • May 2015
  • March 2015
  • February 2015
  • January 2015
  • December 2014
  • November 2014
  • October 2014
  • August 2014
  • May 2014
  • April 2014
  • March 2014
  • February 2014
  • January 2014
  • November 2013
  • July 2013
  • April 2013
  • March 2013
  • January 2011
  • October 2010
  • August 2010
  • July 2010
  • May 2010
  • March 2010
  • February 2010
  • December 2009
  • September 2009
  • July 2009
  • June 2009
  • May 2009
  • April 2009
  • March 2009
  • February 2009
  • January 2009
  • November 2008
  • October 2008
  • September 2008
  • August 2008
  • July 2008
  • February 2008
  • January 2008
  • October 2007
  • September 2007
  • July 2007
  • June 2007

Pages

  • About
  • Database Administrator Consultants

Categories

  • Backups
  • Coding
  • Configuration
  • Documentation
  • DOS
  • ERRORs
  • ETL
  • ETL
  • Excel
  • Files
  • HTML
  • MAC
  • master_admin
  • Performance
  • Permissions
  • PowerShell
  • Reports
  • Services
  • SQL
  • SQL Server
  • SQLAgent
  • SSIS
  • Uncategorized
  • WEB
  • Windows

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
© Copyright 2025 - jfperry
Prana Theme ⋅ Powered by WordPress