|Videos Title||Category||Views||Posted On||Posted By
What is TPL ( Task Parallel Library ) in .NET 4.0 ? New
In this video we will see 3 big uses of TPL( Task parallel library) parallel processing,pooling and abstraction. We also point out how task differ from threads.
SSIS Lesson 3 - Extra data from a sql server table into a Flat file using SSIS import and Export wizard
Hi friends, I was busy with some personal works these day. So, I couldn't share my knowldge with u. I am back with a new video tutorial on SSIS.
Here is my latest ssis video tutorial on how to extract data from a sql server table into a flat file:
C# interview question :-What is the difference between "==" and ".Equals()" comparision ?
This video will show us difference between == vs .Equals().
C# interview question with answers :- What is the use of Yield keyword in C# ?
In this video we will try to understand what exactly use of Yield keyword in C#.
SQL Server interview question :- Find the second highest salary ?
Many times during SQL server interviews , many of them ask this tricky question "Find the second highest or 3rd highest from a given table" or probably they can also vice versa saying "Find the second or third lowest from a given table". In this video we will try to answer the same.
SSIS Tutorial 2 - Load data from excel file into sql server table
Hi friends, this video will demonstrate how to create a new SSIS package using SSIS import and export wizard. In this ssis tutorial, example to load data from excel into sql server table is very well explained. Hope this ssis tutorial will help you learning ssis.
SSIS tutorial 1 - Introduction to SSIS
Hi friends, This ssis video tutorial will give you brief introduction to ssis and will guide you about how to start ssis.
CTE in SQL SERVER
CTE - Common table expression.
This video have complete information about CTE like what is CTE , properties of CTE and examples for CTE in sql server.
C# and .NET interview question: - What is operator overloading in C# ?
In this video we will try to understand what is operator overloading in c# and how we can add our own custom logic to a operator. This is also a much asked c# interview question which is making round in .NET and C# interviews.
SQL Server training :- How to implement Pivot?
In this video we will try to implement Simple Pivot function in SQL Server. So we will take a simple customer and product data and pivot them on the basis of customer name and product name.
SQL SERVER interview question - What are the different System databases in sql server ??
In this video we will see what are all the system databases in sql server.
There are 6 system databases in sql server
5 mssqlsystemresource (Resource)
To know more about system databases in sql server, visit the below link:
Difference between ViewData, ViewBag, TempData and Session in MVC.
In this MVC ( Model view controller) video we will try to understand what is the difference between viewdata,viewbag,tempdata and session.This is an interesting MVC interview question and below is a textual answer for the same.
Temp data: - Helps to maintain data when you move from one controller to other controller or from one action to other action. In other words when you redirect, "tempdata" helps to maintain data between those redirects. It internally uses session variables.
View data: - Helps to maintain data when you move from controller to view.
View Bag: - It's a dynamic wrapper around view data. When you use "Viewbag" type casting is not required.