SQL Server 2012 Tutorial
Microsoft SQL Server 2012 ndi dongosolo lonse lothandizira mauthenga apakompyuta (RDBMS) omwe amapereka zipangizo zosiyanasiyana zothandizira kuti athetse mavuto a chitukuko cha database, kusamalira, ndi maulamuliro. M'nkhaniyi, tiona zida zowonjezereka zogwiritsidwa ntchito: SQL Server Management Studio, SQL Profiler, SQL Server Agent, SQL Server Configuration Manager, SQL Server Integration Services ndi Books Online. Tiyeni tione mwachidule aliyense:
SQL Server Management Studio (SSMS)
SQL Server Management Studio (SSMS) ndizitsulo zazikulu zothandizira SQL Server. Ikukupatsani inu malingaliro a "mbalame-diso" pazitsulo zonse za SQL Server pa intaneti yanu. Mungathe kuchita ntchito zapamwamba zothandizira zomwe zimakhudza ma seva limodzi kapena angapo, pangani ndondomeko yowonongeka yowonongeka kapena kupanga ndi kusintha ndondomeko yazomwe zilipo. Mungagwiritsenso ntchito SSMS kuti mupereke mauthenga mwamsanga ndi onyoza motsutsana ndi ma SBL Server iliyonse. Ogwiritsa ntchito SQL Server oyambirira adzazindikira kuti SSMS ikuphatikiza ntchito zomwe zinapezeka kale mu Query Analyzer, Enterprise Manager, ndi Analysis Manager. Nazi zitsanzo za ntchito zomwe mungachite ndi SSMS:
- Pangani tebulo lachinsinsi la SQL Server
- Sungani zotsatira za SQL Server ndi Advisor Database Tuning Advisor
- Sungani ndondomeko yoyang'anira ndondomeko ya SQL Server
- Konzani ndondomeko yachinsinsi ya SQL Server
SQL Profiler
SQL Profiler amapereka zenera mkati mkati mwa ntchito yanu. Mukhoza kuyang'ana mitundu yosiyanasiyana ya zochitikazo ndikuwonetsetsa zomwe zikuchitika pa nthawi yeniyeni. SQL Profiler amakulolani kuti mutenge ndi kubwezeretsanso dongosolo "zochitika" zomwe zikulemba ntchito zosiyanasiyana. Ndi chida chachikulu chothandizira malemba ndi zotsatira za ntchito kapena kuthetsa mavuto ena. Mofanana ndi ntchito zambiri za SQL Server, mukhoza kupeza SQL Profiler kupyolera mu SQL Server Management Studio. Kuti mudziwe zambiri, onani phunziro lathu Kupanga Zotsatira Zamalonda ndi SQL Profiler .
SQL Server Agent
Wothandizira SQL Server amakulolani kuti muzitha kugwira ntchito zambiri zowonongeka zomwe zimadya nthawi yowonetsera deta. Mungagwiritse ntchito wothandizira SQL Server kuti apange ntchito zomwe zimayenda nthawi ndi nthawi, ntchito zomwe zimayambitsidwa ndi machenjezo ndi ntchito zomwe zimayamba ndi njira zosungidwa. Ntchito zimenezi zingaphatikizepo masitepe omwe amachititsa pafupifupi ntchito iliyonse yothandizira, kuphatikizapo ndondomeko zothandizira, kupanga malamulo, kugwiritsa ntchito ma SSP komanso zina zambiri. Kuti mudziwe zambiri pa SQL Server Agent, onani phunziro lathu Automating Database Administration ndi SQL Server Agent .
SQL Server Configuration Manager
SQL Server Configuration Manager ndilowetsamo kwa Microsoft Management Console (MMC) yomwe imakulolani kuti muyang'anire ma seva a SQL Server akuyenda pa ma seva anu. Ntchito za SQL Server Configuration Manager zimaphatikizapo kuyamba ndi kusiya ntchito, kukonza mautumiki komanso kukonza njira zogwirizanitsa mauthenga. Zitsanzo zina za SQL Server Configuration Manager ntchito zikuphatikizapo:
- Kuyambitsa SquL Server Agent Service (kapena maselo ena a SQL Server) ndi Configuration Manager
- Kulemba zida zogwirizana ndi SQL Server ndi SQL Server Configuration Manager
SQL Server Integration Services (SSIS)
SQL Server Integration Services (SSIS) amapereka njira yosinthasintha kwambiri yoitanitsira ndi kutumiza deta pakati pa kuikidwa kwa Microsoft SQL Server ndi mitundu yambiri yosiyanasiyana. Amalowetsa Data Transformation Services (DTS) m'mabuku oyambirira a SQL Server. Kuti mumve zambiri zokhudza kugwiritsa ntchito SSIS, onani phunziro lathu Kutumiza ndi Kutumiza Dongosolo ndi SQL Server Integration Services (SSIS) .
Mabuku Othandizira
Mabuku omwe amapezeka pa intaneti ndi makina omwe sagwiritsidwe ntchito ndi SQL Server omwe ali ndi mayankho osiyanasiyana. Ndi chitsimikizo chothandizira kuti musanatembenuzire Google kapena chithandizo chamakono. Mukhoza kupeza SQL Server 2012 Books Online pa webusaiti ya Microsoft kapena mukhoza kukopera makope a mabuku pa Intaneti pa machitidwe anu.
Panthawiyi, muyenera kumvetsetsa bwino zida zofunika ndi ntchito zomwe zimagwirizanitsidwa ndi Microsoft SQL Server 2012. Ngakhale kuti SQL Server ndi yovuta, dongosolo lothandizira kusunga maina, izi ziyenera kukutsogolerani ku zipangizo zomwe zikuthandizira kuthandizira ogwira ntchito SQL Server yawo ndikuyikidwa mu njira yoyenera kuti mudziwe zambiri za dziko la SQL Server.
Pamene mukupitiriza ulendo wanu wophunzira SQL Server, ndikukupemphani kuti mufufuze zambiri zopezeka pa tsamba lino. Mudzapeza maphunziro omwe akugwira ntchito zambiri zoyendetsera ntchito za oyang'anira SQL Server komanso malangizo kuti musunge SQL Server ndondomeko zotetezeka, zodalirika komanso zoyendetsedwa bwino.
Mwapitsidwanso kuti muthandizane nawo ku About Databases Forum kumene ambiri a anzanu akupezeka kuti akambirane za SQL Server kapena masitepe ena.