Tuesday, September 23, 2014

MS SQL Server History and Advantages

Microsoft SQL server or more commonly known as MS SQL server is a relational database server developed by Microsoft Corporation. A database server is basically a database application which is used to store data and other software applications retrieve and store data using some language which is called SQL (Structured Query Language) in case of MS SQL server. The client application which accesses data from the database server can be on the same machine or on different machine and can access the data via a set of protocols and internet. Microsoft has developed wide variety if MS SQL server editions keeping in view the type of audience that use database server products. MS SQL Server editions are available for large enterprises, medium scale organizations to individuals.
In the year 1987, Microsoft joined hands with Sybase Solutions in order to develop a database management system which could compete with the then existing giants like IBM and Oracle. It was decided that Sybase will have all the selling rights and profit earned from the product version designed for the Non-Microsoft platform while Microsoft will have exclusive rights of the database product designed for Microsoft Platforms. Hence the first database server product was released around 1989. Later on Sybase sold all the rights to Microsoft and now the product name was changed to MS SQL Server. Till now, around 15 versions of this product have been released.
Release Name
SQL Server 1.0
(16 bit)
SQL Server 1.1
(16 bit)
SQL Server 4.21
SQL Server 6.0
SQL Server 6.5
SQL Server 7.0
SQL Server 7.0
OLAP Tools
Palato mania
SQL Server 2000
SQL Server 2000
64-bit Edition
SQL Server 2005
SQL Server 2008
SQL Azure DB
SQL Server 2008 R2
Kilimanjaro (aka KJ)
SQL Server 2012
SQL Server 2014

Source: www.wikipedia.com
Like other Microsoft products, MS SQL Server comes with bundle of benefits for the average users.
  • Easy Installation
All the Microsoft products are easy to install with one click installation procedure and readable GUI with lots of instructions for the layman. MS SQL Server contains all these characteristics and it has extremely user friendly installation interface unlike other database servers which requires extensive command line configurations.
  • Improved Performance
MS SQL server contains excellent compression and encryption capabilities that result in improved data storage and retrieval functions.
  • Security
MS SQL server is considered one of the most secure database servers with complex encryption algorithms making it virtually impossible to crack the security layers enforced by the user. MS SQL server is not an open source database server which reduces the risk of attacks on the database server.
  • Multiple Editions and Price Variations.
A good thing about MS SQL server is that it is available in multiple editions in order to cater the needs of huge corporate sector organizations to a domestic user. The price range also varies which allows anyone to buy the product which meets their price range.
  • Excellent Data Restoration and Recovery Mechanism

MS SQL server is fully aware of the importance of your data. Hence MS SQL Server contains many sophisticated features that allow you to recover and restore the data which has been lost or damaged. Although you cannot recover individual records but it is possible to restore complete database using some advanced recovery tools contained in MS SQL Server database.

Thursday, September 18, 2014

Pay per Hour vs Pay per Project Job

In freelancing, there are two types of jobs. Pay per hour jobs or often called hourly jobs and pay per project jobs, often known as fixed price jobs. Both of these job types have their own pros and cons. In this article we have explained both advantages and disadvantages of hourly and fixed price jobs.
Pay Per Hour Job
Pay per hour job, as the name suggests, is the type of job where freelancer is paid per number of hours worked. Freelancer completes the task and sends the timesheet to the client. Client pays Total Number of Hours Worked x Hourly Rate. This approach has following advantages and disadvantages.
  • Hourly job means you get paid for what you do. You don’t have to make an estimate about the time required to complete the task. You will only have to tell the client your hourly rate and rest is client’s headache.
  • Both client and freelancer can change the requirements at any time during the job.
  • Good for long term jobs where requirements are not well defined. Less risky because you are being paid on weekly basis.
  • Pay per hour jobs can lead to privacy issues because often times client require you to install screen monitoring software so that he can monitor your work which leads to privacy concerns and also some people don’t like to be monitored while they are working.
  • You cannot increase your hourly  price for big clients because usually clients know each other and they can verify your rates from each other.
Pay Per Project
Pay per project jobs are jobs where client and freelancer agree at a fixed price for the whole project.
  • No privacy issues as there is no screen monitoring involved.
  • You can easily increase or decrease the price depending upon the project.
  • Not suitable for jobs with not well defined scope. For example if you are building a complex website, it is very difficult to make an estimate about the time and amount required to complete the project.
  • Unable to embrace changes during the project development. Requirements once decided are frozen in case of fixed price jobs.

Whether to choose fixed price payment option or hourly payment option depends upon the type of project. If the project is not well defined and requirements are ambiguous, hourly payment is best option but if project has well defined scope and milestones, pay per project is better.

Tuesday, September 16, 2014

New: Screen Capturing SDK 2.10.832 and Spreadsheet SDK 2.40.1358 released

ByteScout  updated Screen Capturing SDK 2.10.832 and Spreadsheet SDK 2.40.1358 on September 9, 2014.

What's new Screen Capturing SDK 2.10.832:

  • text overlay now supports date and time macros while used with web cam overlay;
  • audio recording is enabled by default;
  • better handling of missing audio hardware errors;
  • minor internal memory management improvements;
  • custom WMV profile sample added;
  • Java source code sample added;
  • .net source code samples updated;
  • low FPS recording with WMV and Windows Media Video 9 Screen codec source code samples added;
  • minor improvements.

What's new Spreadsheet SDK 2.40.1358:

  • improved handling of incorrect formula values calculating; 
  • CSV to XLS samples updated;
  • improved XLS format handling;
  • license updated;
  • minor fixes.
More info about ByteScout Spreadsheet SDK

Thursday, September 11, 2014

7 Best Sources for Programming Books (Part 2)

4. Sams Teach Yourself Series

Sams teach yourself series is another learning resource for programmers. Good thing about Sams series is that they have intelligently divided the book into hours or days. Courses are compact and extra information is avoided with key focus on teaching the core concepts. Sams teach yourself series usually comes in titles like Sams Teach Yourself Programming in 24 hours or 21 days etc. Sams series books are highly recommended.

5. Ebookee.org

Ebookee is free website book store that contains links to several websites. This is an excellent source to learn programming for those who cannot afford to pay huge sums on purchasing books. A typical ASP.Net book can be found on the link at Ebookee. You can thoroughly search and find the book of your choice at this link.

6. Onlineprogrammingbooks.com

This is a website like Ebookee and contains free programming books in various languages. Here is the link for this website.

7. Freecomputerbooks.com

The last source that contains free programming books is Freecomputebooks.com. It has variety of hardware and software related books. It also contains programming books on all the latest technologies like .NET, C++, JAVA etc.

Tuesday, September 09, 2014

7 Best Sources for Programming Books

Programming is considered one of the most profitable professions. In almost every government or private sector organization, a programmer is required to program applications and websites of the organization. It is said that programmers are born programmers. It requires a special brain to become a programmer and not everyone can be a good programmer. However, there are several online and offline resources available where anyone can learn programming and become a good programmer. In this article we have reviewed some sources where you can get best programming books. Some of these sources are free and others are not.
  1. Amazon

C:\Users\hp\Desktop\1327317491_306592141_1-FREE-BOOKS-DOWNLOAD-chakwal.jpgAmazon is an online bookstore. You can buy virtually any book from amazon. At Amazon books are grouped into several categories. Apart from that advanced search capabilities allow you to easily search the books of your choice. Amazon contains all the famous programming books available in the market. A good thing about amazon is that it allows user comments and feedbacks on the books which help new buyers to have a look at the feedback of the book before buying. There are several payment options and best thing is, Amazon is highly secure. Following is the link for some of the best programming books at Amazon.
  1. O’Reilly Books

O’Reilly books are one of the most reliable sources of learning and referencing for programmers. O’Reilly media contains wide variety of technology books ranging from, desktop programming to web technologies and mobile application technologies, O’Reilly always keep abreast of the latest advancements in programming and computer technologies in general. Here is the link where you can find out the books of your choice.
  1. Dummies

Dummies series of books which comes with the title containing the name of the technology followed by “For Dummies” is an excellent source for absolute programmers to learn programming. Following is the link to the programming section of the dummies series books.

Thursday, September 04, 2014

MP4 File Format

MP4 file format, also commonly known as MPEG-4 Part 14 or MPEG-4 AVC (Advanced Video Coding) is a multimedia file format used to digitally store audio and video files. MP4 file format is also used for video streaming over the internet. MP4 file format is basically a container which holds audio and video files that are digitally encoded. MP4 file format has only one official file extension i-e .mp4. There are two unofficial file extensions as well namely .m4A which is audio only and .m4p which stands for protected MP4 file format.


MP4 is a more specified version of a general purpose ISO media format based MPEG-4 Part 12 file format. MPEG-4 Part 12 is based on quick time audio/video file format. MPEG was developed in the year 1998 by Motion Picture Expert Group (MPEG) which is also credited with having set the standards for video and audio data encoding. The purpose of developing MP4 file format was to introduce a video and audio file container that could hold low data audio and video file used on internet for streaming. In the year 1998, when MP4 file format was introduced, World Wide Web was gaining popularity and an audio/video format consuming low bandwidth was required.
C:\Users\hp\Desktop\download (4).jpg
Source: www.wikipedia.com

Compression Techniques

Compression algorithm for MP4 file format is somewhat similar to MP3 compression algorithm but MP4 compression is lossless and audio or video quality of the actual file is not decreased.
Video files using MP4 file container are compressed using H.264 or MPEG-4 compression techniques while audio files are compressed using AAC compression algorithm which is also used for .AAC extension file compressions.


  • Suitable for video streaming over the internet.
  • Less loss of quality with higher degree of compression.
  • Can store data types other than video and audio, such as object descriptors, scene descriptors and other object oriented file structures and MPEG features.
  • Separate hint track is used to encode streaming information.
  • MP4 files can be run virtually on all the major media players and sound card drivers.


The only disadvantage of MP4 file format is from editing and movie making point of view. MP4 files are not easy to edit or update.


MP4 file format is used almost everywhere, being the standard video format. Several mobile platforms and handheld devices use MP4 file format as default file format. Smartphones, iPads and Tablets make wide use of MP4 file format in order to play audio and video files.