Using Powershell to Remove Files via SQL Job
In SQL Job, create the following step Type: PowerShell Run as: SQL Server Agent Service Account Command:
CTRL + ALT + DEL On Remote Desktop
How do I Ctrl Alt Delete in Remote Desktop? CTRL + ALT + END Now on your host machine (A), press and hold the CTRL and ALT keys on your physical keyboard and then press the DEL key on the on-screen keyboard. That’s one way to do it. You can also open the on-screen keyboard on computer B and then type CTRL + ALT + END, which... » read more
Extend Timeout on Windows Failover Cluster Manager
Windows -> Server Manager -> Tools -> Failover Cluster Manager -> Roles -> Select Role -> Other Resources -> Select Resources -> Properties -> Properties tab “Lease Timeout” field – default to 20000 (20 seconds) “HealthCheck Timeout” field – default to 30000 (30 seconds) Note: There is also a timeout in the Availability Group setup... » read more
Windows Failover Cluster Manager and SQL Server AlwaysOn High Availability
Setup: Windows Failover Cluster Manager (Windows) SQL Server AlwaysOn High Availability (SQL Server) The two different applications goes hand in hand. Note: Failover Cluster Manager (Windows) override AlwaysOn High Availability (SQL Server). Timeout setup in both Failover Cluster Manager and Always On High Availability.
Restart IIS
Go to command prompt in Admin mode. C:\WINDOWS\system32>iisreset
Computer Name and Info on Windows
In Windows search, type in “Computer Name” and then click on “View your PC name”. An app should open with all the information about your PC.
Creating new IIS web application from IIS Manager.
Open up the “Internet Information Services (IIS) Manager” application. Server -> Sites -> Add Website Input “Site name”. Leave application pool to DefaultAppPool. Input “Physical path” to point to your web application root folder. Input “Port” number.
Install and Uninstall Service Host
Scripts for installing and uninstalling service host on Windows machine. Need to reinstall every time the service is modified and recompiled. Make sure ServiceHost is setup atc:\AbcService\AbcServiceHost.exe InstallService.bat May need to modify the app.config to point the database connection to your database. UninstallService.bat Note: Once the service is installed, you don’t have to uninstall and... » read more
Windows Failover Cluster Manager
Microsoft Failover Cluster Manager (MSFCM) is a specific management function within the Windows Server operating system which is used to create, validate, and manage failover server clusters running Windows Server. A failover cluster is a collection of individual physical servers — or nodes — organized into a group capable of sharing the computing workload of an application.... » read more