Archive for March, 2009

27th Mar 2009

Top 10 Strategic Technologies for 2009

Gartner, Inc. analysts highlighted the top 10 technologies and trends that will be strategic for most organizations. Factors that denote significant impact include a high potential for disruption to IT or the business, the need for a major dollar investment, or the risk of being late to adopt.

The top 10 strategic technologies for 2009 include:

Virtualization. Much of the current buzz is focused on server virtualization, but virtualization in storage and client devices is also moving rapidly.

Cloud Computing. Cloud computing is a style of computing that characterizes a model in which providers deliver a variety of IT-enabled capabilities to consumers

ServersBeyond Blades. Servers are evolving beyond the blade server stage that exists today. This evolution will simplify the provisioning of capacity to meet growing needs.

Web-Oriented Architectures. The Internet is arguably the best example of an agile, interoperable and scalable service-oriented environment in existence.

EnterpriseMashups. Enterprises are now investigating taking mashups from cool Web hobby to enterprise-class systems to augment their models for delivering and managing applications.

Specialized Systems. Appliances have been used to accomplish IT purposes, but only with a few classes of function have appliances prevailed.

Social Software and Social Networking. Social software includes a broad range of technologies, such as social networking, social collaboration, social media and social validation.

Unified Communications. During the next five years, the number of different communications vendors with which a typical organization works with will be reduced by at least 50 percent.

Business Intelligence. Business Intelligence (BI) have a direct positive impact on a company’s business performance, dramatically improving its ability to accomplish its mission by making smarter decisions at every level of the business from corporate strategy to operational processes.

Green IT. Shifting to more efficient products and approaches can allow for more equipment to fit within an energy footprint, or to fit into a previously filled center.

Reference : Pinal Dave (http://blog.sqlauthority.com), Gartner Inc.(Published after receiving permission)

Posted by Posted by pinaldave under Filed under Uncategorized Comments No Comments »

23rd Mar 2009

Coding War Games Photos

Posted by Posted by abhishek under Filed under developer event Comments No Comments »

22nd Mar 2009

Coding War Games Videos

All the teams had lot of fun while coding for 24 hours at a stretch. I was really surprised at the level of sincerity in this event. Most of them did not even move much while coding for 24 hours. At 2-3 am in the night work was being done as if it is the matter of life and death.

Thank you all the participants for making this event a success. I would write a detail post about this later on may be but meanwhile enjoy following 2 videos created out the photos I had taken. Keep the speakers on.

Posted by Posted by abhishek under Filed under developer event Comments No Comments »

21st Mar 2009

Coding War Game Definition

Ok so the much awaited Coding War Game is started and following is the definition of the software they are supposed to build in 24 hours!!

Objective:
Every year in India thousands of students graduates from Engineering and other colleges after completing their final semester project. Every year hundreds of interesting projects gets done but after graduation they are forgotten and kept aside. This is a major problem because lots of talent gets wasted in this process. 6 Months of students life goes in vein just like that.

Solution:
Solution is to build online global repository where these students can submit their project details and can make them available for others perusal. Interested students can search for interesting ideas for their final semester projects or corporates can look out for students who have done exceptional projects in their working domain. Students and Corporates can rate the projects and thus credibility of the creator is increased.

Implementation:
Allow students to register to the site using following fields

Name*:
College Name*:
College Location:
Stream:
Year/Semester:
Contact Number:
Email*:
Username*:
Password*:

- email activation is not required. neither admin approval is required in user registration.
- user should be able to login with username/password and should be able to edit his profile details.
- user should be able to logout from the site.

- allow students to upload their project work which may contain following fields
1) Project Name*
2) Project Description*
3) Company at which project is done
4) UML diagrams
5) DFD
6) ER Diagram
7) Project report
8 ) Demo Presentation
9) Company Profile
10) Various other documents depending on the field of student and project

- users have ability to make their data (4 to 10) downloadable or not downloadable
- users should be able to edit the project data.
- admin approval is not required for projects to get activated on client side.
- allow unregistered or registered members of the site to search for the projects on keywords
- display search result in visually appealing manner (use your creativity)
- display project details in visually appealing manner (use your creativity)
- to contact the creator of the project one has to register and login (this will be corporates who are interested in hiring the person or knowing more about the project).

- Allow companies to register using following fields
Company Name*
Address
Contact Number
Brief about company
Email*
Username*
Password*

- registered companies can login and contact the creator of the project.
- registered companies can also modify their profile
- registered students can also login and contact the creator of the project
- allow registered and unregistered users to rate the projects and put their comments on project detail page.
- Homepage/Front page should contain
1) recently uploaded projects
2) highest rated projects
3) recent comments by users on projects
4) recently registered companies
5) search facility
5) register/login

- You are free to add any other feature on homepage
- You can use your creativity to design the application and to decide the workflow.

Posted by Posted by abhishek under Filed under developer event Comments No Comments »

19th Mar 2009

How to Find All SQL Server Instance Running in Local Network

I will start my blogging with Digicorp with very simple but useful trick. When working with multiple project, it is quite common to forget the name of the SQL Server instances. We can retrieve information of all the SQL Server instances running in local network with one single command.

First go to Start >> Run >> CMD (Open command prompt). Once in command prompt run following command based on SQL Server version installed on local machine.

For SQL Server 2000:
C:\> isql -L

For SQL Server 2005 / SQL Server 2008:
C:\> osql -L
OR
C:\> sqlcmd -L

It is also possible that list of SQL Server instances is very long and it needs to be pushed to an output file. In that case add additional command to send output to a file.

For SQL Server 2000:
C:\> isql -L > c:\outputfile.txt

For SQL Server 2005 / SQL Server 2008:
C:\> osql -L c:\outputfile.txt
OR
C:\> sqlcmd -L c:\outputfile.txt

This feature is also important for network security. There are chances that system administrator does not know about some of the SQL Server Instance being active. In large organization this can be huge security threat. If any SQL Server instance is not used it should be turned off because it uses resources of server and adversely affect performance.

Just try this simple command on your local machine and I am sure you will in for surprise. There will be lot more SQL Server Instance running then you might have thought of. Your feedback is very valuable.

Regards,
Pinal Dave

Posted by Posted by pinaldave under Filed under SQL Server Comments 5 Comments »

02nd Mar 2009

Connect to Console using Terminal Services Client

Many of us use windows remote desktop in order to connect and control remote PC or server. However, if you need to see user’s current desktop(console), we generally rely on third party tools like UltraVNC.

This feature is also available with Windows 2003 Terminal Services!! With this feature, user can connect to the console – the desktop of the actual server, rather than a terminal server session.

This is done by starting the Terminal Services client with the /console switch:

mstsc /console

However, this isn’t possible using the terminal services client that is supplied with Windows Mobile as you cannot adjust the settings of the connection.

I hope this information is helpful to you.

Posted by Posted by sanket under Filed under Uncategorized Comments No Comments »