How to deal with over smart people

Today, I am going write some thing not technical, As I feel I am doing that for quite a time I should write about it. In today’s competitive world people wants to show their skills to companies and how important they are but some people are becoming over smart people. They always eager to show their smartness and make themselves highlighted. They take credits for task they have not done etc. I personally don’t like this kind of people but sometimes we have to bare with this kind people. So in this blog post, I am going tell different way of dealing with over smart people.

1. First and foremost thing you can do is you can Ignore them. You don’t need to give attention what they are saying as you know they are acting over smart.
2. This kind of people believes that they are smartest person on the earth. Don’t argue with that feeling otherwise you will not able to deal with this kind of people. Just ignore it and let it be. Complete your work with them and let them do what they want to do.
3. Try working with them instead of against openly with them. If you against them,They will never understand your point because they think they are smarter then you.
4. Maintain a polite and civil manner with them whatever they say. Keep your self calm and compose. Soon they started notices you that you are not in competitions with them they are motivated to treat you nicer then earlier.
5. Don’t take their over smartness personally.
6. Always keep backup plan if you involve this kind of person or give them some responsibilities. So in worst condition you will have plan B if Plan A is not successfully implemented by this kind of people and this will likely to happen.
7. Keep boss aware what you are doing instead of be in competition of with kind of person. It will impact more then anything.
8. If you think this people are hard to bare minimize the contact with them.
9. Demonstrate your view that you view everyone as equal not as a superior or inferior.

I hope this will help you dealing with over smart people. Remember following quote always.

“If you think that you're so smart and holy, that means you haven't yet realized that a part of what we experience today...is a result of our stupidity and wickedness in the past.”
― Toba Beta, Master of Stupidity

Hope you like it. Stay tuned for more..

Continue Reading

Why continuous integration is your friend?

In this post we are going learn benefits of Continuous Integration in Software Developments. Let’s understand what is continuous integration first and then we will discuss about benefits we are having.

What is Continuous Integration in software development?

As per wikipedia “Continuous integration (CI) is the practice, in software engineering, of merging all developer working copies with a shared mainline several times a day. It was first named and proposed as part of extreme programming (XP). Its main aim is to prevent integration problems, referred to as "integration hell" in early descriptions of XP”.

In simple words, Continuous Integration means whenever any developer from the project team commit/checkin code at that time build will be created with the help of build servers and it will be automatically deployed to a specific location with the help of build server.

There are lots of open source and paid options are available for Continuous Integration like Team Foundation Server, Jenkins, TeamCity etc.

You can found a complete comparision of this tools from the following link.
http://en.wikipedia.org/wiki/Comparison_of_Continuous_Integration_Software

Benefits of Continuous Integration:

Followings are benefits of Continuous Integration and Followings are reason why continuous integration is your friend.

1) Automate everything If you don’t have CI then one of the developers needs to get latest/update code in his/her computer then create a build that will waste lot of time on the developer and ultimately we are going to loose developers productive time for this instead of writing code.

2) It will improve quality of code, Whenever any developers commits the code it will create a build and if build is not successful then it will inform all the users/developers of the using that project/build. So now developers will check quality of code regular because otherwise it will create bad impression of this developer on other stack holders of project.

3) Deployment will very easy. Earlier every time we have to deploy to a particular location manually but here stack holders of project don’t need to worry about the deploying things as it will deploy all the things properly.

4) Your code repository will be up to date every time and you don’t have to worry about it.

5) Save lots of times of developers and increase developers productivity. Take an example suppose there are five developers are working on a software project. One of the developer has committed code and another developer has taken latest version from source control at that he/she is facing problem while compile/building project he will notify the developer who has broke the things. So that developer will check and found that he forgot to commit one of the file. So again he will commit things and notify again to all. This will ultimately a productivity lose.

6) QA/Testing team does not have to wait for deployment. So if developer is committed code it will automatically create build and deploy it on specific location there will not be any dependency of development team to test new features.

That’s it. Looking at above reason I must say Continuous Integration is your best friend and ultimately a productivity booster. Stay tuned for more..

CodeProject

Continue Reading

Various way of finding duplicate rows in SQL Server

Recently One of the friend ask how we can find duplicate rows in SQL server so I said there are various way of finding duplicates and then I show him few ways of findings duplicate based on criteria. I thought it is a very basic question and still lots of people does not know how to find duplicate rows in SQL Server. So it is good idea to write blog post about it. In this blog post I’m going to explain the same various way of finding duplicates.

First all, We need a table to find duplicate rows. So following is a table for that.I have created Employee table with four fields.

CREATE TABLE [dbo].[Employee](
    [Id] [int] NOT NULL,
    [FirstName] [nvarchar](50) NULL,
    [LastName] [nvarchar](50) NULL,
    [Designation] [nvarchar](50) NULL
) ON [PRIMARY]

Now once you create this “Employee” table now it’s time to write insert data. I have inserted following data.

Finding duplicate rows in SQL Server:

Now let’s first write query to find duplicate rows in “Employee” table. Following is a query for that.

SELECT
     Id,
     FirstName,
     LastName,
     Designation,
     Count(*) as 'Number of Rows'
FROM Employee 
GROUP BY Id,FirstName,LastName,Designation HAVING COUNT(*) > 1

Once you run this query following result will be there.



If you can see the data of “Employee” table clearly then you will see that there are two people with first name“Tushar” and “Jalpesh”. Let’s find that via following queries.

SELECT
     FirstName,
     Count(*) as 'Number of Rows'
FROM Employee 
GROUP BY FirstName HAVING COUNT(FirstName) > 1

Now when you run this query it will load following result.




That’s it. You can see its very easy to find duplicate rows in SQL Server. Hope you like it. Stay tuned for more.

CodeProject

Continue Reading

Node.js tools for visual studio

In this post we are going to look how we can use node.js application in visual studio with node.js tools for visual studio.

What is Node.js?

As per wikipedia Node.js is a software plateform that is used to built scalable network(specially server side application). Node.js utilizes JavaScript as its scripting language and achieved high throughput via non blocking I/0 and single-threaded event loop.Node.js was created by Ryan Dhal in starting 2009.Its development and maintenance is sponsored by Joyent.

Why we should care about Node.js:

1. It uses JavaScript most popular language of the web.
2. Fast. Powered by incredible V8 virtual machine. It makes JavaScript execution really fast.
3. A Great feet for real-time web application.
4. It’s scales very easily.

Node.js tools for visual studio:

You can download the Node.Js tools from the following link.

https://nodejstools.codeplex.com/

Here are some quick features of Node.Js tools.

1. NTVS support editing, intellisense, profiling, NPM, debugging locally and remotely(Windows, MAC, Linux) as well as Azure web sites and Cloud services.
2. Designed, Developed and Supported by Microsoft Community.

It is available for both Visual Studio 2012 and Visual Studio 2013 both.

Installation of Node.js tools for visual Studio:

It’s very easy to install download the setup and double click setup.exe it will load following screen.



Once you click on install it will load start installing.



After completing installation it will look like following.



Once you are done with installation open visual studio and go to File-> New Project-> JavaScript and you will see node.js template available.



That’s it. Hope you like it. In next post We are going to create first node.js application with Visual Studio. Stay tuned for more..

CodeProject

Continue Reading

Year 2014 resolutions

First of all, Happy new year to all of you!!.  May your all your wishes come true this year.This time I am making resolutions public so I am accountable to my readers. Here are resolutions for year 2014.

1. Should be more active in communities. Since last 3 months I was busy with professional commitments and lot of things happening with life. Now all things are going to be settle down in January month of this year so now I will be more active on communities.
2. Loose weight. I have already started loosing weight via controlling my diet and this year I am planning to loose at least 15 kgs.
3. Write three blog post at least a week.
4. Learn my self new technologies like Node.js and Python.

This four resolution I want to try to achieve lets see how it goes. I will update how I am doing with my resolution each quarter.

Once again happy new year 2014 to all of you!!. Stay tuned for more..

Continue Reading

Book Review: Microsoft Office 2013 Professional 2013 Step by Step

Before some time Microsoft Press and Oreilly sent me Microsoft Office Professional 2013 Step by step by to review. I was so busy at my professional commandment that I was not able to review. Now I get a time to review and here is review of book.

About this book:

Anybody who knows computer Knows about Microsoft Office Suite there are tons of features available in this office suite like Microsoft Word, Microsoft Excel, Microsoft Power point etc.  We all know this software's a little bit but we were not aware tons of feature each software has and this book aim to reveal all this features this can make your life very easy.

This book is designed for beginning to intermediate users. This books contains all the examples that could benefit individual as well as Business organizations.

This book is divided in 8 Parts from getting started to advance features.

Part-1 Office Professional 2013 Fundamentals:

In this part its get started with making user comfortable with Microsoft Office 2013 Environment and then it also highlights some of shared office features. It also highlights how you can use cloud services with your office application and even how you can use office with windows 8 touch device.

Part-2 Word 2013:

This part contains 6 chapters related to word where it get started with getting comfortable in word 2013 and then it also tells about navigation and reading features of word to editing and composing documents. There are some special chapters for presenting information and finalizing documents also.

Part-3 PowerPoint 2013:

This part contains 6 chapters related Powerpoint from getting comfortable in PowerPoint 2013 to finalizing and presenting. If you are a computer geek and you need to present in front of audience this part is for you. You can become expert in Power point via reading this chapters. It also emphasis creating office graphics and adding animation and multimedia.

Part-4 Excel 2013:

If you are an business owner and uses Excel in your day to day activities then this part is for you. This part contains 7 chapters dedicated to excel. Here you learn everything from creating and editing worksheets to analysing data to creating chart and graphics based on your worksheet. 

Part-5 Outlook 2013:

Emails become one of the best communication channel between people this days and If you don’t know Microsoft Outlook email client then you will look like illiterate. This part is for Outlook 2013. Its start with making yourself comfortable with Outlook 2013  to sending emails. It also contains chapters related to Staying on schedule, Working with tasks, Managing contacts and people and last and important tips and tricks about Microsoft Outlook to save your time. Another excellent part!!

Part-6 One Note 2013:

This part contains 6 chapters related to One Note. If you are attending lots of meeting and you need to take notes then this part is for you. There are tons of features explained about One Note to using One note every where.

Part-7 Access 2013:

This part contains 7 chapters related to Access 2013. From creating table to designing forms and reports to querying tables. If you are running a small organization with Microsoft Access you can maintain your data very easily and this part will make you expert of Microsoft Access.

Part-8 Publisher 2013:

This part contains 3 chapters related to Publisher 2013 from making yourself comfortable to creating,saving and exporting publications.

Conclusion:

Microsoft Office Professional 2013 step by step is a great book for the beginners and for intermediate users it can work as reference book. It explains all the components of Office Professional 2013 in very detail, straight forward and easy to understandable way.  This book is very well written by experience authors like Beth Melton, Mark Dodge, Echo Swinford, Andrew Couch, Eric Legault, Ben M. Schorr and Ciprian Adrian Rusen.

If you want to learn in Office 2013 Professional and become expert then this book is must buy for you!! I highly recommend this book for no voice to intermediate users of Office.

On this occasion, I would also like to thank Microsoft Press and Oreilly team for choosing me to review this book. I learn a lot of things in office with the help of this book.

CodeProject

Continue Reading

Creating DJango application with Python in Visual Studio

In previous post I have written about creating a basic python application with visual studio. In this post we are going to learn how we can create a DJango application with Python in Visual Studio with the help of python tools for Visual Studio.

What is DJango?

As per wikipedia, DJango is a free open source web application framework written in python which follow ups model view controller architectural pattern.It is maintained by  DJango Software Foundation an independent non profit organization. Django’s primary goal is to ease the creation of complex, database driven websites. DJango emphasizes reusability and plugability   of component and principle of Don’t repeat your self.

Creating DJango application with Visual Studio :

Let’s create first DJango application with Visual Studio and Python tools for Visual Studio. So to create DJango application with we have to create a new project via File->New Project –> DJango project just like following.



Once you click ok it will create a DJango project like following.



Now it’s time to create our first application. So right click FirstDjango folder and add new DJango App.



Now once you click on DJango app it will open a box like below.



Now its time to install Python Environment to application via right click on python environment in solution explorer and select environment.



Now once you click OK it will add python environment to application.



Now right click python 2.7 and right click it will open up a popup like below.



Once you click on Install Python Package it will open up a dialog like following.


Once you click OK It will install DJango package in Visual Studio after installing lot of files it may take 5 to 10 minutes.



It’s done!! run your first application with DJango with f5 and following you see in browser.



Woohoo!! your first python web application ready. Hope you like it. Stay tuned for more..

CodeProject

Continue Reading