Jenil Vasani


SQL Server 2008

Microsoft SQL Server is a computer application used to create desktop, enterprise, and web-based database system.

The current version of SQL Server, SQL Server 2008 was released (RTM) on August 6, 2008 and aims to make data management self-tuning, self organizing, and self maintaining with the development of SQL Server Always On technologies, to provide near-zero downtime. SQL Server 2008 also includes support for structured and semi-structured data, including digital media formats for pictures, audio, video and other multimedia data. In current versions, such multimedia data can be stored as BLOBs (binary large objects).

SQL Server 2008 can be a data storage backend for different varieties of data: XML, email, date and time, file, document, spatial, etc as well as perform search, query, analysis, sharing across all data types.

Other new data types include specialized date and time types and a Spatial data type for location-dependent data and the new FILE STREAM data type, which can be used to reference any file stored on the file system. The Full-Text Search functionality has been integrated with the database engine, which simplifies management and improves performance.

SQL Server includes better compression features, which also helps in improving scalability. It The version of SQL Server Management Studio included with SQL Server 2008 supports IntelliSense for SQL queries against a SQL Server 2008 Database Engine.

Inorder to attend register yourself at MumbaiItPro user group, and if you are already a member book your seat at the link below.

For Registered Members click  here

TO become a member Click here

Event Details
Date : 22nd May 2010
Timing : 3:00 PM to 6:00 PM
Venue: Microsoft Corporation India Pvt. Ltd., Windsor, 4th Floor, Kalina, Santacruz (East)
Speaker Details

Speaker : Mr. Chirag Panchal

MCT(Microsoft Certified Trainer)

April 30, 2010 Posted by | Microsoft, MITP EVENTS | Leave a comment

Business Intelligence Overview

Business Intelligence at first glance is a broad array of applications or technologies designed for storing, gathering, analyzing, and processing information. These applications also provide access to data for professionals and help them make better business decisions.

It is the ability of in depth analysis and data mining of detailed business data to provide real and significant information to users. The software allows users to access and review large amounts of complex data. Yet this is only Business technology on the technical side of the spectrum, in fact we also need to acknowledge the human end, meaning the human views and concepts of Business Intelligence.

Except this infomation other points to be covered are listed below:

  1. Why do we need Business Intelligence?
  2. Who uses Business Intelligence?

and manny such points which helps in Business Intelligence are to be discussed by  Miss Lata.

Inorder to attend register yourself at MumbaiItPro user group, and if you are already a member book your seat at the link below.

For Registered Members click  here

TO become a member Click here

Event Details
Date : 8th May 2010
Timing : 3:00 PM to 6:00 PM
Venue: Microsoft Corporation India Pvt. Ltd., Windsor, 4th Floor, Kalina, Santacruz (East)
Speaker Details

Speaker : Miss Lata L. Bhambwani

April 30, 2010 Posted by | MITP EVENTS | Leave a comment

Session on Office 2010

I am sure all of us use Microsoft Office, let it be Microsoft Word, Microsoft Excel, Microsoft Outlook any one of them. But I am sure all of us are not capable of using all the tools included in it. Am I right. MumbaiITPro a user group is going to held a session on April 10, 2010. MumbaiITPro is an IT user group which conducts regular user group meetings, new contests and all the stuff related to IT is available here.
Microsoft Office Beta is already available for download and as per resources Final Version will be available on July 15 this year. So Manan Kakkar a Microsoft MVP(Microsoft Most Valuable person) has taken up an authority to show what’s new and much more interesting with Office 2010. So hoping you guys will be available at the Session and surely enjoying it.
Session details
Date: 10th April 2010
Timing : 3:00 PM to 6:00 PM
Venue: Microsoft Corporation India Pvt. Ltd., Windsor, 4th Floor, Kalina, Santacruz (East)

Speaker Details

Speaker: Mr. Manan Kakkar

Registrations Open ( TO register you shoudld be a part of MumbaiITPRO usergroup)
Click here

April 3, 2010 Posted by | MITP EVENTS, Office | Leave a comment

IE9 Cocktail Preview

Microsoft in IE8 beta 2 made a commitment not to break the web. Following the same even IE9 cannot be now counted as a single browser. According to looks of it, Compatibility view will survive into the Final version (RTM) of IE9 allowing the browsers to acts as IE5,IE7,IE8 as well as IE9, displaying it on web content it plays nice with modern web standards as it is designed to be more compatible with older versions of Internet Explorer.

Early users can grab the IE9 Platform Preview and start swapping rendering models. Some of the best shortcuts are Alt+5: Force IE5 rendering mode, Alt+7: Force IE7 render mode, Alt+8: Force IE8 Rendering mode and Alt+7 Force IE9 Rendering mode.F12 launches Default developer tools . These developers tools allow users to control the browser mode: IE7, IE8, IE9 but also IE9 with 7 Compatibility view and IE8 8 compatibility view. Document mode is also made available with Quirks Mode,IE7 Standards, IE8 standards and IE9 standard, which are made default. In order to revert the Default Document mode, press ALT+O. .

By looks IE9 is much similar to IE8 and will be much interesting to watch the changes to be included in First public beta of IE9 browser.

March 26, 2010 Posted by | Internet Explorer 9, Microsoft | Leave a comment

IE9 Platform preview available for download

On the second day of MIX10, Microsoft has made available to download platform preview the first release of Internet Explorer 9.It is currently up for grabs for Microsoft.

This preview is designed especially for developers and not for end users. As a developer , you will be happy to know that IE9 includes developer tools by default and no back button for end users. General Manager Dean Hachamovitch was on MIX10 specially to provide a key note on Internet Explorer 9.

Currently first bits of IE9 are available for download and are named as Platform Preview. IE9 will be very first browser to take standard web patterns that developers use and run them on modern PCs. IE9 also brings expanded support with HTML-5 and hardware accelerated graphics and text with newly enabled JavaScript engine designed specially to boost the performance of the browser. With addition of NVDIA GPUs IE9 removes glass ceiling for web developers, enabling them to build basically high performance web applications.

The new JavaScript engine enabled for IE9 was codenamed Chakra, and that it delivers level of performance almost on par with it rivals.

TO download IE9 Platform Preview click here

March 17, 2010 Posted by | Internet Explorer 9, Microsoft | Leave a comment

Give your presentation impact with images and video

Want to really capture your audience’s attention? The new picture and video editing tools in Microsoft PowerPoint 2010 can help turn your next presentation into a real crowd-pleaser. You can quickly crop, add effects or correct colours in your images without any additional photo-editing software. And adding cool special effects like fades, reflections, or 3-D rotation to embedded video clips is a great way to wow a crowd

It’s easy to give your presentation more cinematic quality with some eye-catching video.

  1. Click the Insert tab on the Ribbon, and Video on the far right. 
  2. Choose from File
  3. Click through the menu to insert your video, and select the commands in the View Tools tab of the Ribbon to Trim, Bookmark, Fade in, or Loop your video.

Pictures speak a thousand words.

The picture-editing tools in PowerPoint 2010 can turn your presentation
into a work of art:

  1. Insert a picture onto a slide, using the Insert tab on the Ribbon.
  2. When the picture is inserted, the Picture Tools tab displays all of
    the editing options available. If you already have a picture on your
    slide, double-click it to display the Picture Tools tab.
3. Click Artistic Effects to preview more than 20 effects to apply to
your photo right away.

March 5, 2010 Posted by | Office 2010 | Leave a comment

Register now for Office 2010 preview in your Ciy

Good News for IT Professionals. For the first time ever Microsoft is starting an event for a half day session for Office 2010 Productivity suite.

Please visit the booked destination to learn from Microsoft experts on how office 2010 is places with various productivity tools, and online services. The new Microsoft office 2010 is designed to be a common platform across the PC,Phone,Web network.

Hurry! Register now to have the first preview of Microsoft Office 2010 and build awareness.

March 5, 2010 Posted by | Microsoft, Office | Leave a comment

Top 10 reasons to use Windows 7

Windows 7  was released on    13th July 2009 but even today i find most of the people still using Windows XP or Vista.  I don’t understand that why people are not getting used to the latest technology? Probably all the functions which are available in the older versions are also available in Windows 7. Also there are other various functions which are available. Let me list down such reasons why people should migrate to Windows 7.

  1. Get Quicker Access to all your stuff : Ping and Jump List the most reliable tool in windows seven to make use of your files on your fingertips.
  2. Search: You can quickly find the details required in specific file, program or in your email using Search option in Windows seven. Windows Seven has included advance search which I think is known as Instant search.
  3. Share File and Printers : Because data sharing is most important Windows Seven has continued the options of Sharing of File and Printers in Seven too.
  4. Get Entertained: With Windows Media Center you can now watch Videos and Pictures. NOt only that Media Center now comes with Internet TV. You can not only watch TV but also record live TV.
  5. Manage Open Windows more easily: You can resize and arrange windows simply by dragging their borders on you desktop screen.
  6. Dont Leave your programs behind: Yes does your application only work on Windows XP? If that is seven then you can use Windows 7 because Windows Seven offers  XP mode which helps to open the applications in XP.
  7. Easily create and share movies: Create great movies and slide shows and share them on Internet or YouTube easily.
  8. Do More Wait Less: This slogan is well implemented in Windows seven. Improvements done in to accelerate Sleep and resume and make your Pc more responsive help t o get it more done.
  9. Connect it to network easily:  You can now connect yourself to Wireless network in just 3 clicks.
  10. Protection: Windows 7 offers more security than any other operating system with help of applications like Microsoft security essentials, BitLocker and Application Locker.
    Windows 7


So what are you waiting for? GO and get Windows Seven installed in your PC today and have fun and stay connected.

March 1, 2010 Posted by | Windows 7 | 1 Comment

Watch TV on your PC for free

I remember I mostly had some assignments work in my PC and have to leave my favorite cricket matches. but now I sit and watch TV on my PC. You might be thinking that I must be using splitter for that. No not at all.

In  today’s computer world you don’t need to rush to watch TV and work at the same time. That’s because today technology has blurred the gap line between PCs and TVs. Now I sit and watch Internet TV on my Windows 7 based PC, and I realized that the line isn’t blurred as much as it is transparent.

On name Internet TV you might be wondering what is Internet TV? Isn’t that so. Let me clear you. Internet TV is a latest feature that is introduced in Windows Media Center that delivers your favorite entertainment over a broadband internet connection, and without even losing a single penny!! Now isn’t that good, it has wide variety of range from episodes to top broadcaster including news and event programs. So what are you waiting for?? Follow the following steps and get started. Also if you have membership of Netflix you can access wide range of movies and TV shows made available through Netfix.

You might be wondering what are the requirements?? Let me tell you the simplest things which are required

  1. Internet Connection
  2. Windows Seven Premium or Better

Now setting up an Internet TV in your Windows 7 PC

1.You can click here to launch  Internet TV in WIndows media Center( or open Windows Media Center button from Start) and click continue on welcome page.

2. You will be provided with two options Custom Install or Express Install. In order to make your things easy always choose Express Install. To make advantages of advance settings you can choose Custom Install and also if y ou choose Express Install you can make changes to Custom Install later to change the setting

3.Once you follow this you will be gifted with other wizard just end it on Complete setup. After completing the setup download 5MB file of Internet TV and again install it. It hardly takes any space in your hard drive.Once that is completed you will find the option of Internet TV under TV. an programmin guide.

Using Programming Guide

TV guide is just a normal guide which keeps the things much simpler and easy.To use this option Scroll down to TV, you will see different TV options, find guide option and click on it.If you want to add broadcast TV to your lineup, just add a TV Tuner and connect it to an over-the-air antenna for free HDTV (subject to local coverage) or your existing cable subscription to get access to your basic cable programming

Work and play at the same time

Just as you always do while listening to music in same manner while watching TV just minimize the screen or resize the window to work and watch simultaneously.

NOTE: Internet access required. Free Internet TV content varies by geography. Some content may require additional fees.

February 28, 2010 Posted by | Microsoft, Tips, Windows 7 | Leave a comment

What is the Public Folder & How to Use it

If you are a Windows Vista user you might have come around the word Public Folder . It is not a big feature but rather than that it’s just a slightly special setup which can be used in certain scenarios. Hence this feature is also kept in Windows 7.

What is the public Folder in Windows 7?

If you want to find the Public folder it is found in ‘C:\USERS\PUBLIC’ and in this folder you will find all the registered users who have access to your computer. All that is saved in that folder have access too all the users who have account in that Computer. Also depending on your settings you can make the folder to be accessed by the computers on the same network.

Folder Contents

As a Public folder this folder contains its sub folders. Just like shared documents, shared music, shared pictures and such things we have Public Documents , Public Downloads, Public Music, public Videos etc… These folders contains sample files for each folders just like we have shared pictures like Blue Hills, Sunset , Water lilies in XP.

The Public folder also contains a series of hidden folders such as: Favorites, Libraries and Public Desktop. By default, these folders are empty.

Making use of this Public Folder

Using this Public folder is your choice. I mostly don’t use this folder but that doesn’t mean that this is not handy. For e.g. If there are 3 users in my Pc, and all of them want to use a same file to have some or other things to do on it. So I will make that Folder public and ask the other followers to just perform the work which I have described in that folder in my absence. Hence Public Folder can me more useful in that case. The Public folder can also be used for sharing files with other computers on your network. If you choose to share this folder, other computers can access its contents.

Share/Unshare the public Folder

By default, this folder is not activated . In order to enable/disable this folder from sharing you need to open the Advance Sharing Settings panel.

Finally arriving to the conclusion this feature is not that important if you don’t have multiple accounts in your machine and there are various other ways to share the folder in your netowrk.If you are on network and want to share the limited things you can use this folder and also ask for people from the network to same file in Public Folder from their machine in your absence. I would say I don’t prefer this folder due to various types of people in your network  if a person contains a high variation viruses there is possibility that they may harm your computer. So its better to be safe and secure rather than going for a suicide

February 28, 2010 Posted by | Microsoft, Tips, Windows 7 | 2 Comments