Useful tips for everyday
How do I copy data from one database to another? Right click on the database you want to copy. ‘Tasks’ > ‘Export Data’. Next, Next.…
What kind of backup allows a system to be backed up without being shut down? A cold backup, also called an offline backup, is a…
Should I backup system databases? It’s a best practice to create daily backups of all the system databases once all the user databases on the…
What does a backup set do in SQL Server? Contains a row for each backup set. A backup set contains the backup from a single,…
What is SQL Server Openjson? OPENJSON is a table-valued function that parses JSON text and returns objects and properties from the JSON input as rows…
How do you size a database? Database sizing helps you estimate the requirements for your database, anticipate capacity for growth, and plan disk requirements. Capacity…
What causes availability group to fail over? An availability group fails over at the availability-replica level. That is, an availability group fails over to one…
How do you optimize query with many joins? It’s vital you optimize your queries for minimum impact on database performance. Define business requirements first. SELECT…
How to find the disk size of a PostgreSQL? I assume in Postgres there’s something I can use in the information_schema tables, but I’m not…
How are word embeds trained? Word embeddings work by using an algorithm to train a set of fixed-length dense and continuous-valued vectors based on a…