Renaming the database and service account in postgresql database
Renaming a Database When you rename a database, the objects within the database retain their existing privileges, but any external reference...
Homepage tv369" academy
Latest Posts
finding volumes mapped to drives in Windows On EC2 Cloud
# List the disks function Convert-SCSITargetIdToDeviceName { param([int]$SCSITargetId) If ($SCSITargetId -eq 0) { return "sda1...
Example Table in SQL Server for Replication test
CREATE TABLE ExampleTable ( ID INT PRIMARY KEY, Name NVARCHAR(50), Age INT ); INSERT INTO ExampleTable (ID, Name, Age) VALUES ...
Memory related issue in SQL Server
Memory Pressure: When SQL Server's memory is under pressure, it can lead to paging, slowdowns, and potential crashes. Here's what ...
Binary logs recovery in MYSQL Server
service mysql stop ---cold backup mkdir cold /var/lib/mysql#cp -rf * /root/cold /etc/mysql#cp my.cnf /root/cold only a table cannot able to...
