Category "database-administration"

PostgreSQL 13 - Performance Improvement to delete large table data

I am using PostgreSQL 13 and has intermediate level experience with PostgreSQL. I have a table named tbl_employee. it stores employee details for number of cust

SQL Server 2016 - How to get last logged in date for user?

How can I get the last logged in date for certain user. I googled and stumbled upon this query SELECT name, accdate FROM sys.syslogins But the accdate column

Find all stored procedures that reference another stored procedure

I want to find the all the directly and indirectly references to DB objects list. I am using below queries but I found the issue. DECLARE @Search varchar(255)

ora-09925 unable to create audit trail file no such file or directory

I have just installed a oracle 12c 12.1.0 DB on a linux machine. after completing the installation i tried to login to database as sysdba [oracle@bjorn adump]

Hyperscale to general purpose

We have a azure hyperscale sql db. We want to restore it to general purpose. Is anybody know to restore azure hyperscale sql database to general purpose databas