Hi folks,
The other day I was pulling hair from my head trying to configure a Windows Failover Cluster intended for an SQL Server Availability Group setup.
During the cluster validation stage I always got this message:
The Windows Firewall on node […] Continue Reading…
Managing a lot of SQL servers does not have to to be a burden. One or a hundred, should be the same, right?
This is how you can quickly update (on a bunch of servers) the IndexOptimize job which is […] Continue Reading…
Trying to register a psrepository behind a corporate proxy fails on Powershell Core.
|
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:
|
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…
Use the following PowerShell Snippet to disable Chrome Software Reporter Tool from eating your CPU cycles:
|
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.
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:
|
1 |
sudo vim /lib/systemd/system/transmission-daemon.service |
Change the ExecStart line to look like this:
|
1 |
ExecStart=/usr/bin/transmission-daemon -f --log-debug --logfile /var/log/transmission.log |
You can choose between […] Continue Reading…
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…
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…
A quick way to find out what SMO versions are installed:
|
1 |
dir C:\Windows\assembly\GAC_MSIL\Microsoft.SqlServer.Smo |
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…
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:
|
1 |
export EDITOR=vim |
The change can be made persistent across the whole system if you […] Continue Reading…