Open in app

Sign In

Write

Sign In

SQLInSix Minutes
SQLInSix Minutes

22 Followers

Home

About

Oct 29, 2021

Connecting A Data Factory To An Existing Runtime In Azure

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 require an on premise runtime that communicates with both the on premise resource and the Azure resource. In the video Connect Azure…

Azure

2 min read

Azure

2 min read


Oct 9, 2021

T-SQL: How To UNION ALL Tables and Why

In some cases, we need to combine the result of two tables where data types may be similar or identical. We could combine the data in one table using INSERT syntaxes, but with UNION ALL or UNION, we can achieve the same result instead of creating a new table. In…

2 min read

2 min read


Sep 30, 2021

Solving Data Differentials With LEFT JOINs

One challenge we face with data involves new and existing data from a source data set to a destination data set. The source and destination may be managed by us or one of them could be managed by us. When we have these data sets, we will often get “updates”…

Sql

3 min read

Sql

3 min read


Sep 23, 2021

Transaction Log Becoming Full Due To Replication

Review the solution and discussion in the video The transaction log for database ‘DB’ is full due to ‘REPLICATION’. We do not want to develop the habit of micro-managing transaction logs, so we should consider sizing before setting up any architecture such as replication, ETL solutions, etc. As a note…

Sql Server

2 min read

Sql Server

2 min read


Sep 16, 2021

Why We Should Be Skeptical About Data Regarding the Physical World

In the video, Data and the Physical World (Gold) we look at the severe limitations of data about the physical world. In 2020, there was a worldwide coin shortage and there were discussions about what was behind the shortage. One thing we should consider anytime we’re discussing data related to…

Data

3 min read

Data

3 min read


Sep 11, 2021

The Decentralization Myth — Beyond the Hype

In the video, Tech Pow Wow: The Decentralization Myth, we exclusively look at the technical promises being made in some decentralized communities. As a note, this video is only discussing the technical aspects of what are being promised and is mentioning nothing that is financial. In this video, I refute…

3 min read

3 min read


Aug 31, 2021

SQL Basics: INNER JOINs vs LEFT JOINs

For people who are new to SQL, these two JOIN types can often be confusing. In the below videos and discussion we compare and contrast the two using the same data set and noting the results. INNER JOINs match data on their condition. Suppose that we had a table called…

Sql

3 min read

Sql

3 min read


Aug 27, 2021

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 set based on the order we specify. This means that if we have an alphabetized list, we could have ROW_NUMBER() return that list in an ascending or…

2 min read

2 min read


Aug 20, 2021

T-SQL: How To Use PARTITION BY and Why

If we think about functions in mathematics, we’ll recall that one function is the division function. If we have 10 apples and we want to divide them equally into 2 containers, there will be 5 apples in each container. If we have 10 apples and 10 containers and we want…

Sql

2 min read

Sql

2 min read


Aug 14, 2021

T-SQL: How To Use ROW NUMBER() and Why

No matter what data we receive, we will probably be required to order it a certain way at some point. In some cases, we may simply order data by dates and receive it in that format, meaning we have little to do. But there are other times when we have…

Sql

2 min read

Sql

2 min read

SQLInSix Minutes

SQLInSix Minutes

22 Followers

Data | Development | Security.

Help

Status

Writers

Blog

Careers

Privacy

Terms

About

Text to speech