sqlinsix (55)in #data • 3 years agosteemCreated with Sketch.Solution When ISJSON May Not Be A Recognized Function NameCheck out the solution in the video Schema validation failed: 'ISJSON' is not a recognized built-in function name.…sqlinsix (55)in #data • 3 years agosteemCreated with Sketch.Creating a GUID For Each GUIDWhat happens when we run into a situation where we need to create a GUID for reach GUID? Check out the solution in…sqlinsix (55)in #development • 3 years agosteemCreated with Sketch.Get A Past Bash Command QuicklyIt'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…sqlinsix (55)in #azure • 3 years agosteemCreated with Sketch.Connecting A Data Factory To An Existing Runtime In AzureWith Azure Data Factory, we can connect on premise assets to Azure resources, such as an on premise database to an…sqlinsix (55)in #development • 3 years agosteemCreated with Sketch.Backing Up A Database With MongoDumpReview how to backup a database with a built-in tool in MongoDB: How To Backup With MongoDump. As you can see, we…sqlinsix (55)in Popular STEM • 3 years agosteemCreated with Sketch.SQL Basics: Using UNION ALL or UNION and WhyIn some cases, we need to combine the result of two tables where data types may be similar or identical. We could…sqlinsix (55)in #development • 3 years agosteemCreated with Sketch.T-SQL: How To UNION ALL Tables and WhyIn some cases, we need to combine the result of two tables where data types may be similar or identical. We could…sqlinsix (55)in Popular STEM • 3 years agosteemCreated with Sketch.SQL Basics: Solving Data Differentials With LEFT JOINs OnlyOne challenge we face with data involves new and existing data from a source data set to a destination data set. The…sqlinsix (55)in #development • 3 years agosteemCreated with Sketch.Solving Data Differentials With LEFT JOINsOne challenge we face with data involves new and existing data from a source data set to a destination data set. The…sqlinsix (55)in #data • 3 years agosteemCreated with Sketch.Transaction Log Becoming Full Due To ReplicationReview the solution and discussion in the video The transaction log for database 'DB' is full due to 'REPLICATION'.…sqlinsix (55)in Popular STEM • 3 years agosteemCreated with Sketch.Transaction Log Becoming Full Due To ReplicationReview the solution and discussion in the video The transaction log for database 'DB' is full due to 'REPLICATION'.…sqlinsix (55)in Popular STEM • 3 years agosteemCreated with Sketch.Why We Should Be Skeptical About Data and the Physical WorldIn the video, Data and the Physical World (Gold) we look at the severe limitations of data about the physical world.…sqlinsix (55)in #data • 3 years agosteemCreated with Sketch.Does the Same Data Mean the Same Conclusions?Before discussing this challenge, a few notes: I intentionally picked a neutral topic (the Dollar shortage) because…sqlinsix (55)Friendin Steem Schools • 3 years agosteemCreated with Sketch.Discussion About Data and the Physical World Part IIn the video, Data and the Physical World (Gold) we look at the severe limitations of data about the physical world.…sqlinsix (55)in Popular STEM • 3 years agosteemCreated with Sketch.SQL Basics: How To Use ROW NUMBER() and WhyNo matter what data we receive, we will probably be required to order it a certain way at some point. In some cases…sqlinsix (55)in #data • 3 years agosteemCreated with Sketch.Not Able To Drop Table Because of ReferenceWhat happens when we try to drop a table that is being referenced by a view (it's also possible that we get an error…sqlinsix (55)in #development • 3 years agosteemCreated with Sketch.T-SQL: How To Use DENSE_RANK()In a previous lesson, we learned that we can apply ROW_NUMBER() to a data set and output the row number of the data…sqlinsix (55)in Popular STEM • 3 years agosteemCreated with Sketch.The Decentralized Myth - Beyond the HypeIn the video, Tech Pow Wow: The Decentralization Myth, we exclusively look at the technical promises being made in…sqlinsix (55)in Popular STEM • 3 years agosteemCreated with Sketch.SQL Basics: INNER JOINs vs LEFT JOINsFor people who are new to SQL, these two JOIN types can often be confusing. In the below videos and discussion we…sqlinsix (55)in #development • 3 years agosteemCreated with Sketch.T-SQL: How To Use PARTITION BY and WhyIf we think about functions in mathematics, we'll recall that one function is the division function. If we have 10…
