cviorel.com | Page 2

Register-PSRepository fails on Powershell Core when running behind a corporate proxy

Posted by cviorel on April 17, 2020 2 comments | This post has 35,091 views.

Trying to register a psrepository behind a corporate proxy fails on Powershell Core.

$credential = Get-Credential
$uri = 'https://localhost:8080/artifactory/api/nuget/custom_repository'
$repoParams = @{
    Name                      = 'custom_repository'
    SourceLocation            = $uri
    PublishLocation           = $uri
    InstallationPolicy        = 'Trusted'
    PackageManagementProvider = 'NuGet'
    Verbose                   = $true
}
Register-PSRepository @repoParams -Credential $credential

1

2

3

4

5

6

7

8

9

10

11

$credential = Get-Credential

$uri = 'https://localhost:8080/artifactory/api/nuget/custom_repository'

$repoParams = @{

Name = 'custom_repository'

SourceLocation = $uri

PublishLocation = $uri

InstallationPolicy = 'Trusted'

PackageManagementProvider = 'NuGet'

Verbose = $true

}

Register-PSRepository @repoParams -Credential $credential

The error you receive is:

Register-PSRepository: The specified Uri 'https://localhost:8080/artifactory/api/nuget/custom_repository' for parameter 'SourceLocation' is an invalid Web Uri. Please ensure that it meets the Web Uri requirements.

1	Register-PSRepository: The specified Uri 'https://localhost:8080/artifactory/api/nuget/custom_repository' for parameter 'SourceLocation' is an invalid Web Uri. Please ensure that it meets the Web Uri requirements.

Running the same on Windows Powershell 5.1 works.
Now, let see why it’s not working on Powershell Core.

Trying to find more details about the […] Continue Reading…

Block Chrome Software Reporter Tool

Posted by cviorel on April 16, 2020 No comments | This post has 27,831 views.

Use the following PowerShell Snippet to disable Chrome Software Reporter Tool from eating your CPU cycles:

Set-ItemProperty 'HKLM:\SOFTWARE\Policies\Google\Chrome' `
    -Name ChromeCleanupEnabled -Value 0
Set-ItemProperty 'HKLM:\SOFTWARE\Policies\Google\Chrome' `
    -Name ChromeCleanupReportingEnabled -Value 0

1

2

3

4

Set-ItemProperty 'HKLM:\SOFTWARE\Policies\Google\Chrome' `

-Name ChromeCleanupEnabled -Value 0

Set-ItemProperty 'HKLM:\SOFTWARE\Policies\Google\Chrome' `

-Name ChromeCleanupReportingEnabled -Value 0

ChromeCleanupEnabled’s value determines whether the Software Reporter Tool may run on the system.

ChromeCleanupReportingEnabled’s value determines whether the results are reported to Google.

Enable transmission-daemon logging to file

Posted by cviorel on October 26, 2018 3 comments | This post has 35,782 views.

If you use transmission-daemon on your Raspberry Pi and want to have logs to a file, you can follow a few simple steps to accomplish this:

Edit the service file:

sudo vim /lib/systemd/system/transmission-daemon.service

1	sudo vim /lib/systemd/system/transmission-daemon.service

Change the ExecStart line to look like this:

ExecStart=/usr/bin/transmission-daemon -f --log-debug --logfile /var/log/transmission.log

1	ExecStart=/usr/bin/transmission-daemon -f --log-debug --logfile /var/log/transmission.log

You can choose between […] Continue Reading…

dbatools – fully automated offsite backups, database restores and integrity checks

Posted by cviorel on November 14, 2017 No comments | This post has 730 views.

In this article you’ll find the process I implemented to test my backups using dbatools and PowerShell.
dbatools is a free PowerShell module with over 200 SQL Server administration, best practice and migration commands included.
Backed up by a community of […] Continue Reading…

How to Change your Network Profile in Server 2012R2

Posted by cviorel on June 23, 2017 No comments | This post has 638 views.

Network Profiles were first introduced to allow administrators to configure different firewall profiles based upon what network a user connects to.
Administrators could change the profile by navigating to Network and Sharing Center in control panel and selecting the […] Continue Reading…

Get SMO version on your server

Posted by cviorel on May 30, 2017 No comments | This post has 762 views.

A quick way to find out what SMO versions are installed:

dir C:\Windows\assembly\GAC_MSIL\Microsoft.SqlServer.Smo

1	dir C:\Windows\assembly\GAC_MSIL\Microsoft.SqlServer.Smo

Silently Download and Install SQL Server Management Studio (SSMS)

Posted by cviorel on January 27, 2017 4 comments | This post has 1,747 views.

SSMS is now free and no longer requiring licensing.
It is a separate install and has a more frequent release cycle, usually around 30 days.
To be able to maintain up to date a larger number of SSMS installations I wrote […] Continue Reading…

Add syntax color to crontab editor

Posted by cviorel on February 24, 2016 No comments | This post has 1,440 views.

You might be wondering why you don’t have syntax coloring when you are editing crontab entries.
This can be solved very simply by specifying your editor before starting crontab:

export EDITOR=vim

1	export EDITOR=vim

The change can be made persistent across the whole system if you […] Continue Reading…

DTExec: The package execution returned DTSER_FAILURE (1)

Posted by cviorel on September 11, 2014 No comments | This post has 1,011 views.

What to do when a SQL backup job created with SQL server Maintenance Plans fails with this error?

DTExec: The package execution returned DTSER_FAILURE (1).

1	DTExec: The package execution returned DTSER_FAILURE (1).

Investigate! No useful information in the logs.
Previously that day I dropped a few unneeded databases so maybe the Maintenance Plan was still […] Continue Reading…

T-SQL to generate backup and restore commands

Posted by cviorel on August 29, 2014 No comments | This post has 620 views.

Hi guys,

Since my day to day job is a DBA, I figured I will share stuff that others might find useful.
For the first time I will share a small script which will help you generate T-SQL commands in order […] Continue Reading…

Social

Categories

Tags