Useful tips for everyday
How do you choose sharding key? What makes a good shard key? The distribution of reads and writes. The most important of these is distribution…
How do I know what version of SQL Server client tools I have? Determine the version of SQL Server Client tools To determine which versions…
How do you pivot rows to columns in power query? To do this go into Power Query, select Transform and then select Pivot Column. The…
How do you rank subsets in Excel? There is a formula to quickly rank values based on group. Select a blank cell next to the…
How does MySQL 5.7 support semisynchronous replication? In addition to the built-in asynchronous replication, MySQL 5.7 supports an interface to semisynchronous replication that is implemented…
What will be the location of error log file? By default, the error log is located at Program Files\Microsoft SQL Server\MSSQL. n files. A new…
How do I get data from PostgreSQL to power BI? Open Power BI Desktop. Click on ‘Get data’ and choose the option ‘More’. In the…
Does MySQL have query caching? The query cache is deprecated as of MySQL 5.7. 20, and is removed in MySQL 8.0. The query cache stores…
How do I insert a record from one database to another database? Solution USE Target_Database. GO. INSERT INTO dbo. Target_Table(Column1, Column2, Column3) SELECT Column1, Column2,…
What kind of relationship is there between customers and orders? A Customer has a one-to-many relationship with a Purchase Order because a customer can place…