Interviews are like short refresher courses where you learn different things and its a good habit to retry the questions which you could not answer on the spot.
One of the interesting queries (SQL) i found during one of the interviews was this one which looked so simply but it required little bit of brain storming.
Task : You have 3 tables (Student {StdId, Name}, Course{CourseId,CourseName}, Marks{StdId,CourseId, Marks}) . Select highest scores from each course with course name and student name.
Query :
SELECT C.CourseName,S.Name,M.Marks
FROM ( select courseid,max(marks) as Marks from marks group by courseid ) tmp INNER JOIN Marks M ON tmp.CourseId = M.CourseId AND tmp.Marks = M.Marks INNER JOIN Course C ON C.CourseId = M.CourseId INNER JOIN Student S ON S.StdId = M.StdId ORDER BY M.CourseId
If you are facing issues with MagicJack; like the software keeps on loading then the splash screen disappears then make sure the following things are done :
If you are running skype , close skype first then run MagicJack and if MagicJack's dailing screen appears, then you can turn skype back on . Basically skype is using the same port so if you try running MagicJack after skype , it cannot access that port.
If you are still facing the issue then try deleting the folder For Windows 7 Users : C:\Users\User Name\AppData\Roaming\mjusbsp
The newer update of magicJack was having issues (if you had previous one installed on your system) so if you weren't able to run MagicJack with the above steps then after completing first 2 steps , plug-in MagicJack again and after it has installed and created the folder mentioned in step 2 , run upgrade.exe (the file may be hidden so allow hidden files and folder).
Last week Microsoft presented me with a Samsung Focus smartphone that was running a recent pre-release build of Windows Phone 7.5 “Mango.” Mango is the version of the OS that will replace Windows Phone 7, which launched last year.
Windows Phone Mango brings many new things to Microsoft-powered smartphones, as you can see in the video below. From a messaging perspective, you’ll find combined email inboxes, an improved messaging system that lets users switch between text, IM, and Facebook chat on the fly, and new integration of Twitter and LinkedIn into the social aspects of the People app. In this pre-release build I was testing, Twitter and LinkedIn support were missing.
Many other updates are found in the People app, including new group support for mass messaging and email as well as targeted social networking feeds. New check-in support has been added to the phone so that it is now easy to check-in at a restaurant or an event, and social networking photos (with face tagging) are also available within the People app. The Calendar has been updated to includes tasks from Exchange accounts and appointments from Facebook. I’ll reserve final judgement for all of the new social features until after the final product ships, but so far, at least, Microsoft appears to be moving in the right direction.
Search has been extended all around with special handling of movies, products, and places. A new visual search tool can be used to identify items or read bar codes – or even translate text into different languages (think menus). Local Scout makes it easy to find nearby places to go for food, shopping, or entertainment. I’ve always been a fan of Bing, loving its clean look and organized content. Now things are even better.
The new, and much-hyped, task switching and multitasking features are very nice to have, and I’m looking forward to seeing new apps that take advantage of the background audio system and various other APIs that are being made available to developers. Users won’t have access to pure multitasking in the Android sense, but what Microsoft is offering with Mango appears to be a step beyond what Apple offers in iOS. And that’s more than enough multitasking for countless millions of consumers, if Apple’s sales figures indicate anything.
Microsoft has really been touting the Internet Explorer 9 integration in Mango, with its HTML5 support, but users are also going to love the Smart DJ playlists that the Zune player can create, and gamers will approve of the 3D avatar support and Xbox Live messaging that has been added to the Games Hub. IE9 sounds great in theory, but I’m still not convinced that what we get from it is on par with the WebKit browsers offered by Android, iOS, and webOS. It’s good (and very fast), but in a different way that just doesn’t seem quite has handy on a mobile phone.
While Windows Phone will still not suit every potential smartphone user out there, I feel that the changes Microsoft has put into Mango go a long way towards filling any gaps that existed in the initial release of Windows Phone 7. The best part is that while Mango catches up with the other major smartphone operating systems, it still manages to remain true to itself. It’s different, to be sure, but Microsoft’s OS is beautiful, fast, and powerful as well.
You can get a look at all of these features and more by watching the video above. The Mango release of Windows Phone is expected to show up in devices this fall.
Blog Post from : http://www.wowwindows8.com/windows-phone-7-5-mango-preview/
Hey , i was just planning to run Mac on VMWARE ware and to run this newer version of MAC image , i had to uninstall VMWARE 6.5 and install 7.1 and patch it to run this LION version but , thnx to my PC's configuration i couldn't run it (due to no hardware virtualization) .
And today when i was trying to execute my windows phone application , the simulator would crash saying unvalid startup commands... Dont Panic !!! just delete VMWare 7.1 and restart your system and here u go :)
How often we want to create an application which could generate Alarm in the background and play it on the specified time? Once me and my brother were investigating this same task on iPhone and what we found was... the audio won't play for more then 40 seconds . Implementing the same thing on Windows Phone 7.1 (Mango) is piece of cake :) Just few lines of code and you are done.
I'll demonstrate how to write a simple program which plays any audio which you want :)
Create a new Project
Select Target Framework as 7.1
In you Main.xaml.cs , include the library "Microsoft.Phone.Scheduler".
I've placed the audio file on the root , if you want you can create a folder as audio and place your file there. Then you should navigate as per your need.
Now write the following code
Alarm myAlarm = new Alarm("mmfAlarmTest");
// You need to specify a name for the alarm
myAlarm.BeginTime = DateTime.Now.AddMinutes(1);
// I would like it to play after 1 minute of execution
myAlarm
.Sound = new Uri("/toss-the-feathers.mp3",UriKind.RelativeOrAbsolute);
// Remember my audio file is on the root directory?
ScheduledActionService.Remove("mmfAlarmTest");
// Remove if there exist a similar alarm
ScheduledActionService.Add(myAlarm);
// Register your alarm
And that's it !!! . Test it out and enjoy the fun ;) Using this, you can generate an application which sets alarm through your application
If you want to use the new built-in database in your already created windows phone 7.0 application. You need to do the following things
Change the Framework from 7.0 to 7.1
Add Reference to System.Data.Linq and mscorlib.extensions (most of the websites do not include this, and if you do not add reference to this, you would not be able to implement the interface INotifyPropertyChanging)
Last but not the least , include the following directives
using System.Data.Linq;
using System.Data.Linq.Mapping;
using System.ComponentModel;
using System.Collections.ObjectModel;
Now you are good to go :) you may refer to the following link for assistance in creating database and how to use it:
