Microsoft Distributed Transaction Coordinator (MSDTC)

MSDTC is an acronym for Microsoft Distributed Transaction Coordinator. As the name says, MSDTC is a Windows service providing transaction infrastructure for distributed systems. In this case, a transaction means a general way of structuring the interactions between autonomous agents in a distributed system. The Microsoft Distributed Transaction Coordinator service is a component of modern versions of... » read more

PowerShell

PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language. Can be run as Jobs in SQL Server. Example Remove all files greater than a certain date. PowerShell Commands Here are 25 basic PowerShell commands: Command name Alias Description Set-Location cd, chdir, sl Sets the... » read more

Memory Pages Per Second

Pages/sec is the rate at which pages are read from or written to disk to resolve hard page faults. Memory: Pages/sec A high rate for the Pages/sec counter could indicate excessive paging. Memory: Page Faults/sec Monitor the Memory: Page Faults/sec counter to make sure that the disk activity is not caused by paging. Page Faults/sec is the... » read more

Windows Performance Monitor

Setup Monitor Data Collector Sets -> New Be sure to “Start” to start recording. Note: Data file will be updated and accessible once the job has been stopped.

Installing Services Application

Command Line Make sure you open up Command Prompt and run in administrator mode. App should now appear in Services. App should now be removed from Services. Batch File InstallMyAppAsService.bat UninstallMyAppAsService.bat Sources: https://docs.microsoft.com/en-us/dotnet/framework/tools/installutil-exe-installer-tool

FileZilla FTP Client

The free FTP solution for both client and server. Filezilla is open source software distributed free of charge. https://filezilla-project.org/

BitVise SFTP Server

We specialize in secure remote access software for Windows. Our main products are Bitvise SSH Server and SSH Client, which we try to make the best SSH client and server for Windows. https://www.bitvise.com/

WinSCP

WinSCP is a free and open-source SFTP, FTP, WebDAV, Amazon S3 and SCP client for Microsoft Windows. Its main function is secure file transfer between a local and a remote computer.  WinSCP is a popular SFTP client and FTP client for Microsoft Windows! Copy file between a local computer and remote servers using FTP, FTPS,... » read more

Run SSMS Under A Different Domain

SQL Server Management Studio interface will prevent you from using domain other than the one you are currently login as. To use another domain, use a .bat file runas. SSMS Profiler