Categories
Database Development

How to restore and overwrite an exiting database on Azure SQL MI

We are trying to restore a backup file in Azure SQL MI using SSMS. the issue is we are trying to overwrite an existing database and we notice this feature is not present in SSMS for Azure SQL MI but available for SQL Server. Is it possible to overwrite the database using SQL scripts.

Categories
Database Development

use of age() function postgres

I am trying to calculate the time since an event took place. The event timestamp will itself be the result of a MIN aggregate function. Is there a way to do this. I have run a query to get the earliest date in my table which SELECT MIN(date_column) FROM table I also know that AGE(timestamp […]

Categories
Database Development

Extremely bloated transaction log during delete

Now, I know that the log can get large during big deletes and one should try to chop it into batches. But I find this scenario strange and if someone could explain it to me that would be GREAT!. I have a 27GB database with around 30GB log. The table that is beeing deleted from […]

Categories
Database Development

Master node freezes when second master unreachable in master-master replication

I have a 2 node master-master setup in mySQL 8.0.22. I have successfully got the nodes to both be writeable and update each other in normal operation. However, When I disconnect a node, it is not possible to write to the other master, it hangs indefinitely on any db operation. How can I get my […]

Categories
CMS Mastering Development

Lineitem language not correct

I have a multisite and it seems that the lineitems are always saved in the default site’s language. When I loop over order.lineitems the item.description isn’t translated. When I look at the order in the CP, I can also see that the title of the variants (description) is in the default site’s language. Is this […]

Categories
Android User Help

Fasboot Devices not getting attached XIAOMI MI A3

I have the xiaomi mi a3 and im currently on both phone and pc latest stock update i am using windows 10 20H2 and i have tried everything but still doesn’t get it……i tried another mi a3 and it got attached normally. I’ve tried installing all kind of drivers and different ports, nothing……when suddenly it […]

Categories
Android User Help

Is it possible to take pictures from both front and rear camera at the same time (like bothie)

There are apps that can do this but they are not exactly Bothie. The app allows the user to first take a picture from rear camera and then from the front camera (but not simultaneously). Nokia first came up with this idea in 2017. More about Bothie I am just wondering if this is a […]

Categories
Database Development

Using COPY in Postgres

I know COPY is the best utility to export the data from a table or a query to output files. But if we are doing an export like \COPY (select * from table) to ‘/tmp/file.csv’ WITH CSV; How its different from running the select query and save the results later(like in a GUI tool) or […]

Categories
Database Development

Job management: How to get the next running date by querying MSDB

Table sysjobschedules contains 2 columns next_run_date and next_run_time. With the help of sysschedules and column enable it should be easy to determine the next running date/time of a specific job. However, when you change a schedule, sysjobschedules is only refreshed 20 minutes after alteration by the Sql Server Agent. Table sysjobactivity contains a datetime next_schedule_run_date […]

Categories
Android User Help

File system of Android 10 running devices

I have a samsung A30 cellphone that runs Android 10 and I basically need to recover my deleted files. In order to do that, I need to know the filesystem because forensic tools require such information. I made a small research, but I couldn’t find any information on Android 10 OS’s file system. So what […]