.NETADO.NETAgileAngularArchitectureASP.NETAuthenticationAzureAzure FunctionBIBig DataBlazorBusinessC#Cloud ServiceCosmosDBCSSDebuggingDesignEncryptionEntity FrameworkFYIGoogleHardwareInternetInterviewsJavascriptjQueryLeadershipLINQManagementMicrosoftMobileMS OfficeMS SQLNetworkingNoSQLOOPProject ManagementSoftware DevelopmentSource ControlSSISSSRSSyncfusionTeamTestingTSQLUncategorizedVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress
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
The sp_helptext is a system stored procedure that is used to view the text definition of any SQL Server objects that contain code. It can be used for unencrypted user-defined stored procedures, functions, views, triggers, even system objects such as system stored procedures. sp_helptext uspMyProcedureName
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
Microsoft SQL Server Management Studio (SSMS) -> Server -> Always On Hight Availability -> Properties Session Timeout (seconds) field Note: Default to 20 seconds. The timeout setting in Windows Failover Cluster will override setting in the AlwaysOn Availability Group setting.
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.
A collation is a configuration setting that determines how the database engine should treat character data at the server, database, or column level. … In SQL Server, you can configure a character column with a Unicode data type (nchar, nvarchar, or ntext) or non-Unicode data type (char, varchar, or text). Collation is a set of rules dictating how... » read more
Decimal Hexadecimal 0 0 1 1 2 2 3 3 4 4 5 5 6 6 7 7 8 8 9 9 10 A 11 B 12 C 13 D 14 E 15 F
Decimal Binary 0 0000 1 0001 2 0010 3 0011 4 0100 5 0101 6 0110 7 0111 8 1000 9 1001 10 1010 11 1011 12 1100 13 1101 14 1110 15 1111
Record the number of rows affects in the last transaction.