ApexSQL Add-in Errors Post-Uninstall

Delete ApexSQL or the particular add-in subfolder. From: 1. C:\Program Files 2. C:\Users\username\AppData\Local\ApexSQL 3. C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\Extensions 4. C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\Extensions 5. C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\Extensions 6. C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\Common7\IDE\Extensions Run cmd as administrator VS2015 "C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\devenv.exe" /setup "C:\Program Files (x86)\Microsoft Visual Studio…

SQL Server 2016 AlwaysOn in Windows Server 2012R2 WFC – MultiSubnet Listener returns wrong IP address after a FlushDNS – Error Connection Timeout!

Issue: (Failover had not occurred, commands executed without pause).   Fixed. Key changes were RegisterAllProvidersIP=0, HostRecordTTL=300 (5 minutes instead of default 1200 (20 minutes)). If using .Net Framework 4.5+, recommend adding to client connection strings: MutiSubnet=True; Ref SqlClient support for HA and DR. Key steps were: Set RegisterAllProvidersIP=0 for the Cluster and LG. Set HostRecordTTL=300 (5 minutes instead of default…

SQL Server Error – Incorrect time syntax in time string used with WAITFOR.

This is a simple one but it doesn't stick until you write/read about it.  Note, I use WAITFOR DELAY to pause/sleep the session between batches or T-SQL commands. For logic reasons, sometimes, I just gotta buy myself a few seconds for one thing to finish, before I start the next one. Ref: Control-of-Flow (lots of goodies…