Useful tips for everyday
How do you check connectivity between pods in Kubernetes? To find the cluster IP address of a Kubernetes pod, use the kubectl get pod command…
When to use include role statement in Ansible? May be used only where Ansible tasks are allowed – inside pre_tasks, tasks, or post_tasks play objects,…
How pagination is implemented in database? Step 1: call the database and retrieve the total no of records. Select count(*) from employee_db; Note: You can…
How do you tell if SQL trigger is firing? To test if a trigger fires you can add a PRINT statement to the trigger (e.g.…
Can I use with AS in MySQL? MySQL prior to version 8.0 doesn’t support the WITH clause (CTE in SQL Server parlance; Subquery Factoring in…
Can I use join in same table? A self join allows you to join a table to itself. It is useful for querying hierarchical data…
Which operators has only one operand? This article is written like a manual or guidebook. In mathematics, a unary operation is an operation with only…
How do I make SQL not return null values? You should use is null (or is not null ) to filter null values. If you…
How is merge replication implemented in SQL Server? Merge replication is implemented by the SQL Server Snapshot Agent and Merge Agent. If the publication is…
What is log sequence number? A log sequence number (LSN) represents the offset, in bytes, of a log record from the beginning of a database…