sqlinsix in #hive-199420 • last yearWeekly Tech Lesson: LEFT SEMI JOINs and How To Use ThemWhen we INNER JOINfrom one table to another table with a column or set of columns and we select all columns, we'll get the results returned for both tables. This is true for…sqlinsix in #hive-199420 • 2 years agoWeekly Tech Lesson: How To Write A Cross Apply (Platform Specific)In our series, we've looked at how we can match data using relationships, or find data that don't match based on conditions, and even compare data to itself. What if we wanted…sqlinsix in #hive-199420 • 2 years agoWeekly Tech Lesson: Using Self-Joins In SQLAs we've seen with SQL joins, we can link data to other data using relationships between data, such as a relationship between the history of a sales' price for a particular house…sqlinsix in #hive-199420 • 2 years agoWeekly Tech Lesson: Using LEFT ANTI JOINs In SQLPreviously, we've look at the join functionality of LEFT JOIN. If we recall from that lesson, we learned that a LEFT JOIN will join records that match and don't match on the…sqlinsix in #hive-199420 • 2 years agoWeekly Tech Lesson: Using LEFT JOINs In SQLPreviously, we looked at INNER JOINs and where we may consider using them in development - a quick example might be if we have a set of data that shares a relationship with…sqlinsix in #hive-163521 • 2 years agoHive SQL Tutorial: How To Write A LEFT ANTI JOINPreviously, we've look at the join functionality of LEFT JOIN. If we recall from that lesson, we learned that a LEFT JOIN will join records that match and don't match on the…sqlinsix in #hive-163521 • 2 years agoSQL Tutorial: RIGHT JOIN Basics and Why You Should Be Aware of ThemWe've previously looked at the LEFT JOIN and we can't invert the LEFT JOIN to do a RIGHT JOIN (though I would caution on doing this because it begins to violate using a…sqlinsix in #hive-199420 • 2 years agoWeekly Tech Lesson: Using INNER JOINs In SQLWhen storing data, one technique to storing data is linking information through identification of the data. Every data value that we store can be linked to other data values…sqlinsix in #hive-163521 • 2 years agoSQL Tutorial: LEFT JOIN Basics and When To Use ThemPreviously, we looked at INNER JOINs and where we may consider using them in development - a quick example might be if we have a set of data that shares a relationship with…sqlinsix in #hive-199420 • 2 years agoWeekly Tech Lesson: Using SELECT * INTO With SQLRecently, a development team reached out because they faced issues when testing their data. The team had created a quick copy of the data with the SQL Server code of SELECT *…sqlinsix in #hive-163521 • 2 years agoSQL Tutorial: INNER JOIN Basics and When To Use ThemWhen storing data, one technique to storing data is linking information through identification of the data. Every data value that we store can be linked to other data values…sqlinsix in #hive-163521 • 2 years agoMongoDB Tutorial: Adding A Subdocument To An Existing DocumentWhat if we have an existing document or subdocument and we want to add a subdocument to this, or add a subdocument to a subdocument array within a document? In MongoDB: Add Subdocument To Existingsqlinsix in #hive-163521 • 2 years agoPowerShell Tutorial: Using Compare-Object With FilesOne common task in troubleshooting is comparing two entities. These can be environments, servers, files, or other objects. There's a myriad of tools we can use, but one…sqlinsix in #hive-163521 • 2 years agoSQL Basics: When To Use SELECT * INTORecently, a development team reached out because they faced issues when testing their data. The team had created a quick copy of the data with the SQL Server code of SELECT *…sqlinsix in #healthcare • 2 years agoPast Prediction: Innovation In the Healthcare FieldCheck out the discussion about healthcare and innovation in the video Tech Solutions In Health Care. In this Tech Pow Wow, I highlight why we'll continue to see less innovation in healthcare wi