Skip to main content

Posts

Showing posts from 2015

How To Update TFS Workspace Using Visual Studio 2013

As part of the information about a workspace, the version control server records the name of the computer that hosts a workspace and the user that owns the workspace.  If you need to change your computer name or your user name, how do you tell the server to update the workspace information? There are different workspace commands that can be used to permission different issues. Some important workspace commands for Team Foundation Server tf workspaces [/owner:ownername] [/computer:computername] [/collection:TeamProjectCollectionUrl] [/format:(brief|detailed)] [/updateUserName:oldUserName] [/updateComputerName:oldComputerName] [workspacename][/login:username,[password]] source: Workspaces Commands For doing it using command prompt, Go to Visual Studio Tools and run the Command Prompt. Then select appropriate directory and run below command. C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE tf workspaces /updateComputerName:OldComputerName /s:"http://

How To Append Data to HTML5 localStorage or sessionStorage?

The localStorage property allows you to access a local Storage object. localStorage is similar to sessionStorage. The only difference is that, while data stored in localStorage has no expiration time untill unless user deletes his cache, data stored in sessionStorage gets cleared when the originating window or tab get closed. These are new HTML5 objects and provide these methods to deal with it: The following snippet accesses the current domain's local Storage object and adds a data item to it using Storage.setItem() . localStorage.setItem('myFav', 'Taylor Swift'); or you can use the keyname directly as : localStorage.myFav = 'Taylor Swift'; To grab the value set in localStorage or sessionStorage, we can use localStorage.getItem("myFav"); or localStorage.myFav There's no append function for localStorage or sessionStorage objects. It's not hard to write one though.The simplest solution goes here: But we can kee

How To Create SSIS Package, Example With Diagrams

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

How To Play Multiple HTML5 Audio-Video in Sync on Safari Browser

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

Difference Between Implicit and Explicit Join

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

Cannot Modify Header Information - Headers Already Sent : How To Fix

This error message gets triggered when anything is sent before you send HTTP headers (with setcookie or header). Common reasons for outputting something before the HTTP headers are: 1. Accidental whitespace, often at the beginning or end of files, like this: the space before "php opening tag" To avoid this, simply leave out the closing ?> - it's not required anyways. 2. " Byte order marks " at the beginning of a php file. Examine your php files with a hex editor to find out whether that's the case. They should start with the bytes 3F 3C. You can safely remove the BOM EF BB BF from the start of files. 3. Explicit output, such as calls to echo, printf, readfile, passthru, code before php opening tag etc. 4. A warning outputted by php, if the display_errors php.ini property is set. Instead of crashing on a programmer mistake, php silently fixes the error and emits a warning. While you can modify the display_errors or error_reporting configurations

MVC Interview Questions

What are the 3 main components of an ASP.NET MVC application? 1. M - Model 2. V - View 3. C - Controller In which assembly is the MVC framework defined? System.Web.Mvc Is it possible to combine ASP.NET webforms and ASP.MVC and develop a single web application? Yes, it is possible to combine ASP.NET webforms and ASP.MVC and develop a single web application. What does Model, View and Controller represent in an MVC application? Model: Model represents the application data domain. In short the applications business logic is contained with in the model. View: Views represent the user interface, with which the end users interact. In short the all the user interface logic is contained with in the UI. Controller: Controller is the component that responds to user actions. Based on the user actions, the respective controller, work with the model, and selects a view to render that displays the user interface. The user input logic is contained with in the controller. What is the