INTRODUCTION
What will the SQL Sever database adminstrator's(DBA) jobs be like 10 years from now?

The is a broad qustion. It implies another question: will there be such a thing as a SQL Sever DBA in 10 years? By job tilte, I think the answer is clearly yes, there will certainly be SQL Sever DBAS in 2018. Much less clear, however, is what exactly SQL Sever DBAS will spend their time doing. This paper offer some answer to this question based on the current and foreseeable industry and technological trends.

<
介紹：
十年后SQL Sever數據庫管理員這個位置發展成什么樣子？

這是一個很大的問題，這也暗示這另一個問題的答案： 在十年后是否還會存在數據庫管理員這樣一個概念？ 看這個職位的頭銜答案是顯然的，在2018年當然還會存在SQL Sever數據庫管理員。然而那時的DBAS會做些什么就不是那么明顯了。這份報告通過對當前和可預期的工業和技術的發展為這一個問題提供了一些可能的答案。
>

HISTORY

To look 10 years ahead, it's helpful to look 10 years back in the past. An old aphorism goes something like: to know where you are going you must know where you have been. It holds true much of the time. And not only does it apply to IT in general, but it also apply to the SQL Sever world pariticularly well.

<
歷史：
回顧過去對展望未來是很有幫助的。有句古話說，要知道你要去哪里那你必須知道你走過的地方。這確實要花費很多時間，不僅僅是大概回顧IT的概況，還需要特別好的了解這個SQL Sever的世界。
>

1998: SQL Sever Growing Pains

In 1988, I had been a SQL Sever DBA for 4 years, haveing started out with version 4.21a in 1994. By 98, we on underway on migrating from version 6.5 to the newly rewritten SQL Sever 7. In those days, the job of the DBAS was mostly about getting SQL Sever to work because we are in a transition phase from  considering SQL Sever as a departmental-only RDBMS to using it for enterprise-wide applications. There arme some growing pains. Some plans are too ambitious. And there were a few failures.

<
1998： SQL Sever的坎坷成長

1998年，我已經做了四年的DBA，從94年起，最開始用得4.21a的版本。到了98年，我們正在從6.5升級到剛剛重寫的SQL Sever 7.0在那個時候DBA的工作主要是會SQL Sever工作，因為在那個時侯我們處在一個過渡期，在考慮是將SQL Sever作為一個僅部門上的關系數據庫還是作為企業范圍的共享的應用。這中間有一些坎坷，有些計劃太大了，遺留了一些失敗的案例。
>

Also in 1998, expansion of server environments was well underway during the population explosion. New application? No problem, fire up another NT server. Virues? Only on PCs, not on NT. Worms? Never heard of them; SQL Slammer was still years in the future. About the only thing that really concerned us back then was Y2K<千年蟲> looming ahead<迫在眉睫>.

<
同樣是在1998年，人口的劇增導致的服務要求的擴大。新的技術？沒有問題，再啟動一個NT Sever。病毒？在pc機上而已，不是在服務器上。蠕蟲？從來沒聽說過；SQL末路還在遙遠的未來。而在那個時候唯一迫在眉睫要我們關注的是千年蟲事件。
>

2008: A Host of Broade Issues

Times have changed to be sure. Issues that were not even on our radar screens back in 1998 are at the forefront today. Issues that of paramount<最重要的，最高的> importance back then have disappeared. The question of whether SQL Sever will work for a given application is now moot. We know it will.

<
當然時代已經改變。98年出現在雷達屏幕上的問題現在就在眼前。那時相當嚴峻的問題已經不在了。關于SQL Sever是否能夠為給定的應用程序工作的討論已經沒有意義了，我們知道它會的。
>

Today's issues are much broader and there are more of them. Security, for example, has become multi-faceted in recent years, with the following, equally important issues:
1.Protection from viruses,worms,denial-of-service attacks
2.Protection of data
3.Audition of data
4.Disposal of data
Compliance requirements, such as Sarbanes-Oxley, while closely related to security, goes much deeper and can have major implications for database resourse utilization. In some companies, e-discovery has eclipsed Sarbanes-Oxley as the biggest non-productive resource consumer.

<
如今的問題更多更廣。比如說安全，近年來已演變為多層面的，包括以下幾個重要的部分：
1.防病毒，蠕蟲，和拒絕服務攻擊
2.數據保護
3.數據審核
4.數據處理
企業合格要求走的越來越深，要求了對數據庫資源的利用，像同安全緊密相聯系的薩班斯-奧克斯法案。在有些公司，e-discovery解決法案已經超越了薩班斯法案的應用，成為了最大的非生產性的資源消費。
>

The data growth explosion continues at an accelarated pace. SQL Sever DBAs find it more dificult to get their databases backed up<備份>. Fortunately, there are tools such as Quest Software's LiteSpeed that can shrink database backup files to a fraction<小部分，分數> of their normal size.

<
數據爆發仍然在以加速度增長，SQL Sever DBAs發現數據庫數據備份越來越難。幸運的事，現在有工具可以將數據庫備份文件壓縮到其正常大小的一小部分，比如Quest Software的LiteSpeed。“搞了半天原來是在做廣告”
>

Will the crucial issues we face today disappear in 2008? It's possible. It's not that audition, viruses, and scurity won't matter. It's that the way we handle those things will have become so mundance<普通，平凡> that we will no longer spend much time thinking about them. A standard SQL deployment<部署> will imply that all data is encrpted, changes are logged<記錄日志>, patching is automatic and unattended.

<
2018:新的一系列問題

我們現在的面臨的關鍵問題在2018年將會消失么？有這種可能。但不是審核，病毒，和安全問題就不再存在，而是我們處理這些問題的方式太熟悉普通而不用花費太多時間。一個標準的SQL Sever部署需要數據加密，日志修改，自動和隱蔽修補。
>

Instead of these compliance and security issues, we have a new batch of problems to deal with. The rest of this paper explores some of the industry and technological trends that are either alread occuring or that are expected to occur in the next 10 years. We will explore what those trends will mean for the SQL Server DBA.
<
沒有了這些安全和規程的問題，又有新的問題需要我們處理。下面報告要探索一下產業技術趨勢，這其中有些已經出現，有些在未來十年將會產生。我們來探求這些趨勢對SQL Sever數據庫管理員意味著什么。
>

TECHNOLOGICAL TRENDS
Hints<線索，淺析> in SQL 2008

SQL Server 2008 provide new features that provide some insight into the direction of database administration in the coming years. The new Declarative Management Framework (DMF) for example-which is basically a means to define policies and apply them across the enterprise on multiple instances-is a step away from individual instance management.
<
淺析SQL 2008
SQL Server 2008 提供了一些新特性暗示了DBA的在未來幾年的方向。比如基于策略化管理的Declarative Management Framework（DMF），將被應用與公司的多實例環境，與單實例管理僅有一步之遙。
>

Third-party<承擔第三方責任> venders<零售商> have alread started down the path. For example, Quest Software's latest version of Change Director provides robust<強大的> fuctionality<功能> to manage an entire enterprise's SQL Agent jobs from a single point. More and more, tools and functionality will be geared<n工具，v使適合> towards managing the SQL Sever farms rather than the individual instances.
<
第三方廠家已經開始采用這種策略。比如Quest Software的Change Director的新版本提供了強大的功能來實現從一個點上來管理整個公司的SQL代理工作。越來越多的工具和功能在試圖實現場服務器模式，而非獨立服務器模式。
>

Another new SQL 2008 feature is the Recource Governor<資源管理>. This much-needed feature allow the DBAs to set priorities and resource limits on individual jobs, which is a key in preventing processes from getting starved for resources. Yet another is new feature is the "Hot Add Cpu" that will allow the addition of CPUs to supported hardware without downtime.
<
另一個SQL 2008新特性是資源管理，這個常用的特性允許管理員為個體工作設置優先級和資源限制。這有效的防止了因資源處于餓死的進程。還有一個特性是“Hot-Add-CPU”，它允許在不停機的狀況下為硬件添加可兼容的cpu。
>

These new features point to a future in which SQL Severs are managed at the enterprise-level with dynamic resource allocation<動態資源分配>.As this trend continues, the SQL Sever DBA's job will evolve with the changing landscape.
<這些新特性指出了SQL在企業級上動態資源分配的前景，按此趨勢發展，SQL Sever管理員的工作同樣要隨著發展改變>

參考資料：

1.“千年蟲”問題的根源始于60年代。當時計算機存儲器的成本很高，如果用四位數字表示年 份，就要多占用存儲器空間，就會使成本增加，因此為了節省存儲空間，計算機系統的編程 人員采用兩位數字表示年份。隨著計算機技術的迅猛發展，雖然后來存儲器的價格降低了， 但在計算機系統中使用兩位數字來表示年份的做法卻由于思維上的慣性勢力而被沿襲下來， 年復一年，直到新世紀即將來臨之際，大家才突然意識到用兩位數字表示年份將無法正確辨 識公元2000年及其以后的年份。1997年，信息界開始拉起了“千年蟲”警鐘，并很快引起了 全球關注。


2.上世紀末本世紀初，各種公司丑聞屢屢出現，導致美國國會出臺了《2002 年薩班斯-奧克斯利法案》（the Sarbanes-Oxley Act of 2002，簡稱SOX法案）。它對公司治理有著極為嚴格和苛刻的要求，它要求公司針對產生財務交易的所有作業流程，都做到能見度、透明度、控制、通訊、風險管理和欺詐防范，且這些流程必須詳加記錄到可追查交易源頭的地步。SOX法案的要求是全面且復雜的。SOX法案對于上市公司來說，是一個嚴峻的挑戰，同時也是一個改善公司治理的機會。

3.Compliance Requirement

4.e-discovery 解決方案

5.Windows SharePoint Services Configurations配置模式
You can choose between two configurations for Windows SharePoint Services: stand-alone server or server farm. If you anticipate only light usage of your Web sites, you can use the stand-alone server configuration. If you are supporting Web sites in a large organization or as an Internet service provider (ISP), and anticipate heavy usage and a lot of data, you will most likely want to use the server farm configuration.WSS2支持兩種配置模式：獨立服務器模式和場服務器模式。