.NETADO.NETAgileAngularArchitectureASP.NETAuthenticationAzureAzure FunctionBIBig DataBlazorBusinessC#Cloud ServiceCosmosDBCSSDebuggingDesignEncryptionEntity FrameworkFYIGoogleHardwareInternetInterviewsJavascriptjQueryLeadershipLINQManagementMicrosoftMobileMS OfficeMS SQLNetworkingNoSQLOOPProject ManagementSoftware DevelopmentSource ControlSSISSSRSSyncfusionTeamTestingTSQLUncategorizedVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress
Problem While trying to set up a couple of SQL Enterprise servers in an Availability Group I kept getting the message “The local node is not part of quorum and is therefore unable to process this operation” I had already set up Windows Failover Clustering with a cloud witness for the quorum. and ticked “Enable AlwaysoOn... » read more
Issue: When a server is created via replication, the sql server name might need to be changed. If not, you will see login issues in the database log and unable to see the job history. Resolution: Remember to restart SQL Server to apply the change.
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
Shrink Database (DbccFilesCompact) Database -> Right Click -> Tasks -> Shrink -> Database Example: 3 hrs to Shrink 1,100 GB data file to 296 GB.
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
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
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
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
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