Useful tips for everyday
How do I restrict user in PostgreSQL? How to Limit Access to Database in PostgreSQL Create Role. Log into PostgreSQL and run the following command…
How do you save the result of a SQL query into a variable? To store query result in one or more variables, you use the…
What is XML data type in SQL? The xml data type is a built-in data type in SQL Server and is somewhat similar to other…
How do I remove a node from Kubernetes cluster? Remove a Kubernetes Node Log in to the Kubernetes Node that you want to remove. Stop…
How do you manage linked tables? Refresh a data source and its linked tables Select External Data > Linked Table Manager. In the Linked Table…
How do I connect SQL Management Studio to Azure Database? Steps to Connect SSMS to SQL Azure Authenticate to the Azure Portal. Click on SQL…
How do I run a very large .sql file? How to execute large SQL scripts The osql command line utility that comes with SQL Server:…
What version of Windows is server 2012? Windows Server 2012 is an operating system built by Microsoft and is the successor of Windows Server 2008…
Is it good idea to store files in database? Reasons in favor of storing files in the database: Having the files and database in sync…
What is authentication database in MongoDB? In MongoDB Authentication Database is: “When adding a user, you create the user in a specific database. This database…