Sunday, October 19, 2014

My Best LinkedIn Articles

Sunday, October 12, 2014

My Best Technical Sites and Blogs

Many times my friends ask me which technical sites they should refers for finding the solutions, so below is the list of tech sites which I used to refer most of the times for learning technologies and finding the solutions I like this site because I find here some very good tutorials in SQL which are very simple to understand and gives some good knowledge for a person which is not expert in SQL Server. I love this site since it has some brilliant authors who share their knowledge through some very good articles. This is Microsoft sites where you can get help on any topic however small it may be. Some in depth information with easy to understand language. This is one of my favorite discussion forum where you can get the solutions of most of your problems. Also from multiple answers , you can also mention which is working or which is best which help others. This site needs no introduction as it contains lots of articles on each technology. Lots of technical professional share their knowledge on this site. You can ask your question in this site ask question section. You can get many quality articles on this site. Also best articles of the month competition is always going on where you can win some good prizes by submitting your articles and winning the competition. is my blog where I share my technical knowledge though articles. I always reads the articles on this site before going for any interview or whenever I needs to brush up my knowledge. So always trying to maintains the quality of articles on this site. Like Simple-talk, this is one of the best site for database. Have so many brilliant database experts as its author. Daily publish so many quality articles and also mentions good articles from other sites too. Its Question of the Day sections always comes up with a very good objective questions. Whenever you search for any SQL topic or issue , Google always show the link of this site in first few entries. Run by one of the best Indian database legend Pinal Dave, this site contains lots of SQL articles from small to complex topics. This is the site which helps me a lot in learning the SQL Server. A video tutorial site contains lots of video tutorials for each
and every technology. All tutorials contains good explanations of the concepts with some very good demo. You can also took pre course online test to judge your knowledge before starting the course and also took post course test to judge your increased knowledge.You only has to subscribe on it which cost you some monthly fees. It has 2 options of subscription is the best site for learning Android development. All tutorials on this site has been written in a very simple language which is easy to understand. I must say it is a must read site for any developer who want to learn android or working on it.

There are some other popular sites also like, C#corner,, which you can refers for finding your solutions. If you refers some other quality technical site or blog, please mention it as a comment so that others also get benefited. 

Monday, August 18, 2014

SQLTea - New SQL tutorial app in Google play store

SQLTea - Our new SQL Tutorial App on Google Play Store
We are happy to announce our new SQL tutorial app SQLTea  ( Native android app) for SQL learning which includes articles from this blog.

This application includes 

1) Articles for basic concepts like Normalization, Constrains, Joins, SQL Functions, SQL commands etc and also advance concepts like SQL Triggers, Views, Cursors, Stored Procedures and many more.

2) Every article is explained with the help of examples. new new app

3) Once installed, it will work in offline mode (No Internet needed). You can read articles easily even if you don't have Internet connections

4) Includes many popular articles from this blog.

5) Light weight and fast

6) Will going to frequently update this App with new blog articles.

7) Simple to use and navigates.

So please download this app and gives your valuable comments on it.

Sunday, August 17, 2014

How to restore database backup in SQL SERVER

In this article, I am going to explain the process of  Database restoration using the SQL Server Management Studio. In this article, I will try to explain this process in a simple way so that a database developer having little knowledge of DBA can restore that database using the database backup.

For database restoration process, we need to follow the below steps:-

Step 1:- Open the SQL Sever Management Studio. For this we have to follow the following path:-

START --> All Programs --> Microsoft SQL Server 2008R2 --> Click on SQL Sever Management Studio (SSMS) --> Open the SQL Server Management Studio using Login information (Username & password or Window authentication )

Please note:- Above path can be changed depending on the Window version.

Step 2:- Once SQL Sever Management Studio is opened, opened the Object Explorer. By default it will be already opened. If it is not opened, then follow the below steps to open it.

Click on the View(Top menu) --> Click on Object Explorer.

Step 3:- Under the Databases node, select the database for Restoration and right click on it. Then choose Tasks, click on Restore and then choose the Database... as shown in the below figure. Here we choose the Company_DB as database.

Select Database for restore process

Step 4:- On the click of Database.. link,  we get the Restore Database window. In this window, we can select the database backup file, first by selecting the Device radio button and then click on the Add button, as shown in the below figure:-

Select Backup file location

Step 5:- When we click on the Add button, Locate Backup File Window is opened. On this window, we have to choose the backup file of the database as shown in the below figure.

Select Database backup file

Step 6:- When user selected the database backup file and click on the OK button, it will close the Locate Backup File window. Now on the Restore database window we can see the selected database backup file as shown in the below figure.

Selected backup file
Step 7:- When we click on the Options link, below screen will be shown

Database restoration Options
In this screen, we can see many options like overwrite the existing database and many others. We can leave this screen with default values. we usually choose the option of overwrite the existing database, but user can choose other options as per his/her requirement.

If you want to know this process and its all option in detail, you can refer below link of MSDN

Restore a Database Backup (SQL Server Management Studio)