Learn and Grow

This is a simple explanation on how to backup a DB in SQL Server

This is a simple explanation on how to give a user access to the DB in SQL Server

This is a simple explanation on how to create and use the CREATE LOGIN in SQL SERVER.

This is a simple explanation on how to create and use the BULK INSERT in SQL SERVER.

DOFACTORY.COM https://www.dofactory.com/sql/interview-questions

This is a brief overview of the recovery models in Microsoft SQL Server. SQLSERVERTUTORIAL.NET https://www.sqlservertutorial.net/sql-server-administration/sql-server-recovery-model/

This is a brief overview of the system databases in Microsoft SQL Server.

This is a simple explanation on how to create and use an Inline Table Valued-Function.

This is a simple explanation on how to create and use a VIEW in SQL.

This is a simple explanation on how to use the SQL INTERSECT Operator.

This is a simple explanation on how to use the SQL Stored Procedure.

This is a simple explanation on how to use the SQL EXISTS Operator.

This is a simple explanation on how to use the SQL EXCEPT Operator.

This is a simple explanation on how to use the SQL GROUP BY ROLLUP Sub-Clause.

This is a simple explanation on how to use the SQL GROUP BY CUBE Sub-Clause.

This is a simple explanation on how to use the SQL SELF JOIN.

This is a simple explanation on how to use the SQL Server SYNONYM Statement.

This is a simple explanation on how to use the SQL CROSS JOIN Clause.

This is a simple explanation on how to use the SQL LEFT and RIGHT JOIN Clause.

This is a simple explanation on how to use the SQL INNER JOIN Clause.

This is a simple explanation on how to use the SQL FIRST_VALUE and LAST_VALUE Function.

This is a simple explanation on how to use the SQL LEAD and LAG Function.

This is a simple explanation on how to use the SQL RANK and DENSE_RANK Function.

This is a simple explanation on how to use the SQL ROW_NUMBER Function.

This is an introduction to the SQL Server Mathematical Functions.