Top 5 Free Online Resume Maker, Builder, Creator, Wizard

After you read this article, you will find out:
  • Free Online Resume Builder Comparison Table.
  • Top 5 Free Online Resume Makers.
  • The Most Favorite Free Online Resume Maker for Other People.
  • Related Useful Resume Resources.

Is There any Good Free Online Resume Maker?

Are you looking for a good free online resume maker which can help you to write a winning resume? This page is right for you, if the answer is yes. There are many online resume creator tools available for you to use for free of charge. In the following table, you will find the top 5. First, I would like you to see what all inside the service. Let see a quick overview:

Many people asked me about free online resume creator such as: Is it allows me to post resume online? Are there many templates available in the tool? What type of file format can I export? And so on. From one to another service is not equal. There are differences in both features and interface. Let me provide you some highlights. Free online resume makers like VisualCV and Emurse allow you not only creating resume but also posting your resume online as web page where you can decide who gets to see it.

Regarding to template, there are not so many of them available comparing to desktop resume writing software. But you will find commonly used and standard template. Most of the tool allows you to download your resume in PDF and Text file format, some available in more formats like Doc and Html. Some tools such as JobSpice and Resumizer allow you to create a resume even without registration or having an account at its website.

With resume wizard in the tools, you just answer the questions and fill out your information into the right box. Then follow few more steps, the final resume is created. That is sound simple and easy. Yes it is. But it is not mean that your resume is a winning one. To make a winning resume I recommend you to read this How to Write a Winning Resume in 9 Steps?. Now I hope you get some ideas.

Free Online Resume Builder Comparison Table

The following is a fundamental comparison table of free online resume creators.

Online Resume Makers Description Price Registration
VisualCV A unique free online resume maker tool Free
JobSpice An easy to use free online resume maker Free
Emurse – Resume Builder Create, share & store resume online for free Free
HowToWriteAResume.NET There are both free & premium membership Free
Resumizer FREE Resume Creator A straightforward online resume wizard Free

Top 5 Free Online Resume Makers


The following is a list of top free online resume makers which have been carefully selected.

1. VisualCV

VisualCV is a unique free online resume maker tool. With this tool you can create a resume and make it comes alive in three steps: create, enrich and share. Create: you can create a VisualCV by cutting and pasting from your existing resume in Word, PDF or plain text format. Right away, your resume becomes a live Internet document. Enrich: You can easily enrich your VisualCV, making it a proxy for that first interview. Add one or more video clips that answer standard questions, or perhaps address that awkward gap in your resume. Attach writing samples or your scanned diploma and more. Share: You decide who gets to see your VisualCV. Share it with your professional social network, or in their database of employers who each have their own company. Unlike an emailed resume, you have complete control over who can access your VisualCV.

You can use your VisualCV for professional networking, job searching, business development, and personal brand management. The VisualCV Portfolio lets you easily add and manage your work samples, images, videos, media coverage, diplomas, certificates, or other interesting details about you to enhance your VisualCV.

2. JobSpice

JobSpice is an easy to use free online resume maker. You can create your resume for free in just several minutes with or without registration. As a registered user, you can save and share your resume online. Without registration, you can only create and export your resume into PDF, but you cannot save and share it online.

The process is simple. First, add desired section to your resume page (including Contact Info, Objective, Education, Coursework, Experience, Achievements, Affiliations, Skills, Publications and Custom Section). Then fill out the information into the box. Next, you can choose style for your resume including Cardinal, Brown, Impossible Is Nothing, Green and Simpme, Taleen, Titan, Derivative and more. Then take a preview of your resume. Last step is to save, print, share or export as pdf.

3. Emurse – Resume Builder

You can create share and store your resume online for free with Emurse.com. It allow you to create multiple resumes quickly and easily, safely and securely store your resume, have your resume available whenever you need. Emurse also helps you keep track of both online and offline resume distribution as well as keep notes and set statuses for each event and allows you to set follow up reminders to keep you on task. Additional, it allows you to turn your resume into a website with privacy controls and advanced stats. To use the service, you need to create an account at it official website.

4. HowToWriteAResume.NET

HowToWriteAResume.NET provides an online resume builder solution. You can create a professional resume much faster by using Automatic Templates, PhraseBuilder Technology, Step by Step Instructions, Easy Formatting and Export and Integrated Job Search. There are both free and premium memberships. With free membership, you can create a resume with standard template and can download it as html or txt file format. You do not need to pay anything to print; you can print directly from the format page.

For more features, you have the option of upgrading to premium for a one-time fee. You will have access to more advanced resume templates, more phrase builder templates, the ability to export to doc, docx, PDF, and Open Document formats.

5. Resumizer FREE Resume Creator

Resumizer is free online resume creator which allows you to create a resume with or without having an account at its official website. This resume wizard allows you to format your resume with font type, size and color. The creation process is straightforward. You just need to follow the step by step resume wizard. There are several resume styles available for you to choose. After complete writing, you can download your resume into several formats including PDF, HTML and Text. Without membership, none of your info is stored in the system. With free membership, the benefit is easier editing as your information will be stored in the system allowing you to login to edit your resume.

Read full details
Category: 3 comments

Data Comparison Tool in Visual Studio 2010

Introduction

In my earlier article we have discussed about the SQL Server schema comparison tool in Visual Studio 2010 http://www.dotnetfunda.com/articles/article1121-sql-server-schema-comparison-tool-in-visual-studio-2010-.aspx. Today in this article I’m going to explain yet another new tool in Visual Studio 2010 which is nothing but the DATA COMPARISON tool. This tool is of extreme use for the developers to compare data in 2 tables in different environment (in real time say a reference table data should be compared from Development to Production).

Many third party software’s available in market which servers the same purpose for comparing the data between the environments, but with Visual Studio Microsoft has given this functionality inbuilt as a comparison tool so that Visual Studio emerges as a bundled product which servers most of the development tasks and day to day activities which the developers and DBA’s required to do. Microsoft Database server version for Database administrators and developers has provided with many features like database development, version controlling, unit testing, code analysis, code maintenance etc…


Availability

Microsoft has provided option in Visual Studio 2010 to compare the data for SQL Server 2005 and 2008 versions, since SQL Server 2000 support is not provided by Microsoft this version is not included with VS 2010. So both SQL Schema Comparison and Data Comparison are supported for SQL Server 2005 and 2008 versions. These tools are available for the licenses with Visual Studio Premium and Visual Studio Ultimate versions and not available for the Visual Studio Professional version.

Let’s jump into the demonstration on how to use the Visual Studio 2010 Data Compare tool; I’m taking Sql server database data comparison. Let’s see the step by step process on how to use this tool.

Step by Step Process


Step 1 – Open Visual Studio 2010 by moving to Start > Program > Microsoft Visual Studio 2010 > Microsoft Visual Studio 2010.

STEP 1

Step 2 – Once Visual Studio is opened, go to Data --> Data Compare --> New Data Comparison…

STEP 2

Step 3 – You will see a dialog box which requests for the source and destination db and the properties to connect to those db servers as below

STEP 3

Step 4 – Choose the source and the destination DB servers which you want to compare with. If you can see the above image, there are the options available for the comparison like Different Records, Only in Source, Only in Target, Identical Records. Based on the needs these options can be selected to make the comparison of the data. Once the options are selected click on the FINISH button, it will open a new screen.

Step 5 – The new window will show the list of tables and views in the Source/destination servers and the list of columns for each table. You have given the option to select the columns which needs to be compared. The main point to note down here is the tables to be compared needs to have a Primary or Unique Key by which the tool will make the comparison. So Select the list of tables and the constraints as per the requirement as shown in the below figure and click on FINISH button.

STEP 5

Step 6 – Once we click the FINISH button, the tool will start doing the comparison based on the selection we made and gets the result in a new windows as shown in the below image. The window has few sections which gives the user to make analysis of the data which are compared. The options which we gave at the step 3 are shown as output here. The window will have the Count of data difference in both the source and the destination, Count of data difference in source only, Count of data difference in destination only and finally the identical records in both the servers.

STEP 6

Step 7 – In the same window we have some useful information, and guess what are the information’s?? Yes the tool gives which are the difference in the data stored as per the selection we made in the step 3 as shown in the below image.

STEP 7

Step 8 – Finally in the same window we have some more set of information’s like the tool itself generates the insert and the update scripts to sync between the databases as shown in the below image.

STEP 8


Conclusion

This tool is really going to be more productive for the day to day activity of the developers and improves the productivity. Thanks to Microsoft for incorporating these tools into Visual Studio 2010.

Read full details
Category: 0 comments

SQL SERVER – Index Created on View not Used Often – Limitation of the View 12

SQL SERVER – Index Created on View not Used Often – Limitation of the View 12: "

I have previously written on the subject SQL SERVER – The Limitations of the Views – Eleven and more…. This was indeed a very popular series and I had received lots of feedback on that topic. Today we are going to discuss something very interesting as well.


During my recent performance tuning seminar in Hyderabad, I presented on the subject of Views. During the seminar, one of the attendees asked a question:


We create a table and create a View on the top of it. On the same view, if we create Index, when querying View, will that index be used?


The answer is NOT Always!


(There is only one specific condition when it will be used. We will write about that later in the next post).


Let us see the test case for the same. In our script we will do following:


USE tempdb

GO

IF EXISTS (SELECT * FROM sys.views WHERE OBJECT_ID = OBJECT_ID(N'[dbo].[SampleView]'))

DROP VIEW [dbo].[SampleView]

GO

IF EXISTS (SELECT * FROM sys.objects WHERE OBJECT_ID = OBJECT_ID(N'[dbo].[mySampleTable]') AND TYPE IN (N'U'))

DROP TABLE [dbo].[mySampleTable]

GO

-- Create SampleTable

CREATE TABLE mySampleTable (ID1 INT, ID2 INT, SomeData VARCHAR(100))

INSERT INTO mySampleTable (ID1,ID2,SomeData)

SELECT TOP 100000 ROW_NUMBER() OVER (ORDER BY o1.name),

ROW_NUMBER() OVER (ORDER BY o2.name),

o2.name

FROM sys.all_objects o1

CROSS JOIN sys.all_objects o2

GO

-- Create View

CREATE VIEW SampleView

WITH SCHEMABINDING

AS

SELECT
ID1,ID2,SomeData

FROM dbo.mySampleTable

GO

-- Create Index on View

CREATE UNIQUE CLUSTERED INDEX [IX_ViewSample] ON [dbo].[SampleView]

(

ID2 ASC

)

GO

-- Select from view

SELECT ID1,ID2,SomeData

FROM SampleView

GO



Let us check the execution plan for the last SELECT statement.



You can see from the execution plan. That even though we are querying View and the View has index, it is not really using that index.


In the next post, we will see the significance of this View and where it can be helpful.


Meanwhile, I encourage you to read my View series: SQL SERVER – The Limitations of the Views – Eleven and more….

Read full details
Category: 0 comments

SQL SERVER – ORDER BY ColumnName vs ORDER BY ColumnNumber

SQL SERVER – ORDER BY ColumnName vs ORDER BY ColumnNumber: "

I strongly favor ORDER BY ColumnName.


I read one of the blog post where blogger compared the performance of the two SELECT statement and come to conclusion that ColumnNumber has no harm to use it. Let us understand the point made by first that there is no performance difference.


Run following two scripts together:


USE AdventureWorks

GO

-- ColumnName (Recommended)

SELECT *

FROM HumanResources.Department

ORDER BY GroupName, Name

GO

-- ColumnNumber (Strongly Not Recommended)

SELECT *

FROM HumanResources.Department

ORDER BY 3,2

GO


If you look at the result and see the execution plan you will see that both of the query will take the same amount of the time.



However, this was not the point of this blog post. It is not good enough to stop here. We need to understand the advantages and disadvantages of both the methods.


Case 1: When Not Using * and Columns are Re-ordered


USE AdventureWorks

GO

-- ColumnName (Recommended)

SELECT GroupName, Name, ModifiedDate, DepartmentID

FROM HumanResources.Department

ORDER BY GroupName, Name

GO

-- ColumnNumber (Strongly Not Recommended)

SELECT GroupName, Name, ModifiedDate, DepartmentID

FROM HumanResources.Department

ORDER BY 3,2

GO



Case 2: When someone changes the schema of the table affecting column order


I will let you recreate the example for the same. If your development server where your schema is different than the production server, if you use ColumnNumber, you will get different results on the production server.


Summary: When you develop the query it may not be issue but as time passes by and new columns are added to the SELECT statement or original table is re-ordered if you have used ColumnNumber it may possible that your query will start giving you unexpected results and incorrect ORDER BY.


One should note that the usage of ORDER BY ColumnName vs ORDER BY ColumnNumber should not be done based on performance but usability and scalability.


It is always recommended to use proper ORDER BY clause with ColumnName to avoid any confusion.

Read full details
Category: 0 comments

Drag and drop attachments onto messages

I'm always looking for ways to save time. Suppose I want to attach some files to an email, and I already have a folder open containing those files.



I used to have to click "Attach a file," find the photos, click them, etc. Starting today, if I'm using Google Chrome or Mozilla Firefox 3.6, I can just drag and drop the files to attach them — easy as pie.





We'll enable this for other browsers as soon as they support this feature. For now, you can drag and drop attachments in Chrome and Firefox only.
Read full details
Category: 0 comments

SQL Server Interview Questions and Answers – Part 6

What are the properties of the Relational tables?
Relational tables have six properties:
  • Values are atomic.
  • Column values are of the same kind.
  • Each row is unique.
  • The sequence of columns is insignificant.
  • The sequence of rows is insignificant.
  • Each column must have a unique name.
What is De-normalization?
De-normalization is the process of attempting to optimize the performance of a database by adding redundant data. It is sometimes necessary because current DBMSs implement the relational model poorly. A true relational DBMS would allow for a fully normalized database at the logical level, while providing physical storage of data that is tuned for high performance. De-normalization is a technique to move from higher to lower normal forms of database modeling in order to speed up database access.
How to get @@error and @@rowcount at the same time?
If @@Rowcount is checked after Error checking statement then it will have 0 as the value of @@Recordcount as it would have been reset.
And if @@Recordcount is checked before the error-checking statement then @@Error would get reset. To get @@error and @@rowcount at the same time do both in same statement and store them in local variable. SELECT @RC = @@ROWCOUNT, @ER = @@ERROR
What is Identity?
Identity (or AutoNumber) is a column that automatically generates numeric values. A start and increment value can be set, but most DBA leave these at 1. A GUID column also generates numbers, the value of this cannot be controled. Identity/GUID columns do not need to be indexed.
What is a Scheduled Jobs or What is a Scheduled Tasks?
Scheduled tasks let user automate processes that run on regular or predictable cycles. User can schedule administrative tasks, such as cube processing, to run during times of slow business activity. User can also determine the order in which tasks run by creating job steps within a SQL Server Agent job. E.g. Back up database, Update Stats of Tables. Job steps give user control over flow of execution.  If one job fails, user can configure SQL Server Agent to continue to run the remaining tasks or to stop execution.
What is a table called, if it does not have neither Cluster nor Non-cluster Index? What is it used for?
Unindexed table or Heap. Microsoft Press Books and Book On Line (BOL) refers it as Heap.
A heap is a table that does not have a clustered index and, therefore, the pages are not linked by pointers. The IAM pages are the only structures that link the pages in a table together.
Unindexed tables are good for fast storing of data. Many times it is better to drop all indexes from table and than do bulk of inserts and to restore those indexes after that.
What is BCP? When does it used?
BulkCopy is a tool used to copy huge amount of data from tables and views. BCP does not copy the structures same as source to destination.
How do you load large data to the SQL server database?
BulkCopy is a tool used to copy huge amount of data from tables. BULK INSERT command helps to Imports a data file into a database table or view in a user-specified format.
Can we rewrite subqueries into simple select statements or with joins?
Subqueries can often be re-written to use a standard outer join, resulting in faster performance. As we may know, an outer join uses the plus sign (+) operator to tell the database to return all non-matching rows with NULL values. Hence we combine the outer join with a NULL test in the WHERE clause to reproduce the result set without using a sub-query.
Can SQL Servers linked to other servers like Oracle?
SQL Server can be lined to any server provided it has OLE-DB provider from Microsoft to allow a link. E.g. Oracle has a OLE-DB provider for oracle that Microsoft provides to add it as linked server to SQL Server group.
How to know which index a table is using?
SELECT table_name,index_name FROM user_constraints
How to copy the tables, schema and views from one SQL server to another?
Microsoft SQL Server 2000 Data Transformation Services (DTS) is a set of graphical tools and programmable objects that lets user extract, transform, and consolidate data from disparate sources into single or multiple destinations.
What is Self Join?
This is a particular case when one table joins to itself, with one or two aliases to avoid confusion. A self join can be of any type, as long as the joined tables are the same. A self join is rather unique in that it involves a relationship with only one table. The common example is when company have a hierarchal reporting structure whereby one member of staff reports to another.
What is Cross Join?
A cross join that does not have a WHERE clause produces the Cartesian product of the tables involved in the join. The size of a Cartesian product result set is the number of rows in the first table multiplied by the number of rows in the second table. The common example is when company wants to combine each product with a pricing table to analyze each product at each price.
Which virtual table does a trigger use?
Inserted and Deleted.
List few advantages of Stored Procedure.
  • Stored procedure can reduced network traffic and latency, boosting application performance.
  • Stored procedure execution plans can be reused, staying cached in SQL Server’s memory, reducing server overhead.
  • Stored procedures help promote code reuse.
  • Stored procedures can encapsulate logic. You can change stored procedure code without affecting clients.
  • Stored procedures provide better security to your data.
What is DataWarehousing?
  • Subject-oriented, meaning that the data in the database is organized so that all the data elements relating to the same real-world event or object are linked together;
  • Time-variant, meaning that the changes to the data in the database are tracked and recorded so that reports can be produced showing changes over time;
  • Non-volatile, meaning that data in the database is never over-written or deleted, once committed, the data is static, read-only, but retained for future reporting;
  • Integrated, meaning that the database contains data from most or all of an organization’s operational applications, and that this data is made consistent.
What is OLTP(OnLine Transaction Processing)?
In OLTP – online transaction processing systems relational database design use the discipline of data modeling and generally follow the Codd rules of data normalization in order to ensure absolute data integrity. Using these rules complex information is broken down into its most simple structures (a table) where all of the individual atomic level elements relate to each other and satisfy the normalization rules.
How do SQL server 2000 and XML linked? Can XML be used to access data?
FOR XML (ROW, AUTO, EXPLICIT)

You can execute SQL queries against existing relational databases to return results as XML rather than standard rowsets. These queries can be executed directly or from within stored procedures. To retrieve XML results, use the FOR XML clause of the SELECT statement and specify an XML mode of RAW, AUTO, or EXPLICIT.
OPENXML
OPENXML is a Transact-SQL keyword that provides a relational/rowset view over an in-memory XML document. OPENXML is a rowset provider similar to a table or a view. OPENXML provides a way to access XML data within the Transact-SQL context by transferring data from an XML document into the relational tables. Thus, OPENXML allows you to manage an XML document and its interaction with the relational environment.
What is an execution plan? When would you use it? How would you view the execution plan?
An execution plan is basically a road map that graphically or textually shows the data retrieval methods chosen by the SQL Server query optimizer for a stored procedure or ad-hoc query and is a very useful tool for a developer to understand the performance characteristics of a query or stored procedure since the plan is the one that SQL Server will place in its cache and use to execute the stored procedure or query. From within Query Analyzer is an option called “Show Execution Plan” (located on the Query drop-down menu). If this option is turned on it will display query execution plan in separate window when query is ran again.
Read full details

SQL Server Interview Questions and Answers – Part 5

What command do we use to rename a db?
sp_renamedb ‘oldname’ , ‘newname’
If someone is using db it will not accept sp_renmaedb. In that case first bring db to single user using sp_dboptions. Use sp_renamedb to rename database. Use sp_dboptions to bring database to multi user mode.
What is sp_configure commands and set commands?
Use sp_configure to display or change server-level settings. To change database-level settings, use ALTER DATABASE. To change settings that affect only the current user session, use the SET statement.
What are the different types of replication? Explain.
The SQL Server 2000-supported replication types are as follows:
  • Transactional
  • Snapshot
  • Merge
Snapshot replication distributes data exactly as it appears at a specific moment in time and does not monitor for updates to the data. Snapshot replication is best used as a method for replicating data that changes infrequently or where the most up-to-date values (low latency) are not a requirement. When synchronization occurs, the entire snapshot is generated and sent to Subscribers.
Transactional replication, an initial snapshot of data is applied at Subscribers, and then when data modifications are made at the Publisher, the individual transactions are captured and propagated to Subscribers.
Merge replication is the process of distributing data from Publisher to Subscribers, allowing the Publisher and Subscribers to make updates while connected or disconnected, and then merging the updates between sites when they are connected.
What are the OS services that the SQL Server installation adds?
MS SQL SERVER SERVICE, SQL AGENT SERVICE, DTC (Distribution transac co-ordinator)
What are three SQL keywords used to change or set someone’s permissions?
GRANT, DENY, and REVOKE.
What does it mean to have quoted_identifier on? What are the implications of having it off?
When SET QUOTED_IDENTIFIER is ON, identifiers can be delimited by double quotation marks, and literals must be delimited by single quotation marks. When SET QUOTED_IDENTIFIER is OFF, identifiers cannot be quoted and must follow all Transact-SQL rules for identifiers.
What is the STUFF function and how does it differ from the REPLACE function?
STUFF
function to overwrite existing characters. Using this syntax, STUFF(string_expression, start, length, replacement_characters), string_expression is the string that will have characters substituted, start is the starting position, length is the number of characters in the string that are substituted, and replacement_characters are the new characters interjected into the string.
REPLACE
function to replace existing characters of all occurance. Using this syntax REPLACE(string_expression, search_string, replacement_string), where every incidence of search_string found in the string_expression will be replaced with replacement_string.
Using query analyzer, name 3 ways to get an accurate count of the number of records in a table?
SELECT *
FROM table1
SELECT COUNT(*)
FROM table1
SELECT rows
FROM sysindexes
WHERE id = OBJECT_ID(table1)
AND
indid < 2

How to rebuild Master Database?

Shutdown Microsoft SQL Server 2000, and then run Rebuildm.exe. This is located in the Program Files\Microsoft SQL Server\80\Tools\Binn directory.
In the Rebuild Master dialog box, click Browse.
In the Browse for Folder dialog box, select the \Data folder on the SQL Server 2000 compact disc or in the shared network directory from which SQL Server 2000 was installed, and then click OK.
Click Settings. In the Collation Settings dialog box, verify or change settings used for the master database and all other databases.
Initially, the default collation settings are shown, but these may not match the collation selected during setup. You can select the same settings used during setup or select new collation settings. When done, click OK.
In the Rebuild Master dialog box, click Rebuild to start the process.
The Rebuild Master utility reinstalls the master database.
To continue, you may need to stop a server that is running.
Source: http://msdn2.microsoft.com/en-us/library/aa197950(SQL.80).aspx
What is the basic functions for master, msdb, model, tempdb databases?
The Master database holds information for all databases located on the SQL Server instance and is the glue that holds the engine together. Because SQL Server cannot start without a functioning master database, you must administer this database with care.
The msdb database stores information regarding database backups, SQL Agent information, DTS packages, SQL Server jobs, and some replication information such as for log shipping.
The tempdb holds temporary objects such as global and local temporary tables and stored procedures.
The model is essentially a template database used in the creation of any new user database created in the instance.
What are primary keys and foreign keys?
Primary keys
are the unique identifiers for each row. They must contain unique values and cannot be null. Due to their importance in relational databases, Primary keys are the most fundamental of all keys and constraints. A table can have only one Primary key.
Foreign keys
are both a method of ensuring data integrity and a manifestation of the relationship between tables.
What is data integrity? Explain constraints?
D
ata integrity is an important feature in SQL Server. When used properly, it ensures that data is accurate, correct, and valid. It also acts as a trap for otherwise undetectable bugs within applications.
A PRIMARY KEY constraint is a unique identifier for a row within a database table. Every table should have a primary key constraint to uniquely identify each row and only one primary key constraint can be created for each table. The primary key constraints are used to enforce entity integrity.
A UNIQUE constraint enforces the uniqueness of the values in a set of columns, so no duplicate values are entered. The unique key constraints are used to enforce entity integrity as the primary key constraints.
A FOREIGN KEY constraint prevents any actions that would destroy links between tables with the corresponding data values. A foreign key in one table points to a primary key in another table. Foreign keys prevent actions that would leave rows with foreign key values when there are no primary keys with that value. The foreign key constraints are used to enforce referential integrity.
A CHECK constraint is used to limit the values that can be placed in a column. The check constraints are used to enforce domain integrity.
A NOT NULL constraint enforces that the column will not accept null values. The not null constraints are used to enforce domain integrity, as the check constraints.
Read full details