sqlinsix in #hive-199420 • 11 months agoWeekly 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 • 11 months 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 • last yearWeekly 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 • last yearWeekly 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 • last yearWeekly 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 • last yearHive 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 • last yearSQL 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 • last yearWeekly 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 • last yearSQL 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 • last yearWeekly 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 • last yearSQL 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 • last yearMongoDB 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 • last yearPowerShell 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 • last yearSQL 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 • last yearPast 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 wisqlinsix in #hive-145844 • 2 years ago[Renamed] Is There A Backdoor To Linux?[Paraphrased]: an individual submitted code that contained a bug and a few people are suspicious only because the developer has been in the community for a while. Keep in mind that there are a varsqlinsix in #hive-145844 • 2 years agoFor IT Leaders, Transformation Demands Require FocusWith the right focus, prioritization and infrastructure agility, IT leaders will be better prepared to respond to challenges of HHN and beyond. Whether we’re talking about the meeting of world econsqlinsix in #hive-145844 • 2 years agoIs DEF CON Cancelled?We were told DEF CON 28 is canceled. But obviously we’re not stupid enough to fall for that old trick. Protect Your Digital Assets - Consumer Gsqlinsix in #data • 2 years agoPrediction Update: Innovation In the Healthcare FieldCheck out the solution in the video Tech Solutions In Health Care. While I agree with the assessment of why we see higher health care costs in the United States (bureaucracy), following an assesqlinsix in #hive-145844 • 2 years agoBusinesses Underestimate HHN Cybersecurity RisksHHN has been impacting the world for at least five months, and cybercriminals have not let up in their attempts to manipulate the crisis for their own gain. For example, in the week before Easter—t