jump to navigation

Must know about query optimizer 30 Apr 2012

Posted by Ramaswamy Palaniappan in Advanced Basics, Back to Basics, SQL.
add a comment

Paul White’s serious of posts about Query Optimizer. It is excellent one, must read.

Query Optimizer Deep Dive – Part 1
Query Optimizer Deep Dive – Part 2
Query Optimizer Deep Dive – Part 3

Ramaswamy Palaniappan

What is GUID? 27 Apr 2012

Posted by Ramaswamy Palaniappan in Back to Basics.
add a comment

Eric Lippert written a good article about it, Read here

Ramaswamy Palaniappan

Free US ZIP Code Database 26 Apr 2012

Posted by Ramaswamy Palaniappan in Uncategorized.
add a comment

Option:1
Free US ZIP Code Database as CSV
1. Go to http://mappinghacks.com/
2. Click the geodata hyperlink from the header menu.
3. Now you will see all the data files. Click zipcode.zip to download the file.

Option:2
A Free Zip Code Database + Latitude and Longitude, download from here.

Option:3
Data from populardata, get it from here.

Ramaswamy Palaniappan

Change the orientation of few pages in MS Word 26 Apr 2012

Posted by Ramaswamy Palaniappan in Tips.
add a comment

Step 1: Go Page Layout Tab, in Page Setup Group, look for Breaks menu.

Step 2: Click Next Page from the section Breaks.

clip_image002

Step 3: Select Landscape from the orientation option.

clip_image003

Step 4: Click Next Page from the section Breaks.

Step 5: Select Portrait from the orientation option.

Look the page layout now, we have inserted Landscape page layout between Portrait layout

clip_image005

Ramaswamy Palaniappan

How scheduling works in Project 25 Apr 2012

Posted by Ramaswamy Palaniappan in Project Management.
add a comment

Microsoft Office Project uses a powerful scheduling engine to help align your organization’s projects and tasks with available resources. Understanding how Project schedules work is a key factor in making intelligent planning decisions.

 Read here

Ramaswamy Palaniappan

Twelve tips for realistic scheduling 25 Apr 2012

Posted by Ramaswamy Palaniappan in Project Management.
add a comment

Good scheduling is very difficult, a combination of art and science. In this article, I will discuss realistic scheduling, which seeks to cover all the above types of events — the planned, the possible, and the unimagined. There are some techniques that can help you keep your sanity, which go beyond the notes, checklists, milestones dates, and appointment books. My twelve tips stress prioritization, clarifying values, and comparing the relative worth of each activity. They combine the conventional checklists with preserving and enhancing relationships to accomplish the desired results. Read here

Thank you Laura Rose, QE Manager, IBM, Software Group.

ramaswamypalaniappan.com

What’s New in SQL Server 2012 20 Apr 2012

Posted by Ramaswamy Palaniappan in SQL.
2 comments

Click here to read about new features in the SQL Server 2012.