Useful tips for everyday
How do I recover a deleted row in SQL Server? Recover Deleted Rows from SQL Server Table USE Master. GO. CREATE DATABASE [RecoverDeletedData] ON PRIMARY.…
How AWS DMS works internally? AWS Database Migration Service (AWS DMS) is a web service that you can use to migrate data from a source…
What is the difference between latch and lock in SQL Server? Latches are internal to the SQL engine and are used to provide memory consistency,…
How do you create a trigger table in SQL? Introduction to SQL Server CREATE TRIGGER statement The CREATE TRIGGER statement allows you to create a…
How do I find my MariaDB users? How to see/get a list of MySQL/MariaDB users accounts Step 1 – Login to mysql. Step 2 –…
How do I calculate percentage in PostgreSQL? select time,t_count,sum(t_count) over (order by time) as cumulative_t_count ,cumulative_t_count/sum(t_count) as percentage_cumulative count,zone,hour from (select distinct time,count(distinct num_id) as…
How to identify a connection in SQL Server? We plan on doing the same thing with SQL Server. I’ve already seen that there is a…
How to get a list of all binlogs in MySQL? Determining The Current BinLogs. To retrieve a list of all the BinLogs present in your…
How do I retrieve an unsaved SQL query? Open Local Disk (C): Open users Folder. Find the folder relevant for your username and open it.…
How do I split a single row into multiple rows in SQL Server? You can generate the extra row(s) by doing an unpivot using a…