The size of all tables in the database can be obtained by using a SQL query in the database management system, for example: SQL: MYSQL: PostgreSQL: Note: Replace “database_name” with the name of your database. ORACLE: Note: The above query assumes that you are querying for tables in the user’s schema. If you want to …
How to know the size of all tables in the database Read More »
Here are step-by-step instructions for scheduling a backup of a database in SQL Server Management Studio (SSMS) Step 1: Connect to your SQL Server instance using SSMS. Step 2: Check that if SQL Server Management Studio (SSMS) Agent is disabled then, please turn on SSMS Agent first – Step 3: Now right-click on “Maintenance Plans” …
How to take a scheduled backup of a database in SQL Server Management Studio (SSMS) Read More »
To automatically drop delete a database using WindowsTask Scheduler, you can use the following steps: The following bat Script I have given below: Example : Step01: Open Task Scheduler Step02: Create a Schedule Task according to image Step03: Provide a Schedule Task Name on Name Field Section – Step04: Create Triggers for the specific task …
Automatically Drop Delete Database Using WindowsTask Scheduler Read More »
Transparent Data Encryption (TDE) is a feature in SQL Server that encrypts the entire database (data and log files) at the storage level. TDE protects the database from media theft and ensures that data cannot be read or written to disk in an unencrypted format. TDE uses the Advanced Encryption Standard (AES) algorithm with a …
SQL Server offers two options to Create New Database: Running a SQL command in the SQL Server Management Studio (SSMS) query window or Manually creating a database using the SSMS interface. The following steps outline the process of creating a database: Create New Database Using SQL COMMAND To create a database using a SQL query, …
How to Create New Database in SQL Server – 2 Simple Ways Read More »