Useful tips for everyday
How does Normalisation solve the problem of update anomalies? Normalisation is a systematic approach of decomposing tables to eliminate data redundancy and Insertion, Modification and…
How do I find my MDF database? The mdf and ldf can be set for each Microsoft SQL database, by right-clicking on the database, in…
What is dedicated admin connection? The dedicated admin connection (DAC) can help you out of a sticky situation. This was built to help you connect…
Can a data flow task not insert a row? After configuring OLE Db source i can preview the resulting row and even data flow task…
What to do if MySQL started with InnoDB _ Force _ recovery? Anyway, if MySQL started with innodb_force_recovery=6 go ahead and dump the databases with…
How do I describe a table in PostgreSQL? The psql equivalent of DESCRIBE TABLE is \d table . See the psql portion of the PostgreSQL…
How does SQL Server always on listeners work? Therefore, if we have a configuration for DC-DR Always on replicas, we can have one virtual IP…
Does COUNT counts NULL? COUNT(expression) does not count NULL values. It can optionally count or not count duplicate field values. COUNT(*) returns the count of…
How do I convert a column to a row in Excel? Copy the selected cells by pressing Ctrl + C. Select the cell where you…
What DB to choose for application? How to efficiently choose a relational database Consider your data volume and database scalability. Make a decision based on:…