Tags » PowerShell

Removing unneeded software updates from SCCM

Happy Friday everyone,  I can’t take any credit at all for this one but someone (much better at Powershell than me) has wrote this amazing script on removing updates that are not deployed or not required on any machines but are still in a deployment package. 26 more words

SCCM

Automating #Azure VM stop and start

This is an old topic, but at the same time a big ask for Azure IaaS deployments. It would be great to be able to start and stop Virtual Machines based on a weekly schedule, and let’s add the option to run a specific script before shutdown or after startup. 56 more words

Azure

[PowerShell] Using .Contains with System.Data.DataRow

I realised I hadn’t done a blog post this week and didn’t think I had anything planned, so here is a random PowerShell/SQL Server encounter on Twitter. 427 more words

Sql-server

Install PowerShell Modules on hosted agent in VSTS (Visual Studio Team Services)

Visual Studio Team Services (VSTS) is popular tool of choice for various purposes where product is heavily dependent on Microsoft technologies like .NET, Azure, etc. It does lot of work such as Source code management, Building CI/CD pipelines, Package Management, Agile Issue tracking, etc. 301 more words

PowerShell

Copy and Restore Databases from one SQL Server to another

We wanted to create a development server that mirrored the environment of our production SQL Server 2014 server. We looked at using replication, but we wanted more control over when and how databases were updated. 388 more words

PowerShell

Use PowerShell to Get Local Administrators on a Remote Computer

Obtaining the administrators from a remote computer can be tricky, especially if you are connected to a large Active Directory domain.  Many solutions I’ve seen for this end up looping through all the users on the entire domain.   119 more words

Windows

Installing PowerShell DSC Pull server on a computer that had WSUS previously installed throws HTTP Error 500.19 - Internal Server Error

Detailed Error Information:

Module    DynamicCompressionModule Notification    SendResponse Handler    ExtensionlessUrlHandler-Integrated-4.0 Error Code    0x8007007e

Requested URL    http://localhost:8080/ Physical Path    C:\inetpub\wwwroot\PSDSCPullServer Logon Method    PSDSCAuthentication Logon User    PSDSCUser

Resolution… 117 more words

PowerShell