SQL Server 2012 Tutorial
I-Microsoft SQL Server 2012 yinkqubo yolawulo lweenkcukacha zobudlelwane obugcweleyo (RDBMS) enika izixhobo ezahlukeneyo zokulawula ukukhupha imithwalo yokuphuhliswa kwedatha, ukugcinwa kunye nokuphathwa. Kule nqaku, siza kubhala ezinye zezixhobo ezisetyenziswa rhoqo: I-SQL Server Management Studio, i-SQL Profiler, i-Agent SQL Server, uMphathi we-SQL Server, u-Integrated Services and Books Online. Makhe sijonge kancinci nganye:
SQL Server Management Studio (SSMS)
I-SQL Server Management Studio (i-SSMS) iyona console yokulawula eyona nto yokufakwa kweSQL Server. Ikwabonela ngombono ocacileyo "weentaka-iso" kwiinkqubo zonke zokufakela kwi-SQL Server kwinethiwekhi yakho. Unokwenza imisebenzi ephezulu yokuphatha echaphazela enye iseva okanye ngaphezulu, yenza ishedyuli imisebenzi efanayo okanye yenza kwaye uguqule isakhiwo seenkcukacha zolwazi. Ungasebenzisa kwakhona i-SSMS ukukhupha imibuzo ngokukhawuleza kwaye engcolileyo ngokukhawuleza nxamnye nayiphi na yolwazi lweSQL Server yolwazi. Abasebenzisi beenguqu zangaphambili ze-SQL Server baya kuqaphela ukuba i-SSMS ifaka imisebenzi efunyenwe ngaphambili kwi-Query Analyzer, Manager Manager, kunye noMphathi wohlalutyo. Nantsi imimiselo yemisebenzi ongayenza ngeSMSMS:
- Yakha itafile yedatha yeSQL Server
- Tune ukusebenza kweSQL Server kunye neNgcaciso yoMxhasi weNjini yeDrive
- Cwangcisa uphicotho lweenkcukacha ze-SQL Server
- Misela ukuphindaphinda kwesiseko seSQL Server
SQL Profiler
I-SQL Profiler inikezela ngefestile ekusebenzeni kwangaphakathi kwenkcazelo yakho. Unokujonga iindidi ezahlukeneyo zeemeko kwaye uqaphele ukusebenza kwedatha ngexesha langempela. I-SQL Profiler ikuvumela ukuba ubambe kwaye uphinde ubuyekeze "inkqubo" egcina imisebenzi ehlukahlukeneyo. Isixhobo esikhulu sokuphucula iinkcukacha zolwazi ngemicimbi yokusebenza okanye ukujongana neengxaki ezithile. Njengemisebenzi eminingi ye-SQL Server, unokufikelela kwi-SQL Profiler nge-SQL Server Management Studio. Ukufumana ulwazi oluthe vetshe, jonga i-tutorial yethu Ukudala i-Traces Traces ne-SQL Profiler .
SQL Server Agent
Ummeli we-SQL Server uvumela ukuba wenze ngokuzenzekelayo imisebenzi emininzi yolawulo eyenza ixesha lokulawula i-database. Ungasebenzisa i-agent ye-SQL Server ukwenza imisebenzi eqhuba ngexesha, imisebenzi eyenziwa yizilumkiso nemisebenzi eqaliswe yimigaqo egcinwe. Le mi sebenzi inokubandakanya amanyathelo awenza phantse nayiphi na imisebenzi yolawulo, kubandakanywa nolwazi olusekelayo, ukuqhuba imiyalelo yenkqubo yokusebenza, ukuqhuba iiphakheji ze-SSIS kunye nokunye. Ukufumana ulwazi oluthe xaxa kwi-Agent SQL Server, jonga i-tutorial yethu yokuThuthukisa uLawulo lweDatha yeDatha kunye ne-Agent SQL Server .
Umphathi weSquL Server
Umphathi we-SQL Server Configuration is-snap-in kwi-Microsoft Management Console (MMC) evumela ukuba ulawule iinkonzo ze-SQL Server esebenza kumaseva wakho. Imisebenzi ye-SQL Server Configuration Manager iquka ukuqala nokuyeka iinkonzo, ukulungiswa kwempahla yesevisi nokuqwalasela iinketho zokuxhumeka kwenethiwekhi. Eminye imizekelo yemisebenzi ye-SQL Server Configuration Manager iquka:
- Ukuqala inkonzo ye-Agent SQL Server (okanye ezinye iinkonzo ze-SQL Server) kunye noMphathi woLawulo
- Ukufakela ukudibana kweSQL Server kunye ne-SQL Server Configuration Manager
IiNkonzo zoQhagamshelwano lweSQL Server (SSIS)
IiNkonzo zoQhagamshelwano lweSQL Server (SSIS) zinikeza indlela eguquguqukayo yokuthumela nokuthumela idatha phakathi kokufakwa kwe-Microsoft SQL Server kunye nezinye iindidi ezininzi. Itshintsha indawo yeeNkonzo zoTshintsho lweData (DTS) ezifumaneka kwiinguqulelo zangaphambili zeSQL Server. Ukufumana ulwazi oluthe xaxa malunga nokusebenzisa i-SSIS, jonga i-tutorial yethu yokungenisa nokuThumela idatha kunye ne-SQL Server Integration Services (SSIS) .
Iincwadi kwi-Intanethi
Iincwadi kwi-intanethi yinkxaso esoloko ikhunjulwe enikezwa ngeSQL Server equle iimpendulo kwiinkalo ezahlukeneyo zokuphatha, zophuhliso kunye nokufakela. Kungumthombo omkhulu wokubonisana ngaphambi kokubuyela kwi-Google okanye inkxaso yobuchwepheshe. Unokufikelela kwiincwadi ze-SQL Server 2012 kwi-intanethi ye-Microsoft okanye unokukhuphela kwakhona ikopi yamaxwebhu eencwadi kwi-intanethi kwiinkqubo zakho zendawo.
Kule ngongoma, kufuneka ube nolwazi olufanelekileyo lwezixhobo ezisisiseko kunye neenkonzo ezinxulumene neMicrosoft SQL Server 2012. Nangona i-SQL Server yinkqubo eyinkimbinkimbi yolawulo lweenkcukacha, olu lwazi oluphambili kufuneka lukukhokele kwizixhobo ezikhoyo ukuze kuncediswe abaphathi beenkcukacha. ukufakela kwabo kwiSQL Server kwaye bakhowule kwindlela efanelekileyo yokufunda ngakumbi ngehlabathi leSQL Server.
Njengoko uqhubeka nohambo lwakho lokufunda lwe-SQL Server, ndiyakumema ukuba uhlolisise ezininzi izixhobo ezikhoyo kule ndawo. Uza kufumana ama-tutorials agqubuthela imisebenzi emininzi yolawulo eyenziwa ngabalawuli be-SQL Server kunye neengcebiso zokugcina i-SQL Server yolwazi olukhuselekileyo, oluthembekileyo nolulungeleleneyo.
Uyakumenywa ukuba usijoyine kwi-Forum yolwazi malunga neendawo ezininzi apho oogxa bakho bafumane khona ukuxoxa ngemiba malunga neSQL Server okanye ezinye iipolatifti zeenkcukacha.