Isifundo se-SQL Server 2012
I-Microsoft SQL Server 2012 iyisistimu yokuphathwa kwedatha ehlobene ngokugcwele-ebonakalayo (RDBMS) enikeza amathuluzi ahlukahlukene wokuphatha ukuze unciphise imithwalo yokuthuthukiswa kwedatha, ukugcinwa, nokuphathwa. Kulesi sihloko, sizohlanganisa amanye amathuluzi asetshenziswe kakhulu: SQL Server Management Studio, SQL Profiler, SQL Server Agent, SQL Server Configuration Manager, SQL Server Integration Services kanye Books Online. Ake sibuke kancane ngalunye:
I-SQL Server Management Studio (SSMS)
I-SQL Server Management Studio (SSMS) iyona console enkulu yokuphatha ye-SQL Server ukufaka. Ikunikeza ngombono obala "wezinyoni-iso" kuwo onke ama-installations we-SQL Server kunethiwekhi yakho. Ungenza imisebenzi ephezulu yokuphatha ethinta iseva eyodwa noma ngaphezulu, uhlele imisebenzi evamile yesondlo noma udale futhi ushintshe isakhiwo semininingwane yolwazi. Ungasebenzisa futhi i-SSMS ukukhipha imibuzo esheshayo neyingcolile ngqo ngokumelene nanoma iyiphi enye yolwazi lwakho lwe-SQL Server. Abasebenzisi bezinguqulo zangaphambili ze-SQL Server bazoqaphela ukuthi i-SSMS ifaka imisebenzi eyatholakala ngaphambilini ku-Query Analyzer, Enterprise Manager, kanye ne-Analysis Manager. Nazi ezinye izibonelo zemisebenzi ongayenza nge-SSMS:
- Dala itafula lemininingwane ye-SQL Server
- Yenza ukusebenza kwe-SQL Server ne-Database Engine Tuning Advisor
- Lungiselela ukuhlolwa kwemininingwane ye-SQL Server
- Setha ukuphindaphinda kwedatha ye-SQL Server
SQL Profiler
I-SQL Profiler inikeza iwindi ngaphakathi kokusebenza kwangaphakathi kwedatha yakho. Ungakwazi ukuqapha izinhlobo eziningi zemicimbi ehlukahlukene futhi ubheke ukusebenza kwedatha ngesikhathi sangempela. I-SQL Profiler ikuvumela ukuba ubambe futhi ubuyekeze uhlelo "amathrekhi" alobe imisebenzi ehlukahlukene. Kuyithuluzi elikhulu lokuthuthukisa ulwazi olusetshenziswayo ngezinkinga zokusebenza noma ukuxazulula izinkinga ezithile. Njengemisebenzi eminingi ye-SQL Server, ungakwazi ukufinyelela ku-SQL Profiler ngokusebenzisa iSQL Server Management Studio. Ukuze uthole olunye ulwazi, bheka isifundo sethu Ukudala Amathrekhi Wezambiso nge-SQL Profiler .
I-Agent ye-SQL Server
I-Agent ye-SQL Server ikuvumela ukuthi uguqule imisebenzi eminingi yokuphatha evamile edla isikhathi somlawuli wedatha. Ungasebenzisa i-ejenti ye-SQL Server ukudala imisebenzi ehamba ngezikhathi ezithile, imisebenzi eqaliswa yizaziso nemisebenzi eqaliswa izinqubo ezigcinwe. Lezi zinsuku zingafaka izinyathelo ezenza cishe noma yikuphi umsebenzi wokuphatha, kufaka phakathi imininingwane yokusekela, ukwenza imiyalo yesistimu yokusebenza, ukusebenzisa amaphakheji we-SSIS nokuningi. Ukuze uthole ulwazi oluthe xaxa ku-Agent SQL Server, bheka isifundo sethu Sokuzenzakalela Ukuphatha Database kanye ne-SQL Server Agent .
Isiphathi Sokuhlela I-SQL Server
I-SQL Server Configuration Manager i-snap-in ye-Microsoft Management Console (MMC) evumela ukuthi ulawule amasevisi we-SQL Server asebenza kumaseva wakho. Imisebenzi ye-SQL Server Configuration Manager ihlanganisa amasevisi okuqala nokuma, ukuhlela izakhiwo zesevisi nokulungisa izinketho zokuxhumana zenethiwekhi. Ezinye izibonelo zemisebenzi ye-SQL Server Configuration Manager zifaka:
- Ukuqala isevisi ye-SQL Server Agent (noma amanye amasevisi we-SQL Server) ne-Configuration Manager
- Ukubethela ukuxhumana kwedatha ye-SQL Server ne-SQL Server Configuration Manager
Isevisi yokuhlanganiswa kwe-SQL Server (SSIS)
Isevisi yokuhlanganiswa kwe-SQL Server (SSIS) inikeza indlela eguquguqukayo kakhulu yokungenisa nokuthumela idatha phakathi kokufakwa kwe-Microsoft SQL Server kanye nezinhlobo eziningi ezihlukahlukene. Ibeka esikhundleni se-Data Transform Services Services (DTS) etholakala ezinhumulweni zangaphambili ze-SQL Server. Ukuze uthole olunye ulwazi mayelana nokusebenzisa i-SSIS, bheka ulwazi lwethu lokufaka nokuthumela idatha nge-SQL Server Integration Services (SSIS) .
Izincwadi Online
Amabhuku atholakala ku-intanethi imithombo evame ukungahoxiswa enikeziwe nge-SQL Server equkethe izimpendulo ezinhlobonhlobo zokuphatha, ukuthuthukiswa kanye nokufakwa kwezinkinga. Kungumthombo omkhulu wokubonisana ngaphambi kokubuyela ku-Google noma ukwesekwa kwezobuchwepheshe. Ungangena kwi-SQL Server 2012 Books Online ku-website ye-Microsoft noma ungalanda futhi amakhophi wamadokhumenti e-Books Online kumasistimu wakho wendawo.
Ngalesi sikhathi, kufanele ube nokuqonda okuhle amathuluzi ayisisekelo namasevisi ahlobene ne-Microsoft SQL Server 2012. Nakuba i-SQL Server yinkimbinkimbi, i-robust system management system, lolu lwazi oluyisisekelo kufanele lukuqondise amathuluzi atholakalayo ukusiza abalawuli bezinqolobane ukufakwa kwabo kwe-SQL Server futhi bakukhomba endleleni efanele yokufunda kabanzi ngezwe le-SQL Server.
Njengoba uqhubeka nohambo lwakho lokufunda lwe-SQL Server, ngiyakumema ukuba uhlole izinsiza eziningi ezitholakala kule sayithi. Uzothola izifundiswa ezihlanganisa imisebenzi eminingi eyisisekelo yokuphatha eyenziwe ngabaqondisi be-SQL Server kanye neseluleko ekugcineni imininingwane yakho ye-SQL Server evikelekile, ethembekile futhi ehlelwe kahle.
Uyakumenywa ukuthi uzosijoyina kwi-About Databases Forum lapho abaningi osebenza nabo bekhona ukuze baxoxisane ngezinkinga ngeSQL Server noma amanye amapulatifomu wedatha.