SoapUI

https://www.soapui.org/ https://www.soapui.org/downloads/latest-release/ Example: SoapUI 5.7.1 File -> New SOAP Project Project Name: xxxxxxxxx Initial WSDL: http://xxxxxxxxx:1234/?wsdl

SQL Server Upgrade from 2014 to 2022

https://learn.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades-2022?view=sql-server-ver16 https://sqlserverbuilds.blogspot.com/2014/01/sql-server-2014-versions.html Upgrades from earlier versions to SQL Server 2022 SQL Server 2022 (16.x) supports upgrade from the following versions of SQL Server: SQL Server 2012 (11.x) SP4 or later SQL Server 2014 (12.x) SP3 or later SQL Server 2016 (13.x) SP3 or later SQL Server 2017 (14.x) SQL Server 2019 (15.x) Note: Need to... » read more

login failed for user ‘server name\sql server instance$’. reason: could not find a login matching the name provided. [client: ]

Error: Login failed for user ‘DomainName\ServerName$’. Reason: Could not find a login matching the name provided. [CLIENT: <local machine>] Possible Causes: User application that is accessing this database is running under the default Windows service account. Check the user application in Services and make sure it is running under a specific service account and not... » read more

Pair AirPods with a non-Apple device

To set up your AirPods with an Android phone or other non-Apple device, follow these steps: On your non-Apple device, make sure that Bluetooth is on (on an Android device, go to Settings > Connections > Bluetooth). Do one of the following: AirPods (all generations) or AirPods Pro (all generations): With your AirPods in the charging case, open... » read more

Database Index Size

Note: Column with varchar(max) column type will take up a lot of space and take longer to create. More columns the index cover (include), the more index space it will take up. The Non-cluster Index can use up as much space as Clustered Index if the Non-cluster index includes all the columns in the table.... » read more

Slow DELETEs

Issue: Single row delete should not take 2 minutes to complete Cause: Looking at execution plan, a lot of processing on a different table with foreign key link to updating table. Foreign keys are constraints in the database to ensure that data values used in child table entry are present in a parent, reference table.... » read more

How to bring reverting/in recovery secondary db back online after failover

Issue: Secondary Database stuck in “Reverting/In Recovery” after Failover. Resolution: The only way to fix is by restarting the secondary machine, it then will kill the system process which was locking the master db.  Sources: https://learn.microsoft.com/en-us/answers/questions/138501/how-to-bring-reverting-in-recovery-secondary-db-ba