Skip to content

Glenn Pepper

SQL Server Database Administration

Primary Menu
  • Home
  • About
  • Resources
    • GitHub
    • Links
    • Downloads
  • Music
  • Contact

sqlps

SQLPS Error After Upgrading PowerShell

Posted on 9th October 2018 by GPepper

Another Error I thought that was worth blogging about. I upgraded to PowerShell 5.1 and then suddenly the SQLPS module seemed to disappear. When I start PowerShell, the SQLPS module should be automatically loaded but I received the below error. Even manually importing the module wouldn’t work. So I needed Continue Reading

Posted In PowerShellTagged In PowerShell, sqlps, Troubleshooting

SQL PowerShell Profile

Posted on 18th April 201830th September 2018 by GPepper

I’m very much new to using PowerShell in my day-to-day DBA tasks. One thing it took me a while to work out was that i had to import the sqlps module each time I started PowerShell. Then I realized that I could create a new PowerShell profile so that this Continue Reading

Posted In PowerShellTagged In PowerShell, sqlps

Recent

  • Troubleshooting Performance Problems
  • Cluster Quorum PowerShell Commands
  • Creating Fake Data for Testing
  • SSRS Database Migration – Cannot View Subscriptions
  • Automating SQL Installs

Tag Cloud

AlwaysOn Automation Availability Groups Backups BATCH UPDATES Best Practice Best Practices BULK IMPORT Clusters Communication Corruption Disaster Recovery DR Email Execution Plans Foreign Keys HTML Indexes Interviews Migration Monitoring Music Off Topic OPENROWSET PHP Post-Rock PowerShell Processing Quorum Random Rant Reference Restores sp_whoisactive SQL Agent SQLCMD SQL Installations sqlps SQL Security SQL Server SQL Server 2012 T-SQL Troubleshooting UPDATE VARIABLES

Categories

  • Always On Availability Groups
  • Automation
  • Azure
  • Best Practices
  • Disaster Recovery
  • Maintenance
  • Monitoring
  • Music
  • Off-Topic
  • PowerShell
  • SQL Server 2012
  • SQL Server 2014
  • SQL Server 2016
  • T-SQL
  • Troubleshooting
  • Uncategorised
Copyright All rights reserved | Theme: Flash Blog by Unitedtheme.