.NETADO.NETAgileAngularArchitectureASP.NETAuthenticationAzureAzure FunctionBIBig DataBlazorBusinessC#Cloud ServiceCosmosDBCSSDebuggingDesignEncryptionEntity FrameworkFYIGoogleHardwareInternetInterviewsJavascriptjQueryLeadershipLINQManagementMicrosoftMobileMS OfficeMS SQLNetworkingNoSQLOOPProject ManagementSoftware DevelopmentSource ControlSSISSSRSSyncfusionTeamTestingTSQLUncategorizedVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress
CTRL + ALT + DEL On Remote Desktop
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
sp_helptext
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
Extend Timeout on Windows Failover Cluster Manager
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
Extend Timeout for SQL Server AlwaysOn High Availability
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.
Windows Failover Cluster Manager and SQL Server AlwaysOn High Availability
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.
SQL Server Collation
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
Hexadecimal Numbers
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
Binary Numbers
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