Pausing your Fabric capacity on a schedule automagically
Yor's SQL Shorts
Pausing your Fabric capacity on a schedule automagically
1:52
Cut Your Cloud Bill: The 9-Hour Capacity Trick 🚀
Yor's SQL Shorts
Cut Your Cloud Bill: The 9-Hour Capacity Trick 🚀
0:45
Fabric + GitHub Integration in 60 Seconds
Yor's SQL Shorts
Fabric + GitHub Integration in 60 Seconds
1:27
Choosing the Right Data Store in Microsoft Fabric – Pros & Cons
Yor's SQL Shorts
Choosing the Right Data Store in Microsoft Fabric – Pros & Cons
1:35
Intro to Fabric Warehouse – Microsoft’s Cloud-Scale Data Engine
Yor's SQL Shorts
Intro to Fabric Warehouse – Microsoft’s Cloud-Scale Data Engine
1:17
What is a Fabric Lakehouse in 70 seconds
Yor's SQL Shorts
What is a Fabric Lakehouse in 70 seconds
1:10
Skip Stale Files with Metadata-Driven ETL in Fabric's Python Notebooks
Yor's SQL Shorts
Skip Stale Files with Metadata-Driven ETL in Fabric's Python Notebooks
1:44
Convert CSVs to Delta Tables in Microsoft Fabric with Python! No Spark needed
Yor's SQL Shorts
Convert CSVs to Delta Tables in Microsoft Fabric with Python! No Spark needed
0:51
Fabric Datawarehouse can now properly open JSON data!
Yor's SQL Shorts
Fabric Datawarehouse can now properly open JSON data!
0:31
Setting up a Fabric Deployment Pipeline
Yor's SQL Shorts
Setting up a Fabric Deployment Pipeline
1:08
How to configure your Python Notebook in Fabric
Yor's SQL Shorts
How to configure your Python Notebook in Fabric
1:24
Fabric Python Notebook: How to set the default Lakehouse and view runtime context
Yor's SQL Shorts
Fabric Python Notebook: How to set the default Lakehouse and view runtime context
0:37
How to Retrieve Lakehouse Info Using a Python Notebook | Step-by-Step Guide
Yor's SQL Shorts
How to Retrieve Lakehouse Info Using a Python Notebook | Step-by-Step Guide
0:55
Intro to Fabric's Python notebooks
Yor's SQL Shorts
Intro to Fabric's Python notebooks
1:03
Fixing SQL UNION/INTERSECT/EXCEPT Error
Yor's SQL Shorts
Fixing SQL UNION/INTERSECT/EXCEPT Error
1:00
Is the new TRUNCATE TABLE in Fabric Warehouse also quicker than a DELETE statement?
Yor's SQL Shorts
Is the new TRUNCATE TABLE in Fabric Warehouse also quicker than a DELETE statement?
1:00
How to create a SQL JSON VIEW without brackets
Yor's SQL Shorts
How to create a SQL JSON VIEW without brackets
0:51
SQL View with a JSON field that includes Null values
Yor's SQL Shorts
SQL View with a JSON field that includes Null values
0:47
Creating JSON Views in SQL Server: A Step-by-Step Guide
Yor's SQL Shorts
Creating JSON Views in SQL Server: A Step-by-Step Guide
0:51
TSQL XML Parsing: Extracting Nodes and Attributes
Yor's SQL Shorts
TSQL XML Parsing: Extracting Nodes and Attributes
0:38
Why you are using RIGHT OUTER JOINs
Yor's SQL Shorts
Why you are using RIGHT OUTER JOINs
0:39
Should you use schema's in Fabric Lakehouse?
Yor's SQL Shorts
Should you use schema's in Fabric Lakehouse?
0:27
Does the OPENJSON() rowset function function with a Fabric Warehouse table?
Yor's SQL Shorts
Does the OPENJSON() rowset function function with a Fabric Warehouse table?
0:40
Unlock JSON Data with T-SQL's OPENJSON in Fabric Warehouse
Yor's SQL Shorts
Unlock JSON Data with T-SQL's OPENJSON in Fabric Warehouse
1:00
This brand new feature just got added today in Fabric Warehouse!
Yor's SQL Shorts
This brand new feature just got added today in Fabric Warehouse!
0:28
Dynamic Table Refresh in SQL Server: CTAS + DIE Explained
Yor's SQL Shorts
Dynamic Table Refresh in SQL Server: CTAS + DIE Explained
0:40
Understanding Predicates in T-SQL
Yor's SQL Shorts
Understanding Predicates in T-SQL
0:51
Robust T-SQL: Implementing Error Handling with TRY...CATCH in Fabric
Yor's SQL Shorts
Robust T-SQL: Implementing Error Handling with TRY...CATCH in Fabric
0:32
What is CTAS ?
Yor's SQL Shorts
What is CTAS ?
0:58
T-SQL Tips: Using TOP N WITH TIES for Accurate Results #database
Yor's SQL Shorts
T-SQL Tips: Using TOP N WITH TIES for Accurate Results #database
0:58
LAG() & LEAD() window functions solve Gaps and Islands
Yor's SQL Shorts
LAG() & LEAD() window functions solve Gaps and Islands
1:00
Don't make this error in your CASE statements
Yor's SQL Shorts
Don't make this error in your CASE statements
0:41
T-SQL has a SWITCH statement??
Yor's SQL Shorts
T-SQL has a SWITCH statement??
0:53
Changing granularity for your datetimes the easy way
Yor's SQL Shorts
Changing granularity for your datetimes the easy way
0:43
Using STRING_SPLIT with a column from a table in Fabric
Yor's SQL Shorts
Using STRING_SPLIT with a column from a table in Fabric
0:54
T-SQL STRING_SPLIT() Function Explained with Examples in Fabric
Yor's SQL Shorts
T-SQL STRING_SPLIT() Function Explained with Examples in Fabric
0:49
RANK() vs DENSE_RANK(): Differences Explained #programming #sql #education #interviewquestions
Yor's SQL Shorts
RANK() vs DENSE_RANK(): Differences Explained #programming #sql #education #interviewquestions
0:40
Dynamic T-SQL Tutorial and how to avoid SQL Injection Risks
Yor's SQL Shorts
Dynamic T-SQL Tutorial and how to avoid SQL Injection Risks
0:52
Mastering SQL: How to print what can't be printed
Yor's SQL Shorts
Mastering SQL: How to print what can't be printed
1:00
How to create a Dadabase
Yor's SQL Shorts
How to create a Dadabase
0:32
Gone in a Cascade: Understanding Cascading Deletes in SQL
Yor's SQL Shorts
Gone in a Cascade: Understanding Cascading Deletes in SQL
0:57
Cascade of Changes: SQL Updates That 'Cascade-nnot' Be Ignored!
Yor's SQL Shorts
Cascade of Changes: SQL Updates That 'Cascade-nnot' Be Ignored!
1:00
Output Parameters in Stored Procedures Explained!
Yor's SQL Shorts
Output Parameters in Stored Procedures Explained!
1:00
Intro to Stored Procedures
Yor's SQL Shorts
Intro to Stored Procedures
1:00
These statements are to DIE for in SQL Server
Yor's SQL Shorts
These statements are to DIE for in SQL Server
0:37
LEFT JOIN Mistake: Avoid Turning It into an Inner Join
Yor's SQL Shorts
LEFT JOIN Mistake: Avoid Turning It into an Inner Join
0:44
Use RCSIL to improve most (b)locking issues in SQL
Yor's SQL Shorts
Use RCSIL to improve most (b)locking issues in SQL
1:01
DDL vs DML
Yor's SQL Shorts
DDL vs DML
0:54
Unlock SQL Performance: The Secret Power of Cardinality You Didn't Know About!
Yor's SQL Shorts
Unlock SQL Performance: The Secret Power of Cardinality You Didn't Know About!
1:00
Components of a Date Dimension explained
Yor's SQL Shorts
Components of a Date Dimension explained
1:00
Creating a Dynamic Date Dimension for Microsoft Fabric
Yor's SQL Shorts
Creating a Dynamic Date Dimension for Microsoft Fabric
1:00
Splitting text from 1 row into multiple with T-SQL
Yor's SQL Shorts
Splitting text from 1 row into multiple with T-SQL
1:00
How to do a Rolling SUM
Yor's SQL Shorts
How to do a Rolling SUM
0:40
SUM & GROUP BY explained
Yor's SQL Shorts
SUM & GROUP BY explained
0:56
FOREIGN KEY: should you create a NONCLUSTERED INDEX?
Yor's SQL Shorts
FOREIGN KEY: should you create a NONCLUSTERED INDEX?
0:51
FOREIGN KEY how does SQL check?
Yor's SQL Shorts
FOREIGN KEY how does SQL check?
0:32
What is a FOREIGN KEY part 1
Yor's SQL Shorts
What is a FOREIGN KEY part 1
1:00
What is a SCHEMA for in SQL?
Yor's SQL Shorts
What is a SCHEMA for in SQL?
0:50
How to use ORDER BY in a VIEW
Yor's SQL Shorts
How to use ORDER BY in a VIEW
0:47
Using the COUNT() function & ORDER BY in SQL
Yor's SQL Shorts
Using the COUNT() function & ORDER BY in SQL
0:59
FROM clause part 6: LEFT + INNER JOIN!
Yor's SQL Shorts
FROM clause part 6: LEFT + INNER JOIN!
1:00
UNION vs UNION ALL
Yor's SQL Shorts
UNION vs UNION ALL
0:59
FROM clause part 5: FULL OUTER JOIN
Yor's SQL Shorts
FROM clause part 5: FULL OUTER JOIN
0:32
FROM part 4: RIGHT OUTER JOIN
Yor's SQL Shorts
FROM part 4: RIGHT OUTER JOIN
1:00
FROM clause part 3 LEFT JOIN
Yor's SQL Shorts
FROM clause part 3 LEFT JOIN
0:37
Why you should use a SEMI JOIN in your Queries
Yor's SQL Shorts
Why you should use a SEMI JOIN in your Queries
0:54
FROM clause part 2 INNER JOIN
Yor's SQL Shorts
FROM clause part 2 INNER JOIN
0:53
Primary key Clustered
Yor's SQL Shorts
Primary key Clustered
0:58
Exploring the PATINDEX() function in SQL Server
Yor's SQL Shorts
Exploring the PATINDEX() function in SQL Server
0:57
T SQL Interview question using SUBSTRING
Yor's SQL Shorts
T SQL Interview question using SUBSTRING
1:00
FROM clause part 1
Yor's SQL Shorts
FROM clause part 1
0:56
T-SQL TRIM() & SUBSTRING() function part1
Yor's SQL Shorts
T-SQL TRIM() & SUBSTRING() function part1
0:56
T-SQL LEN() & REPLACE() explained
Yor's SQL Shorts
T-SQL LEN() & REPLACE() explained
0:57
Exploring the SELECT clause in T-SQL
Yor's SQL Shorts
Exploring the SELECT clause in T-SQL
1:01
Shortest T-SQL SELECT statement
Yor's SQL Shorts
Shortest T-SQL SELECT statement
0:31