Useful tips for everyday
How do I authenticate to Kubernetes API server? Authentication strategies. Kubernetes uses client certificates, bearer tokens, an authenticating proxy, or HTTP basic auth to authenticate…
How do I open a backup file in SSMS? bak file using SQL Server Management Studio (SSMS) you must do the following steps. On the…
How do I limit a concurrent connection? Using SQL Server Management Studio Click the Connections node. Under Connections, in the Max number of concurrent connections…
Is autocommit faster? If you are not using stored procedures or triggers, turn off autocommit. All transaction levels operate faster with autocommit turned off, and…
Can a view be indexed in SQL Server? An indexed view has a unique clustered index. The unique clustered index is stored in SQL Server…
How do I move a DB2 database to another drive? Answer Confirm the current database path. Command: db2 list db directory. Confirm the current db…
How do you capitalize in SSMS? Select all of your query. Then go to Edit > Advanced > Make Uppercase or simply hit Ctrl+Shift+U to…
How do you check if a value is in another column? Example using VLOOKUP Select cell C2 by clicking on it. Insert the formula in…
How do you get an app name? Inspect the URL and copy the Android app name. The name appears after id= and before &hl ….Find…
What is retention period in AWS RDS? Amazon RDS retains backups of a DB Instance for a limited, user-specified period of time called the retention…