T-SQL: Find gap ranges using ROW_NUMBER()

Here I will be demonstrating how you can find gaps with help of the T_SQL function ROW_NUMBER() which I described in the previous video. In the first part I will write a query that shows where each gap begins and ends. In the second query I will show you how you generate a list of missing values.


Please leave feedback if this was helpful. Thanks!

T-SQL: ROW_NUMBER(), RANK(), DENSE_RANK() & NTILE()

In this video I'm demonstrating the following T-SQL functions: Row_Number(), Rank(), Dense_Rank(), Ntile()


Please leave feedback if this was helpful. Thanks!

SSIS: Importing an Excel file using conditional split & exporting results into multiple textfiles

This tutorial will demonstrate how to use SSIS for an Excel file import & then based on several case conditions splitting the results by exporting them to multiple textfiles.


Hope you enjoy it! Please leave feedback if this was helpful. Thanks!

SSIS: Importing a CSV file into a SQL Server and possible related issues due to mismatching datatypes

This video will demonstrate how to import a CSV file into a SQL Server database table. No matter if Excel sheet or CSV file, it is very likely that you will face some datatype conflicts due to different source file and destination defined datatypes. This video should explain how to solve common import issues.

Hope you enjoy it! Please leave feedback if this was helpful. Thanks!

C#: Using Datasets in multiple Forms and visualizing Dataset values in a Chart

This video will describe how you can use the same dataset in multiple forms. In the second half of the video, I will extract data and display this dynamically in a chart!

If this was helpful please leave feedback. Thanks!

C#: Downloading financial data from the web and displaying it in a DataGridView

Here's a video about how to download a csv file and importing it in a DataGridView. Enjoy!

Hope you enjoyed it please leave feedback. Thanks!

C#: Establishing a connection to SQL Server and return values in a Windows Form

Welcome to my blog! This is my first contribution. I will demonstrate in C# how to establish a connection to a MS SQL Server, create a small Windows Form where values are listed and returned.


I hopefully will be adding more videos concerning everything around Business Intelligence and Data Mining. Expect to see videos around MS SQL Server, SSAS, SSIS, SSRS, R, WPF etc.

Hope you enjoyed it please leave feedback. Thanks!