• SQL Server interview questions and answers :-What is CDC( Change data capture ) ?
    Articles,  Blog

    SQL Server interview questions and answers :-What is CDC( Change data capture ) ?

    In this video will try to understand what exactly is CDC CDC stands for Change Data Capture Many times in projects we would like to go and maintain audit trail for a table On the screen you know I have a simple sales table here I have two records here Shiv and Raju Somebody changes shiv to shiva Then I would like to maintain some kind of audit trail table where I can get the old values and the new values CDC helps us to capture insert, update and delete activities on table data Now enabling CDC is a two step process the first thing is we need to go…

  • SQL Server interview question / training :- What is page split and how is performance impacted?
    Articles,  Blog

    SQL Server interview question / training :- What is page split and how is performance impacted?

    In the previous part of the video we saw that how Indexes help us to make our search faster but you know there is saying going the market which says that basically whatever good comes right it always comes with some drawback and some disclaimers and the same also holes true for indexes so in this video i’ll take about the other part of the story that how indexes impact insert update and delete a operation’s so in order to demonstrate how indexes impact Insert update and deletes here is a simple table i have created called as My Table and in this My Table we have two fields one…

  • SSRS Video :- How to create a simple report in SQL Server reporting services ?
    Articles,  Blog

    SSRS Video :- How to create a simple report in SQL Server reporting services ?

    So till now we have seen that how we can use SQL Server integration service to collect data from various sources like excel, CSV, SQL Server, oracle etc and then we can dump this data into a centralize database like data warehouse How we can use SQL Server analysis service to create a cube and by creating a cube you can then get a multi dimension view of the data Now we are on the final phase where we would like to and view this analyse data and that is done by using SQL Server reporting service We have seen how we can collect data by using SSIS how we…

  • Installed SQL Server?…Now What? (Getting Started)
    Articles,  Blog

    Installed SQL Server?…Now What? (Getting Started)

    Hi. I’m Jason Roth. In the last video we installed SQL Server 2008 R2. If you’re new to SQL Server, you may be thinking, “Now What?” In this video I’ll show you how to create your first database. We’ll then install a sample AdventureWorks database. And we’ll conclude by importing a spreadsheet into a database. This is not a video on database design, but it should give you some invaluable hands-on experience with the tools. And you can immediately begin using SQL Server. It all starts with a tool called SQL Server Management Studio. On the “Start Menu”, click “All Programs”, expand “Microsoft SQL Server 2008 R2”, and then start…

  • SQL Server training :- How to implement Pivot?
    Articles,  Blog

    SQL Server training :- How to implement Pivot?

    In this video we will try to understand how can we implement Pivot and Unpivot in SQL Server now before we go ahead and we try to implement Pivot in SQL Server first let’s try to understand what exactly a Pivot means so in order to understand the Pivot function you can see that i have created a very simple table here which has three columns 1 is customer Name Product Name and amount and you can see that i have couple of record here saying Shiv has bought shoes for 100 Rupees then Shiv has bought Shirts for 200 rupees Raju has bought shirts but Raju has not bought…

  • SQL Server interview question :- Explain RowNumber,Partition,Rank and DenseRank ?
    Articles,  Blog

    SQL Server interview question :- Explain RowNumber,Partition,Rank and DenseRank ?

    In this video we will try to understand three important functions First one is Row Number second one is Partition and the last one is Rank function so now in order to understand this three functions you can see that i have created a very simple table here called as the sales table and this sales table has four columns here customer name product name, amount, vendor name and you can see some record over here five records Shiv has bought shoes from bata Raju has bought bags from Bata Sukesh has bought perfume from Archies and etc.. etc.. now this data over here is very nice but what we…

  • What is the difference between UNION and UNION All ( SQl server )?
    Articles,  Blog

    What is the difference between UNION and UNION All ( SQl server )?

    In this video my papa will explain you what is the difference between UNION and UNION All I know This is a tough question in the interview That was my kid Sanjana As she has said that in this video we are going to talk about what is the difference between Union and Union All You can see on your screen there are two tables here one is called as the Ancillary Table and the other one is called as a Main Product Table The Ancillary table has a product name and the amount while the main product also has a product name and the amount Select * from Ancillary…

  • SQL Server training and interview question:-What is index and how does it make your search faster ?.
    Articles,  Blog

    SQL Server training and interview question:-What is index and how does it make your search faster ?.

    In this video will try to understand what exactly is a index and how does index makes such search text faster Lets try to understand what is the goal of index The only goal of a index or the only purposes of a index is to make you search faster How does index actually makes search faster Indexes makes a search faster by creating something called as a B-Tree structure or a Balanced Tree structure internally In this video first lets understand this theory of balanced tree structure Then we will see a practical demonstration of how index makes your search faster Before we start things practically First try to…

  • SQL Server interview questions :- What are Sub Query and Co-related Queries ?
    Articles,  Blog

    SQL Server interview questions :- What are Sub Query and Co-related Queries ?

    In this video will talk about what is a subquery what are co-related queries and what’s a difference between subquery and co related queries so first let start the subquery subquery also termed as nested queries subquery is nothing but it’s a query inside a query many times you know you would like to you have series of SQL chained you know where output of one query is sent as the input to the other query for filtering and manipulation for example you can see in the figure you know we have two tables one table has the employee salary and the second table has phone numbers now let say…

  • SQL Server training :- When do we apply de-normalization ?(Interview question)
    Articles,  Blog

    SQL Server training :- When do we apply de-normalization ?(Interview question)

    In the previous part of the video we saw the benefits of normalization we also saw how normalization help’s you to avoid redundant data and error data enter into your systems now i am sure that somewhere in your mind the three normal forms have must becomes golden rules for database designing but that hang one there is other side of the story as well we need to understand before we go and apply this normalization as golden rules for database designing in order to understand the other part of the story let us first understand the larger classification of IT systems from the data perspective from the data perspective…