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 need to check resources 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 need to check resources online.

Let's talk about how I learned SQLSERVER.

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 all, learning is step 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.

Now, after a year, the U.S. server has been paying attention to the Forum and scored a few scores. We have also done the 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:

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. I feel so pity. It takes time and energy to go deep into this knowledge of the Hong Kong virtual host and your youth !!!

After that, I hope you can work together and join our QQ group and virtual hosts 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 my personal shortcomings. The most important thing is to find your notes in the first place. You can create a notebook group.

Only your SQL Server notes are stored in this notebook group.

Some people who use EVERNOTE say they cannot find the clear recycle bin button. In fact, they can find the Clear button by right-clicking on the recycle bin.