Useful tips for everyday
How do I push Docker images to GCR? Pull the busybox image from Docker Hub. Tag the image with its target path in Container Registry,…
Can stored procedures be used as security layer? Stored Procedures can also act as an additional security layer. We pass data as a parameter in…
What does set Serveroutput on do? Basically the use of SET SERVEROUTPUT is to display the query answer in SQL *PLUS interface… When you use…
How can I check connection between server and client? For the ping test, perform a ping using both the machine name and the IP address.…
How do I create a messaging system? 3. Key Steps To Develop A Messaging App Plan the App Structure. Choose Right App Monetization Model. Integrating…
How do you split a Database backup? Creating split backup files with SQL Server Management Studio Open the Object Explorer, expand the Databases node, and…
How do I sum a column depending on another column? In the opening Combine Rows Based on Column dialog box, you need to: (1) Select…
How to check invalid synonyms in oracle? You can check whether the table exists by joining on ALL_TABLES (a synonym might not be on a…
How do I upgrade SQL Server version? Edition Upgrade in SQL Server Locate the Setup.exe and launch the SQL Server Installer for the version that…
How to get current month all date in sql? SQL current month is retrieved using the functions available in SQL that are related to date…