Language Lassi

In this post we will try to crate a package that extract the data from 'Student Table' of Source-Database and load it successfully in 'Student Table' of 'Destination-Database'. You can Download or look into the sample database I am using. System requirements for SSIS or Business intelligence Development: You should have installed SQL Server Standard or Enterprise version. I am using Visual Studio Add-in (SQL Server Data Tools) in this SSIS tutorial to design SSIS package. This needs SSDT also to be installed. Once confirmed that SSDT is installed on machine. We are ready to create an ETL(Extract - Transform - Load) package. So here we go! Here are the scripts that you can run in order to generate two databases(Source and destination) with Tables in it. Go to Start Screen or Click Start Button. Go to Microsoft SQL Server and you will find 'SQL Server Business Intelligence Development Studio' under this. Open SQL Server business Inte...

As Safari HTML Audio Video Guide Suggests: Syncing Multiple Media Elements Together Until the advent of media controllers , ensuring that two or more videos played at precisely the same time was a challenging endeavor. Media controllers let you group any number of audio and/or video elements so that they can be managed by a universal set of controls, and also so that they can be kept in perfect sync, even if a network hiccup occurs. To create a media controller, simply add the mediagroup attribute to all of the elements you wish to sync together. The value you choose to assign to mediagroup is up to you—as long as the value is the same for each slaved element, a media controller will be created implicitly. Most of the same functions, attributes, and events available to audio and video elements are also available to media controllers. Instead of calling play() or pause() directly on the video itself, you call them on the media controller. Controlling Media with JavaSc...

If you are looking for the performance difference between INNER JOIN(Explicit Join) and WHERE clause(Implicit Join) , Let me clear the SQL Engine(either its mySql/SQL Server or Oracle) got more and more intelligent during the time. So there is no such difference in performance whatever you write from INNER JOIN or WHERE clause. Let me write a simple query using WHERE clause or Implicit Join: This SQL Query is written with only 4 tables, 5-10 tables in queries is common scenario while you are working with a good size of project. And believe me or not, writing these queries with WHERE clause is definitely going to get your head off the shoulders. Now let me write it using INNER JOIN or Explicit Join: The later one is hell more readable than the conventional(not now though) WHERE clause written above. Here is an Execution Plan for INNER JOIN and WHERE clause, which is same for both the cases: Execution Plan Comparison: Implicit Join vs Explicit Join Exec...