.NETADO.NETAgileAngularArchitectureASP.NETAuthenticationAzureAzure FunctionBIBig DataBlazorBusinessC#Cloud ServiceCosmosDBCSSDebuggingDesignEncryptionEntity FrameworkFYIGoogleHardwareInternetInterviewsJavascriptjQueryLeadershipLINQManagementMicrosoftMobileMS OfficeMS SQLNetworkingNoSQLOOPProject ManagementSoftware DevelopmentSource ControlSSISSSRSSyncfusionTeamTestingTSQLUncategorizedVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress
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
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
Error: Getting the following error when trying to bring the database back online. User does not have permission to alter database 'xxxxxx', the database does not exist, or the database is not in a state that allows access checks. -- Database is "RECOVERING" user_access_desc is_read_only state_desc is_in_standby MULTI_USER 0 RECOVERING 0 Resolution: Wait for database... » read more
Press and hold the crown and the button above it until the Google Logo appears.
Issue: SSMS takes a long time to open up connection for each new query window. This applies to all other applications that connects to the database as well. Fix: Disable The Publisher Certificate Check Part of the SSMS start-up routine involves connecting to the Microsoft website to check a certificate list. You can disable this... » read more
Active Directory Need to create 2 AD objects. Cluster Host Listener Host Object needs to be… In the same AD folder. Add self, cluster, all customer hosts to the security tab with full control. Set the object to “Inactive” state. Inactive account. IP address will be enterer in at setup time. No need to add... » read more
Usually the DB engine should automatically select the index to use based on query execution plans it builds. However, there are some pretty rare cases when you want to force the DB to use a specific index.
https://learn.microsoft.com/en-us/sql/t-sql/statements/set-lock-timeout-transact-sql?view=sql-server-ver16 Specifies the number of milliseconds a statement waits for a lock to be released.
Issue: “Security” tab is not visible in the object properties window of Active Directory Users and Computers Resolution: Make sure the following is checked… View -> Advanced Features