It’s always a happy day when you make the switch to SQLOPS!

Inline table valued function in SQL Server || SQL inline table valued function

Event Handlers in SSIS || Learn to use Event Handlers in SSIS

Troubleshooting Errors in SSIS Package in SQL Server || Debug SSIS packages

SQL views explained || Using Data Viewers in SQL Server

Breakpoints in SQL Server Explained || Debug SQL code

Learn to Deploy SSIS Packages to Catalog in SQL Server

Learn to write Self Contained Subqueries in SQL Server

Multi-valued Subqueries in SQL Server || Subquery in SQL Server

Co-related subqueries in SQL Server explained

Using Exists with Subqueries in SQL Server || Subquery in SQL Server

Using Table Expressions in SQL Server

How to run SSIS packages in T-SQL

Common Table Expressions in SQL Server || CTE Tutorial

Learn Table valued Functions in SQL server || Inline table valued functions

Tutorial on Derived tables in SQL server || Using Derived Tables

Learning Apply Operator in SQL server || SQL Apply Operator

Using Set Operators in SQL Server || SQL Set Operators

Outer Apply Operator in SQL Server

Cross Apply in SQL Sever || Using Cross Apply operator

Learning Window Functions with over in SQL server || Window functions tutorial

Window Functions in SQL server || SQL window functions explained

Pivot in SQL Server || Pivoting and Grouping Sets in SQL

Grouping Sets in SQL Server || CUBE and ROLLUP in SQL

SQL Query Optimization - Best Practices for More Efficient Queries