sqlinsix (55)in #data • 4 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 • 4 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 • 4 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 • 4 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 • 4 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 #development • 4 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 #development • 4 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 • 4 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 #data • 4 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)in #data • 4 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 • 4 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 #development • 4 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…sqlinsix (55)in #development • 4 years agosteemCreated with Sketch.T-SQL: 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 #development • 4 years agosteemCreated with Sketch.T-SQL: How To Write A CROSS JOIN and WhyWhen we look at data, we will sometimes want to look at all data points relative to all other data points. We…sqlinsix (55)in #development • 4 years agosteemCreated with Sketch.T-SQL: How To Write A FULL OUTER JOINWe've looked at the LEFT and RIGHT JOINs. These can be useful relative to the result set we want, thought RIGHT JOINs…sqlinsix (55)in #sql • 4 years agosteemCreated with Sketch.Hive SQL: How To Write A LEFT SEMI JOINWhen we INNER JOINfrom one table to another table with a column or set of columns and we select all columns, we'll get…sqlinsix (55)in #sql • 4 years agosteemCreated with Sketch.T-SQL: How To Write A Cross Apply and WhyIn our series, we've looked at how we can match data using relationships, or find data that don't match based on…sqlinsix (55)in #sql • 4 years agosteemCreated with Sketch.T-SQL: How To Write A Self Join and WhyAs we've seen with SQL joins, we can link data to other data using relationships between data, such as a relationship…sqlinsix (55)in #sql • 4 years agosteemCreated with Sketch.Hive SQL (and T-SQL): How To Write A Left Anti Join and WhyPreviously, we've look at the join functionality of LEFT JOIN. If we recall from that lesson, we learned that a LEFT…sqlinsix (55)in #sql • 4 years agosteemCreated with Sketch.T-SQL: How To Write A RIGHT JOIN 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…
