Let's talk about how I learned SQLSERVER.

I believe many people want to become a master of SQL Server. But do you know how these Daniel are made? One of my colleagues has been engaged in. NET development for almost 10 years. Is it a big bull? If he encounters a project he is familiar with, he will be able to get it quickly and complete it immediately, but if he encounters a function he has not done, he will be online

I believe many people want to become a master of SQL Server. But do you know how these Daniel are made? One of my colleagues has been engaged in. NET development for almost 10 years. Is it a big bull? If he encounters a project he is familiar with, he will be able to get it quickly and complete it immediately, but if he encounters a function he has not done, he will be online

TalkI am How LearningSQLSERVER's

I believe many people want to be big cows, but do you know how these cows are made?

One of my colleagues has been engaged in. NET development for almost 10 years. Is it a big bull?

If he encounters a project he is familiar with, he will be able to get it quickly and complete it immediately, but if he encounters a function he has not done, he will be online

Query Information ~ Query Information ~ Query Information ~ Query Information ~

The help is: "check your own information !!"Actually, I know that he has code.

After talking about this, the focus is "code accumulation !!"

I have been writing code for so many years, or the code that has just entered this industry, and I really want to write some code myself.

All rely on "du Niang brother"

Let me talk about how I have accumulated code. I have accumulated code in just a few places:

(1) QQ Group

(2) Books

(3) Online

(4) write by yourself

(5) Forum

I usually use several tools to accumulate code.

First: EVERNOTE

I have been using EVERNOTE for three years. I think it is quite useful. Although it is not for advertising, I think EVERNOTE is really useful.

Put the SQL code that you usually collect into EVERNOTE and search it out when you use it. The search function of EVERNOTE is

Very considerate ~

In addition, EVERNOTE supports automatic synchronization. After synchronization, you only need to install EVERNOTE on your mobile phone to view your SQL code.

I think it is the most convenient thing to do. The SQL code will not be lost!

By the way, the number of my notes is 242. I believe many heroes have exceeded me. It seems that I still have to work hard !!

The second Kingsoft Disk

In addition to EVERNOTE, I put my notes on the Kingsoft disk. In fact, I put my notes on the Kingsoft disk early in the morning, but later I felt that EVERNOTE was easy to search.

Put the SQL code in EVERNOTE, and put it on the Kingsoft disk, so you don't have to worry about losing the code.

SQL code folder in my computer

QQ Group

In fact, bubble QQ Group is also good. I know many heroes and most importantly, Daxia. I think the most nervous thing is that it is the administrator of the QQ Group established by master Song.

After all, I am still a SQLSERVER. Fortunately, the MVP members in the group are very friendly.

I view the Chat History every day, paste the problems and solutions reflected by everyone into EVERNOTE, and save them as SQL scripts for future viewing.

After allLearningStep by step.

Forum

I often visit forums, especially the official MSDN Forum SQL section.

At the beginning, I only asked questions. It was about a year ago. I only asked questions every day and got answers from others.

I have been paying attention to the Forum for a year and have scored a few scores. I have also done MCC in the forum. I hope you will pay attention to it.

The honors you received in the Forum will also be useful when applying for Microsoft MVP in the future. Even if you do not apply for MVP, there will also be a sense of honor, right?

Forum address:Http://social.technet.microsoft.com/Forums/zh-CN/sqlserverzhchs/threads

Books

I have read the SQLSERVER enterprise-level platform management practices in depth, but I have read the paper version, not the electronic version. I have copied it almost all over again.

There is a lot of useful knowledge in books. In fact, I don't like reading performance tuning very much. After all, I am not a DBA, and I am a little afraid of very thick books.

Summary

I believe that if you do this with perseverance, you will surely become a great hero. Of course, you need to add your own interests and love. Recently, a friend of mine has been back to the traditional industry.

He used to work in Kingsoft before. It is a pity that it takes time and energy to go deep into this knowledge and your youth !!!

I hope you can work together and join our QQ Group for SQL Server fans in the Pearl River Delta region.

For SQL activities, the QQ group number will not be mentioned.

--------------------------------------------------------------------------------

Supplement:

EVERNOTE only supports two levels of directories. Unlike mybase, this note-taking software supports multi-level directories. However, I think the benefit of EVERNOTE is that you can enter keywords.

Find your notes, so these shortcomings are not for me personally, the most important thing is to find your own notes in the first time, you can buildNotebook Group

This notebook group only stores yourSQL Server notes

Some people who use EVERNOTE say they cannot find the clear object.Waste paper basketAs longWaste paper basketRight-click on it and you will find the Clear button o (empty _ Empty) o