Free SQL Server video tutorial

Connecting to SQL Server
Working with databases
Creating and working with tables
Default Constraint
Cascading referential integrity
Check Constraint
Identity Column
Retrieving identity column value
Unique key constraint
All about select statement
Group By
Basic Joins
Advanced Joins
Self join
Different ways to replace NULL
Coalesce function
Union and Union All
Stored Procedures
Stored Procedures with output parameters
Difference between output Read More →

SQL Server APPLY operator has two variants; CROSS APPLY and OUTER APPLY

The CROSS APPLY operator returns only those rows from the left table expression (in its final output) if it matches with the right table expression. In other words, the right table expression returns rows for the left table expression match only.
The OUTER APPLY operator Read More →

Code Source : https://github.com/BrandonJoffe/home_surveillance
Smart security is the future, and with the help of the open source community and technology available today, an affordable intelligent video analytics system is within our reach. This application is a low-cost, adaptive and extensible surveillance system focused on identifying and alerting for potential home intruders. It can integrate into an Read More →

What is Streaming?
Streaming is a technique in which the server provides the response to a request in chunks. I can think of a couple of reasons why this might be useful:

Very large responses. Having to assemble a response in memory only to return it to the client can be inefficient for very large responses. An Read More →