Hive profile

SqlinSix

@sqlinsix

Data and Research Solutions

281 followers 8 following 409 posts Reputation 58.05

SqlinSix
@sqlinsix Nov 9, 2021, 4:03 PM UTC

Solution When ISJSON May Not Be A Recognized Function Name

https://www.youtube.com/watch?v=hyoTI16qUns Check out the solution in the video Schema validation failed: 'ISJSON' is not a recognized built-in function name. First, note the version of Microsoft SQL…

7 upvotes 1 downvotes 0 replies $1.22
SqlinSix
@sqlinsix Nov 5, 2021, 12:24 PM UTC

Creating a GUID For Each GUID

https://www.youtube.com/watch?v=KGv2nZDTfQ4 What happens when we run into a situation where we need to create a GUID for reach GUID? Check out the solution in the video TSQL: Create A GUID For Each G…

12 upvotes 1 downvotes 0 replies $0.36
SqlinSix
@sqlinsix Oct 31, 2021, 4:17 PM UTC

Get A Past Bash Command Quickly

https://www.youtube.com/watch?v=ifiWrO7FFpo It's one thing to to surf for past Bash commands if we've only run a few of them in one day, but what if we've been running hundreds (or thousands) of Bash…

6 upvotes 0 replies $0.83
SqlinSix
@sqlinsix Oct 22, 2021, 9:50 AM UTC

Connecting A Data Factory To An Existing Runtime In Azure

https://www.youtube.com/watch?v=IpvmNyTLDxE With Azure Data Factory, we can connect on premise assets to Azure resources, such as an on premise database to an Azure database. At this time, this will…

5 upvotes 1 downvotes 1 replies $0.69
SqlinSix
@sqlinsix Oct 16, 2021, 4:10 PM UTC

Backing Up A Database With MongoDump

https://www.youtube.com/watch?v=KrikV7xtQOw Review how to backup a database with a built-in tool in MongoDB: How To Backup With MongoDump. As you can see, we learn how backup a database with the nati…

8 upvotes 1 downvotes 2 replies $0.77
SqlinSix
@sqlinsix Oct 13, 2021, 2:49 PM UTC

SQL Tutorial: Using UNION ALL or UNION and Why

https://www.youtube.com/watch?v=c9kz_DhyWT8&list=PLHHm85xMQAYNScEs-nu9gzi2uoQ9JCCYA&index=11 In some cases, we need to combine the result of two tables where data types may be similar or iden…

12 upvotes 1 downvotes 0 replies $0.62
SqlinSix
@sqlinsix Oct 5, 2021, 3:32 PM UTC

T-SQL: How To UNION ALL Tables and Why

https://www.youtube.com/watch?v=c9kz_DhyWT8&list=PLHHm85xMQAYNScEs-nu9gzi2uoQ9JCCYA&index=11 In some cases, we need to combine the result of two tables where data types may be similar or iden…

5 upvotes 1 downvotes 0 replies $0.68
SqlinSix
@sqlinsix Oct 3, 2021, 10:32 AM UTC

SQL Tutorial: Solving Data Differentials With LEFT JOINs Only

https://www.youtube.com/watch?v=L0B_4hULlso&list=PLHHm85xMQAYNScEs-nu9gzi2uoQ9JCCYA&index=16 One challenge we face with data involves new and existing data from a source data set to a destina…

11 upvotes 1 downvotes 0 replies $0.53
SqlinSix
@sqlinsix Sep 28, 2021, 10:43 AM UTC

Solving Data Differentials With LEFT JOINs

https://www.youtube.com/watch?v=L0B_4hULlso&list=PLHHm85xMQAYNScEs-nu9gzi2uoQ9JCCYA&index=16 One challenge we face with data involves new and existing data from a source data set to a destina…

5 upvotes 1 downvotes 0 replies $0.59
SqlinSix
@sqlinsix Sep 24, 2021, 3:12 PM UTC

Spark Scala: Grouping Values In A Key-Value Pair

https://cdn.pixabay.com/photo/2014/10/05/19/02/binary-code-475664_960_720.jpg First, we'll create our data set. We'll notice in our test data set, we have different uni values in various IDs. Ultimat…

12 upvotes 1 downvotes 1 replies $0.58