Useful tips for everyday
How do you avoid deadlocks in SQL Server? SQL Server uses the parent-child relationship among tables using the foreign key constraints. In this scenario, if…
How to restore a TDE encrypted database to a different server? In order to successfully restore a TDE encrypted database to a different server you…
Which is the load balancing server for PostgreSQL? Pgstream1 and pgstream2 are the Postgres database servers. Pgstream1 includes the primary database, pgstream2 includes the hot…
How do I restore Azure Bacpac file to MS SQL database? To import from a BACPAC file into a new single database using the Azure…
How do you write an UPDATE query for multiple rows? There are a couple of ways to do it. INSERT INTO students (id, score1, score2)…
How do you do math dates in SQL? Using DATEADD Function and Examples Add 30 days to a date SELECT DATEADD(DD,30,@Date) Add 3 hours to…
How do I check my AWS RDS disk space? View the VolumeBytesUsed in the RDS console Choose Databases from the navigation pane, and then choose…
How do I BCP data from SQL Server? Get started Get the bcp arguments. In the command line, write bcp. Get the version. You can…
Which is an example of a sort order table? A sort order table is a table that has a row per each value in the…
How do I stop HeidiSQL query from running? Stop a running Query Open a second HeidiSQL session to the same server. Go to Host ->…