SQL neeg rau zaub mov 2012 Nyeem
Microsoft SQL neeg rau zaub mov 2012 yog ib txoj kev txhim kho zoo tshaj plaws database management system (RDBMS) uas muaj ntau yam ntawm cov cuab yeej tawm tswv yim los tswj cov nra hnyav ntawm kev txhim kho database, txij nkawm, thiab kev tswj hwm. Hauv no tsab xov xwm, peb yuav duav qee cov cuab yeej siv ntau dua: SQL Server Management Studio, SQL Profiler, SQL Server Agent, SQL neeg rau zaub mov Configuration Manager, SQL neeg rau zaub mov kev pab thiab Books Online. Cia peb kawm saib txhua yam:
SQL neeg rau zaub mov Management Studio (SSMS)
SQL neeg rau zaub mov Management Studio (SSMS) yog lub ntsiab lus tswj kev sib tham rau SQL Server installations. Nws muab koj nrog ib tug graphical "noog-qhov muag" saib ntawm tag nrho cov SQL neeg rau zaub mov kev sib txuas ntawm koj lub network. Koj tuaj yeem ua haujlwm siab ua haujlwm uas cuam tshuam rau ib los yog ntau tus neeg zov me nyuam, teem caij rau kev tu vaj tse los yog tsim thiab kho cov qauv ntawm cov tib neeg databases. Koj tseem tuaj yeem siv SSMS rau qhov teeb meem sai thiab qias neeg queries ncaj nraim rau ib yam ntawm koj SQL neeg rau zaub mov databases. Cov neeg siv ntawm yav dhau los ntawm SQL neeg rau zaub mov yuav pom tau tias SSMS sib txuas nrog cov kev khiav dej num yav dhau los uas muaj nyob hauv Query Analyzer, Enterprise Manager, thiab Analysis Manager. Nov yog qee cov qauv ntawm cov haujlwm uas koj ua tau nrog SSMS:
- Tsim ib lub rooj SQL neeg rau zaub mov database
- Qhib SQL neeg rau zaub mov kev ua haujlwm nrog Database Cav Tuning Advisor
- Configure SQL neeg rau zaub mov database auditing
- Teem SQL neeg rau zaub mov database replication
SQL Profiler
SQL Profiler muab lub qhov rais mus rau hauv cov haujlwm ua haujlwm hauv koj lub database. Koj tuaj yeem saib xyuas ntau hom kev tshwm sim thiab saib xyuas qhov kev ua tau zoo nyob rau ntawm lub sijhawm. SQL Profiler pub rau koj mus ntes thiab replay system "traces" uas teev ntau yam kev ua ub no. Nws yog ib lub cuab tam uas zoo tshaj plaws rau kev nrhiav cov ntawv qhia nrog cov teeb meem kev ua tau zoo los yog teeb meem kev teeb meem. Raws li nrog ntau SQL neeg tso cai, koj nkag tau mus rau SQL Profiler los ntawm SQL neeg rau zaub mov Management Studio. Yog xav paub ntxiv, saib peb nyeem Tsim Database Traces nrog SQL Profiler .
SQL neeg rau zaub mov Agent
SQL neeg rau zaub mov Agent tso cai rau koj kom automate ntau ntawm cov hauj lwm niaj hnub ua hauj lwm uas siv sij hawm database neeg ua hauj lwm lub sij hawm. Koj tuaj yeem siv SQL Server tus neeg sawv cev los tsim cov hauj lwm uas khiav ntawm lub caij ua haujlwm, cov hauj lwm uas tau ua los ntawm kev ceeb toom thiab cov hauj lwm uas tau pib los ntawm cov txheej txheem khaws cia. Cov haujlwm no muaj xws li cov kauj ruam uas ua tau txhua yam kev ua haujlwm, nrog rau kev pabcuam nyiaj txiag, ua haujlwm khiav haujlwm khiav haujlwm, khiav SSIS tej pob khoom thiab ntau dua. Yog xav paub ntxiv txog SQL neeg rau zaub mov Agent, saib peb nyeem Automating Database Administration nrog SQL neeg rau zaub mov Agent .
SQL neeg rau zaub mov Configuration Manager
SQL neeg rau zaub mov Configuration Manager yog ib tug SNAP qhia-rau Microsoft Management Console (MMC) uas tso cai rau koj tswj tus SQL neeg rau zaub mov kev pab khiav ntawm koj cov servers. Lub functions ntawm SQL neeg rau zaub mov Configuration tus thawj tswj muaj xws li pib thiab siv ceev xwmphem cov kev pabcuam, kho cov kev pabcuam khoom thiab cov kev sib txuas ntawm cov qauv kev sib txuas ntawm network. Ib co piv txwv ntawm SQL Server Configuration Manager kev pab raws qib:
- Pib ntawm SQL Server Agent Service (lossis lwm yam kev pabcuam SQL) nrog Configuration Manager
- Encrypting SQL neeg rau zaub mov database txuas nrog SQL neeg rau zaub mov Configuration Manager
Kev Pabcuam Kev Tshaj Lij Muab Kev Vam Meej (SSIS)
SQL Server Integration Services (SSIS) muab ib txoj kev yooj yim rau importing thiab exporting cov ntaub ntawv ntawm Microsoft SQL Server installation thiab ntau ntau lwm hom ntawv. Nws tau hloov cov ntaub ntawv Transformation Services (DTS) pom nyob rau hauv versions dhau los ntawm SQL neeg rau zaub mov. Yog xav paub ntxiv txog kev siv SSIS, mus saib peb cov ntawv nyeem Txais thiab Export cov ntaub ntawv nrog SQL Server Integration Services (SSIS) .
Phau ntawv Hauv internet
Cov ntawv hauv online yog ib qho kev pabcuam pheej yig nrog rau SQL neeg ua haujlwm uas muaj cov lus teb rau ntau yam kev tswjfwm, kev txhim kho thiab kev teebmeem. Nws yog ib qhov zoo rau kev sib tham ua ntej xa mus rau Google los yog kev txhawb nqa. Koj tuaj yeem nkag tau hauv SQL Server 2012 Phau Ntawv Hauv Online ntawm Microsoft lub website lossis koj tuaj yeem luam tau cov ntawv luam ntawm Cov Ntawv Teev Lus Online hauv koj lub zos.
Txij ntawm no tus taw tes, koj yuav tsum tau muaj kev nkag siab zoo ntawm cov cuab yeej yooj yim thiab cov kev pab cuam nrog rau Microsoft SQL Server 2012. Thaum SQL neeg rau zaub mov yog lub complex, robust database tswj qhov system, qhov kev paub txog tus tub ntxhais yuav tsum tau coj koj mus rau cov cuab yeej muaj los pab cov neeg khiav dej num lawv cov SQL neeg rau zaub mov kev sib txuas thiab taw tes koj nyob rau hauv txoj kev xaiv kom paub ntau ntxiv txog lub ntiaj teb ntawm SQL neeg rau zaub mov.
Raws li koj mus ntxiv rau koj cov lus qhia SQL neeg kawm ntawv, kuv caw koj tuaj yeem tshawb txog ntau yam kev pabcuam muaj nyob rau ntawm qhov chaw no. Koj yuav nrhiav tau cov tutorials uas hais txog ntau yam ntawm cov thawj kev khiav hauj lwm yooj yim ua los ntawm SQL neeg rau zaub mov thawj tswj raws li cov lus qhia txog kev khaws koj cov SQL neeg rau zaub mov databases ruaj ntseg, txhim khu kev qha thiab optimally tuned.
Koj kuj raug caw tuaj koom nrog peb nyob rau hauv Cov Lus Qhia Txog Databases nyob qhov twg ntau ntawm koj cov npoj yaig yog muaj los tham txog cov teeb meem hais txog SQL neeg rau zaub mov los yog lwm lub chaw sib tw database.