Useful tips for everyday
How do I audit folder permissions? Select and hold (or right-click) the file or folder that you want to audit, select Properties, and then select…
How do I enable MariaDB log? The General Query Log can be enabled dynamically with the following command: SQL> SET GLOBAL general_log = 1; and…
How do I find the table name in MariaDB? Columns database_name – name of the database (schema) where the table was found. table_name – name…
How do I create an alias for a named SQL Server instance? To create an alias In SQL Server Configuration Manager, expand SQL Server Native…
How do I make an Excel spreadsheet accessable from multiple users? Set up a shared workbook Click the Review tab. Click Share Workbook in the…
How does MongoDB connect to SSL? Connect to MongoDB Instance Using Encryption ( tls Options) For procedures using their ssl aliases, see mongosh Configuration (Using…
How do I find multiple ids in SQL? [SQL] how to SELECT multiple IDS from a table? SELECT id,name from mytable WHERE ( id=’1′ OR…
What are SQL Server pages? The page is the fundamental unit of data storage in SQL Server. An extent is a collection of eight physically…
How do you create a new column in SQL? The basic syntax for adding a new column is as follows: ALTER TABLE table_name ADD column_name…
Can you run multiple SQL queries at once? You can include multiple SQL statements on the SQL query panel. The exceptions are CALL and CREATE…