sqlinsix(25)•in #data•1528 days agoSolution When ISJSON May Not Be A Recognized Function Namehttps://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. F...80$1.22sqlinsix(25)•in data•1528 days agoSolution When ISJSON May Not Be A Recognized Function Namehttps://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. F...80$1.22
sqlinsix(25)•in #data•1532 days agoCreating a GUID For Each GUIDhttps://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 t...140$0.36sqlinsix(25)•in data•1532 days agoCreating a GUID For Each GUIDhttps://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 t...140$0.36
sqlinsix(25)•in #development•1537 days agoGet A Past Bash Command Quicklyhttps://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 ...60$0.83sqlinsix(25)•in development•1537 days agoGet A Past Bash Command Quicklyhttps://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 ...60$0.83
sqlinsix(25)•in #azure•1547 days agoConnecting A Data Factory To An Existing Runtime In Azurehttps://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 A...61$0.69sqlinsix(25) •in azure•1547 days agoConnecting A Data Factory To An Existing Runtime In Azurehttps://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 A...61$0.69
sqlinsix(25)•in #development•1552 days agoBacking Up A Database With MongoDumphttps://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 le...92$0.77sqlinsix(25)•in development•1552 days agoBacking Up A Database With MongoDumphttps://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 le...92$0.77
sqlinsix(25)•in #blog•1563 days agoT-SQL: How To UNION ALL Tables and Whyhttps://www.youtube.com/watch?v=c9kzDhyWT8&list=PLHHm85xMQAYNScEs-nu9gzi2uoQ9JCCYA&index=11 In some cases, we need to combine the result of two tables where dat...60$0.68sqlinsix(25)•in blog•1563 days agoT-SQL: How To UNION ALL Tables and Whyhttps://www.youtube.com/watch?v=c9kzDhyWT8&list=PLHHm85xMQAYNScEs-nu9gzi2uoQ9JCCYA&index=11 In some cases, we need to combine the result of two tables where dat...60$0.68
sqlinsix(25)•in #development•1571 days agoSolving Data Differentials With LEFT JOINshttps://www.youtube.com/watch?v=L0B4hULlso&list=PLHHm85xMQAYNScEs-nu9gzi2uoQ9JCCYA&index=16 One challenge we face with data involves new and existing data from ...60$0.59sqlinsix(25)•in development•1571 days agoSolving Data Differentials With LEFT JOINshttps://www.youtube.com/watch?v=L0B4hULlso&list=PLHHm85xMQAYNScEs-nu9gzi2uoQ9JCCYA&index=16 One challenge we face with data involves new and existing data from ...60$0.59
sqlinsix(25)•in #etl•1574 days agoSpark Scala: Grouping Values In A Key-Value Pairhttps://cdn.pixabay.com/photo/2014/10/05/19/02/binary-code-475664960720.jpg First, we'll create our data set. We'll notice in our test data set, we have differe...131$0.58sqlinsix(25)•in etl•1574 days agoSpark Scala: Grouping Values In A Key-Value Pairhttps://cdn.pixabay.com/photo/2014/10/05/19/02/binary-code-475664960720.jpg First, we'll create our data set. We'll notice in our test data set, we have differe...131$0.58
sqlinsix(25)•in #data•1580 days agoTransaction Log Becoming Full Due To Replicationhttps://www.youtube.com/watch?v=kCKkrYZq1l0 Review the solution and discussion in the video The transaction log for database 'DB' is full due to 'REPLICATION'. ...91$0.71sqlinsix(25)•in data•1580 days agoTransaction Log Becoming Full Due To Replicationhttps://www.youtube.com/watch?v=kCKkrYZq1l0 Review the solution and discussion in the video The transaction log for database 'DB' is full due to 'REPLICATION'. ...91$0.71
sqlinsix(25)•in #data•1589 days agoDoes the Same Data Mean the Same Conclusions?https://www.youtube.com/watch?v=zdh49HnuOSs Before discussing this challenge, a few notes: I intentionally picked a neutral topic (the Dollar shortage) because ...90$1.01sqlinsix(25)•in data•1589 days agoDoes the Same Data Mean the Same Conclusions?https://www.youtube.com/watch?v=zdh49HnuOSs Before discussing this challenge, a few notes: I intentionally picked a neutral topic (the Dollar shortage) because ...90$1.01
sqlinsix(25)•in #data•1595 days agoNot Able To Drop Table Because of Referencehttps://www.youtube.com/watch?v=evJaiaqod1A What happens when we try to drop a table that is being referenced by a view (it's also possible that we get an error...100$0.71sqlinsix(25)•in data•1595 days agoNot Able To Drop Table Because of Referencehttps://www.youtube.com/watch?v=evJaiaqod1A What happens when we try to drop a table that is being referenced by a view (it's also possible that we get an error...100$0.71
sqlinsix(25)•in #development•1601 days agoT-SQL: How To Use DENSE_RANK()https://www.youtube.com/watch?v=guI2jEbmJ9k&list=PLHHm85xMQAYNScEs-nu9gzi2uoQ9JCCYA&index=15 In a previous lesson, we learned that we can apply ROWNUMBER() to a...190$0.69sqlinsix(25)•in development•1601 days agoT-SQL: How To Use DENSE_RANK()https://www.youtube.com/watch?v=guI2jEbmJ9k&list=PLHHm85xMQAYNScEs-nu9gzi2uoQ9JCCYA&index=15 In a previous lesson, we learned that we can apply ROWNUMBER() to a...190$0.69
sqlinsix(25)•in #blog•1605 days agoThe Decentralized Myth - Beyond the Hypehttps://www.youtube.com/watch?v=9PT-PT8wY-Q In the video, Tech Pow Wow: The Decentralization Myth, we exclusively look at the technical promises being made in s...104$0.63sqlinsix(25)•in blog•1605 days agoThe Decentralized Myth - Beyond the Hypehttps://www.youtube.com/watch?v=9PT-PT8wY-Q In the video, Tech Pow Wow: The Decentralization Myth, we exclusively look at the technical promises being made in s...104$0.63
sqlinsix(25)•in #development•1610 days agoT-SQL: How To Use PARTITION BY and Whyhttps://www.youtube.com/watch?v=h3Jx4CoNgL8&list=PLHHm85xMQAYNScEs-nu9gzi2uoQ9JCCYA&index=14 If we think about functions in mathematics, we'll recall that one f...81$0.46sqlinsix(25)•in development•1610 days agoT-SQL: How To Use PARTITION BY and Whyhttps://www.youtube.com/watch?v=h3Jx4CoNgL8&list=PLHHm85xMQAYNScEs-nu9gzi2uoQ9JCCYA&index=14 If we think about functions in mathematics, we'll recall that one f...81$0.46
sqlinsix(25)•in #development•1618 days agoT-SQL: How To Use ROW NUMBER() and Whyhttps://www.youtube.com/watch?v=vR5DfWIUhXM&list=PLHHm85xMQAYNScEs-nu9gzi2uoQ9JCCYA&index=13 No matter what data we receive, we will probably be required to ord...91$0.43sqlinsix(25)•in development•1618 days agoT-SQL: How To Use ROW NUMBER() and Whyhttps://www.youtube.com/watch?v=vR5DfWIUhXM&list=PLHHm85xMQAYNScEs-nu9gzi2uoQ9JCCYA&index=13 No matter what data we receive, we will probably be required to ord...91$0.43
sqlinsix(25)•in #blog•1618 days agoAutomatic Merge Failed, Fix Conflicts Issuehttps://www.youtube.com/watch?v=czisj7oDcqE What happens when we run into the problem where we experience a merge conflict where two developers have made change...30$0.16sqlinsix(25)•in blog•1618 days agoAutomatic Merge Failed, Fix Conflicts Issuehttps://www.youtube.com/watch?v=czisj7oDcqE What happens when we run into the problem where we experience a merge conflict where two developers have made change...30$0.16
sqlinsix(25)•in #development•1625 days agoT-SQL: How To Write A CROSS JOIN and Whyhttps://www.youtube.com/watch?v=H3Stc86AoNs&list=PLHHm85xMQAYNScEs-nu9gzi2uoQ9JCCYA&index=9 When we look at data, we will sometimes want to look at all data poi...71$0.42sqlinsix(25)•in development•1625 days agoT-SQL: How To Write A CROSS JOIN and Whyhttps://www.youtube.com/watch?v=H3Stc86AoNs&list=PLHHm85xMQAYNScEs-nu9gzi2uoQ9JCCYA&index=9 When we look at data, we will sometimes want to look at all data poi...71$0.42
sqlinsix(25)•in #development•1632 days agoT-SQL: How To Write A FULL OUTER JOINhttps://www.youtube.com/watch?v=rc3N-o8qyyE&list=PLHHm85xMQAYNScEs-nu9gzi2uoQ9JCCYA&index=8 We've looked at the LEFT and RIGHT JOINs. These can be useful relati...70$0.43sqlinsix(25)•in development•1632 days agoT-SQL: How To Write A FULL OUTER JOINhttps://www.youtube.com/watch?v=rc3N-o8qyyE&list=PLHHm85xMQAYNScEs-nu9gzi2uoQ9JCCYA&index=8 We've looked at the LEFT and RIGHT JOINs. These can be useful relati...70$0.43
sqlinsix(25)•in #sql•1640 days agoHive SQL: How To Write A LEFT SEMI JOINhttps://www.youtube.com/watch?v=rcyhhfjsc4&list=PLHHm85xMQAYNScEs-nu9gzi2uoQ9JCCYA&index=7 When we INNER JOINfrom one table to another table with a column or se...170$0.69sqlinsix(25)•in sql•1640 days agoHive SQL: How To Write A LEFT SEMI JOINhttps://www.youtube.com/watch?v=rcyhhfjsc4&list=PLHHm85xMQAYNScEs-nu9gzi2uoQ9JCCYA&index=7 When we INNER JOINfrom one table to another table with a column or se...170$0.69
sqlinsix(25)•in #sql•1647 days agoT-SQL: How To Write A Cross Apply and Whyhttps://www.youtube.com/watch?v=5qrYAQoeLw&list=PLHHm85xMQAYNScEs-nu9gzi2uoQ9JCCYA&index=6 In our series, we've looked at how we can match data using relationsh...80$0.29sqlinsix(25)•in sql•1647 days agoT-SQL: How To Write A Cross Apply and Whyhttps://www.youtube.com/watch?v=5qrYAQoeLw&list=PLHHm85xMQAYNScEs-nu9gzi2uoQ9JCCYA&index=6 In our series, we've looked at how we can match data using relationsh...80$0.29
