Ashesh Saini | Blog

A cheat sheet is a concise set of notes used for quick reference. “Cheat sheet”(sometimes also rendered as “cheatsheet” or “cheat-sheet”) can be used like a memory refreshing tool. Cheat sheets are popular in any area where a quick reference is useful, not just for examinations. Like computer industry has many cheat sheets due to the high number of commands, actions, procedures, terms and concepts one must learn to use programming languages and interfaces. In Information Technology, a cheat sheet is a reference tool that provides simple, brief instructions for accomplishing a specific task. Below you will find the Various professionally prepared and Must have cheat sheets on most of topics from computer software and internet world. As you cant remeber the URL of every page which have cheat sheet, So Please feel free to bookmark this post to get all under one umbralla. Now keep all the information at your fingertips. Do you have/know a useful cheat sheet that you’d like me to consider posting? Let me know! Read more…

Some days back I got stuck up in a concept related to SQL (structured Query Language). It was a bit complex one, and I started googling to know about that. Then I came accros some informative articles about the RDBMS, SQL language and various issues of SQL server. Here I will share all that with you.

SQL Tips and Tricks : Hundreds of SQL articles, tips & tricks, and tutorials.
SQL Coding Standards [PDF] : Learn professional coding guidelines.
SQL Server Interview FAQ’s/Answers [PDF] : Conprehensive List of Questions/Answers, Definitions and concepts, which asked in interviews and must known for every techie.
Data warehousing [PDF] : From basics to advanced about data warehousing.
Shortcuts: SQL Server Management Studio Keyboard Shortcuts [PDF] [Click to download]
SQL Query Analyzer Shortcuts [PDF] [Click to download]

All the above material is really much much useful and so informative that you can even think about making your career as DBA( DataBase Administrator). This is my first post on any technical topic, hope you will get another hundreds of soon.

Question: What is the difference between testing and debugging?
Answer: Testing is the performed by tester with the intent of finding a bug in an application. Upon finding a bug, the tester will be reporting it to development team.
Debugging is the act of fixing the bugs that is reported by either the testing team or by the end users. Debugging is done by the development team.

Question: What is difference between Integration testing & Inter system testing?
Answer:
Integration testing: Integrate the all modules and test whether it is functioning correctly or not.
Inter system testing: Testing whether our application/software is supporting the existing software or OS.

Question: What is the difference between SRS and BRS?
Answer: SRS is prepared by Software Analyst. They implement the BRS in preparation of SRS.
BRS is given by Client. It tells the business Logics.

Question: How you prepare Test Data? Is it from Functional Requirements?
Answer: If Functional requirements are available, that means, prior application releases are available, thus best test data comes from it’s operating environment (Production).
Otherwise, create new data to fit the conditions listed in the requirements.

Question: What is the difference between Test Bed and Test Harness?
Answer:
Test Bed: An execution environment configured for testing as hardware, software, networks etc.
Test Harness: A program or test tool used to execute a test it is also known as test driver.

Question: Why do you like to test?
Answer: I like test because I want to give better quality product to my company client and I want to prove the developer can do mistakes I want to find it. So, I like testing.
Read more…