codezhemir

Codezhemir is the disease of software developer as forgetting core coding practices like  SOLID principles, design patterns, DRY and starting to use self repeated codes which is unreadable and prone to be reworked. Codezhemir is due to thinking less and coding much. Whereas sofware development is an art of thinking. It consists of logical thinking and artistic aestethic. Like poetry and architectural design. Shorter, deeper and more meaningful is valuable.

The era of sofware engineering is value driven. So any developer should care it and in order to protect (him/her)self from codezhemir, (s)he practices daily best coding practices and seek shorter, deeper and more meaningful.

Have a valuable codes...

How to set default zoom in excel 2013

Hi all,

I googled it but I haven't found a satisfactory answer. After that, I realised that you can save your template as .xltx format to the your Custom Office Template folder, C:\Users\yourUser\Documents\Custom Office Templates .
It is so simple,

1. Open a new excel document 
2. Create your template (I changed zoom to %85)
3. Then Save As your document with the name you give. (I gave it as Minus Fifteen Zoom :))
4. When opening a new excel document you see yout template that you save in Personal section. 
5. Open it and enjoy your template. 

Have a nice excels...

OPENDATASOURCE usage

If you like to reach a server which is not defined for Linked Servers where you are working, and if you know  a user which has access for that server then you can OPENDATASOURCE as follows;

select * from  OPENDATASOURCE('SQLOLEDB','Data Source=ServerYouWantToReach;User ID=userNameForThatServer;Password=passwordForThatServer').databaseName.SchemaName.TableName

You can use this for inner join etc.

Have a good use.

For: More info: http://msdn.microsoft.com/en-us/library/ms179856.aspx