April 2021 - All Things SQL

Microsoft SSIS vs Azure Data Factory (ADF)

adf vs ssis, azure data factory vs ssis, difference between adf and ssis, difference between azure data factory and ssis, difference between ssis and adf, ssis vs adf, ssis vs azure data factory

SQL Server Integration Services (SSIS) and Azure Data Factory (ADF) both serve as ETL tools to extract data, transform data,

ALTER TABLE – Add, Remove, or Modify Column in SQL

add column sql, alter table add column, alter table add sql, alter table drop column sql, modify column in sql, rename a column in sql, sql add column, sql alter table drop column, sql modify column, sql rename column

We can use the ALTER TABLE command to either add or remove columns in SQL. The ALTER command is considered

SQL LEAD() Function – Getting Next Value

sql function lead, sql function next value, sql lead example, sql lead function example, sql next value, sql server lead function, sql window lead

Very similar to the Lag() function that provides a previous record value is the Lead() function which provides the opposite

SQL LAG() Function – Getting Previous Value

sql function lag, sql function previous value, sql lag example, sql lag function example, sql previous value, sql server lag function, sql window lag

There are several functions in SQL that are very useful such as the Lag() and Lead() functions. The lag function

Create a Table Using a SQL SELECT Statement

create table using select, create table using select in sql, create table using select statement, create table with select, create table with select sql, create table with select statement, sql create table select, sql create table using select, sql create table with select

There are several ways to create tables with special keywords such as specifying primary keys, foreign keys, unique constraints and