Install TeamCity agent remotely
To install the TeamCity agent on a remote computer in the TeamCity UI on the Agents page select the Agent Push tab. Make sure the remote computer is accessible by PSEXEC. See Configure the target server for PSEXEC If the remote server is in the domain,…
Configure the target server for PSEXEC
PSEXEC is a remote procedure execution tool written by Mark Russinovich at Microsoft and available for download at https://docs.microsoft.com/en-us/sysinternals/downloads/psexec. To use PSEXEC you need to open ports 135 (TCP) and 445 (TCP) on the target…
Make the GantChart Excel template smarter
There is a great, free Excel Gantt chart template on the Vertex42 web site at https://www.vertex42.com/ExcelTemplates/excel-gantt-chart.html The free version lacks a few features that could make project planning easier. We can update our version of the…
Failed to complete #create action: [You are not authorized to perform this operation
When launching an instance in AWS with Chef Test Kitchen you get the error message >>>>>> Failed to complete #create action: [You are not authorized to perform this operation. Encoded authorization failure message:... Make sure the image does not require…
Download .NET SDKs for Visual Studio
To download the .NET SDKs for application build and deployment navigate to the Download .NET SDKs for Visual Studio Microsoft web site
Microsoft SQL Server database index fragmentation report
When the first row of long running queries is returned after a long initial wait, check the fragmentation of the indexes. On MSSQL execute this query in the database
Map the host drive in a VMware Fusion Windows virtual machine
Every time I start a PowerShell terminal on my Windows VMware Fusion virtual machine I have to map the host drive of my MacBook Pro. I execute this command in PowerShell:
Remove byte-order mark from the beginning of the file
When a file is saved with BOM (byte-order mark) on a Mac or Linux machine Windows PowerShell cannot execute the script. Unfortunately the “cat” command by default does not show the byte-order mark at the beginning of the file. As Oriol stated…
Clear the browser cache for one site in Chrome
Some sites do not load properly when old cached data is stored in the web browser. To clear the cached images, cookies and other site related data for one specific site in Chrome We didn’t use the developer tools, but to be able to see the options…
Find blocking queries in MSSQL
To find queries that block others in Microsoft SQL databases, execute This returns the list of active sessions and indicates what session blocked it. To get the query of a session, execute