BKJIA: Do you understand the value of time? I mean, really understand the value of time. Time is definitely your most valuable asset. Once time passes, it will never come back.
As a DBADatabase Administrator: Database Administrator), your skills, services, professional knowledge, and your time are required. You can only take a limited amount of time, which cannot be changed, so effective use of these available time becomes crucial. I assure you that this is a basic principle that all good DBAs believe in.
Importance of Automation
I often find that the database administrator is continuously performing maintenance. I call this situation the "fire fighting mode ". That is to say, they are fighting against the ever-increasing workload, and they have been passively performing maintenance, just from the most important task to the next task, we did not make our own judgment on the global situation. Such a DBA can usually be found in an environment known as "Technical Debt", Coding HorrorJeff Atwood) he discussed the cost of "Technical Debt" in his blog "Paying Down Your Technical Debt. Now, let me tell you that this kind of work is intolerable. System and DBA will eventually crash. Generally, it will take a long time to embark on this path. Do not try to be a DBA hero and leave all the difficulties to yourself. In this case, you will soon be exhausted. What you need to do is to make your work smarter, not more difficult.
For Jeff Atwood's blog "Paying Down Your Technical Debt", refer to: http://www.codinghorror.com/blog/2009/02/paying-down-your-technical-debt.html)
Understanding the value of time and recognizing its importance to a successful DBA is the first step to leverage its powerful magic. As a DBA, you should take some measures to maximize your available time. In this case, it allows you to focus on tasks that can add more value to your enterprise, and puts your O & M in an active mode. In short, to become an efficient database administrator, you must "squeeze out time.
This is the secret of automation and the benefit it can provide to DBAs. The more automated tasks, systems, and processes you have, the more time you have to take the initiative to handle tasks that can create more value for your business and you.
Automate everything
You have not heard the error. I am talking about everything. You should sit down and spend some time thinking about this issue. When you think about the processes and tasks that may be automated, you need to think over and over again. Now, remove the word "possibility" from your dictionary and consider how you can automate everything you do.
Even if you think it is very unlikely that you must repeat a specific task, you have to go forward and automate it! Maybe when you have to repeat this process again, someone will urge you to finish it as soon as possible, or a better case is that you have more important "Active Mode" tasks/projects to complete. For example, you should study hard to pass the MCM authentication, watch the free MCM video for details: http://technet.microsoft.com/en-us/sqlserver/ff977043.aspx) to improve your professional skills. You can trust this authentication. It is also useful in the automatic way of using PowerShell. For details, refer to this video: Author @ anonythemouse .)
At least, create a process for your step and save all your scripts. In this way, you can reuse the results of your work.
There are many ways to achieve automation, from obvious options such as SQL Server Integration Services (SSIS) and PowerShell) to any programming/scripting language you choose, you can select an appropriate method for automation. I even developed a small Java application. I used to be a developer. With the inspiration of my past life, I developed this small program, but I didn't tell our company's developers .), Automate some management tasks. The key to automation is the opposite to the typical DBA practice. Although it is not necessary to use the most suitable tool or technology for a job, however, you must use tools that can automate and complete this job.
I bet you have implemented some truly innovative automation solutions for your tasks and problems. You can share your ideas, skills, and ideas about automation in your comments.
Manage your time from now on
To automate your tasks, you can use your most valuable asset time to the maximum extent.) At the same time, it allows you to focus on tasks that can create more value for your enterprise. From today on, Let's automate everything!
Original article title: The Best Database Administrators Automate Everything