SQL Server 2012 Tutorial
Microsoft SQL Server 2012 ke lenaneo le feletseng la tsamaiso ea ditshwantsho tsa ditshwantsho (RDBMS) e fanang ka lisebelisoa tse sa tšoaneng tsa tsamaiso ho fokotsa moroalo oa nts'etso-pele ea basebeletsi, tlhokomelo le tsamaiso. Sehloohong sena, re tla koahela tse ling tsa lisebelisoa tse sebelisoang hangata: SQL Server Management Studio, SQL Profiler, SQL Server Agent, SQL Server Configuration Manager, SQL Server Integration Services le Books Online. A re hlahlobeng hanyane ka seng:
SQL Server Management Studio (SSMS)
SQL Server Management Studio (SSMS) ke konopo e kholo ea tsamaiso ea SQL Server. E fana ka pono ea "linonyana-mahlo" ea lisebelisoa tsohle tsa SQL Server marang-rang. U ka etsa mesebetsi e phahameng ea tsamaiso e amanang le lisebelisoa tse le 'ngoe kapa tse fetang, kemisa mesebetsi e tloaelehileng ea tlhokomelo kapa u bōpe le ho fetola sebopeho sa mananeo a motho ka mong. U ka boela ua sebelisa SSMS ho hlahisa lipotso tse potlakileng le tse litšila ka kotloloho khahlanong le lisebelisoa tsa hau tsa SQL Server. Basebedisi ba liphetolelo tsa SQL Server pele ho moo ba tla hlokomela hore SSMS e kenyelletsa mesebetsi e fumanoang pele ho Query Analyzer, Enterprise Manager, le Analysis Manager. Mona ke mehlala e meng ea mesebetsi eo u ka e etsang le SSMS:
- Bopa tafoleng ea dintlha tsa SQL Server
- Bontša ts'ebetso ea SQL Server le moeletsi oa Database Engine Tuning
- Lokisa tlhahlobo ea basebetsi ba SQL Server
- Hlahloba phetolelo ea database ea SQL Server
SQL Profiler
SQL Profiler e fana ka fensetere ka ho sebetsa ka hare ho hau ya hau. O ka shebella mefuta e fapaneng ea liketsahalo mme o shebelle tshebetso ea basebetsi ka nako ea sebele. SQL Profiler e u lumella ho hapa le ho khutlisetsa "litsela" tsa tsamaiso tse kenyang mesebetsi e sa tšoaneng. Ke sesebelisoa se seholo sa ho ntlafatsa lits'ebeletso tsa marang-rang ka mathata a tshebetso kapa ho rarolla mathata a itseng. Joalo le mesebetsi e mengata ea SQL Server, o ka fihlella SQL Profiler ka SQL Server Management Studio. Bakeng sa tlhahisoleseding e eketsehileng, bona tutorial ea rona Ho bopa Ditaba tsa Ditshebeletso le SQL Profiler .
SQL Server Agent
SQL Server Agent eu lumella hore o iketsetse mesebetsi e mengata ea tsamaiso ea nako e tloaelehileng e jang nako ea motsamaisi oa database. U ka sebelisa moemeli oa SQL Server ho theha mesebetsi e tsamaeang ka nako e itseng, mesebetsi e bakoang ke litlhokomeliso le mesebetsi e qalileng ka mekhoa e bolokiloeng. Mesebetsi ena e ka kenyelletsa mehato e etsang hoo e batlang e le mosebetsi ofe kapa ofe oa tsamaiso, ho akarelletsa le ho tšehetsa lisebelisoa tsa tsamaiso, ho phetha litaelo tsa tsamaiso ea tsamaiso, ho tsamaisa liphutheloana tsa SSIS le ho feta. Bakeng sa tlhahisoleseding e eketsehileng ka SQL Server Agent, bona tutorial ea rona ea Automating Database Administration le SQL Server Agent .
SQL Server Configuration Manager
SQL Server Configuration Manager ke sesebelisoa sa Microsoft Management Console (MMC) se o lumellang hore o laole litšebeletso tsa SQL Server tse sebetsang litsing tsa hau. Mesebetsi ea SQL Server Configuration Manager e kenyelletsa ho qala le ho emisa ditshebeletso, ho fana ka ditshebeletso tsa ho hlophisa le ho lokisa dikgetho tsa marang-rang a marang-rang. Mehlala e meng ea SQL Server Configuration Manager mesebetsi e kenyelletsa:
- Ho qala SQL Server Agent Service (kapa lits'ebeletso tse ling tsa SQL Server) le Configuration Manager
- Ho ngolisa litlaleho tsa basebetsi ba SQL Server le SQL Server Configuration Manager
SQL Server Integration Services (SSIS)
SQL Server Integration Services (SSIS) e fana ka mokhoa o tsitsitseng haholo bakeng sa ho kenya le ho romela ditaba pakeng tsa ho kenyeletsoa ha Microsoft SQL Server le mefuta e meng e mengata ea mefuta e meng. E nkela sebaka sa Data Transformation Services (DTS) e fumanoang liphetolelong tsa pele tsa SQL Server. Bakeng sa tlhahisoleseling e eketsehileng mabapi le ho sebelisa SSIS, bona tutorial ea rona ho kenya lintlha le ho romela lits'ebeletso ka SQL Server Integration Services (SSIS) .
Libuka Online
Libuka tsa Inthaneteng ke mohloli o atisang ho hlokomolohuoa o fanoeng ka SQL Server o nang le likarabo tsa mathata a fapaneng a tsamaiso, nts'etsopele le tlhomamiso. Ke mohloli o motle oa ho buisana pele o khutlela Google kapa tšehetso ea theknoloji. O ka fihlella SQL Server 2012 Books Online ho websaeteng ea Microsoft kapa u ka boela ua kopitsa likopi tsa Libuka tsa Inthaneteng ho li-system tsa hau tsa moo.
Ka nako ena, o lokela ho ba le kutloisiso e ntle ea lisebelisoa tsa motheo le lits'ebeletso tse amanang le Microsoft SQL Server 2012. Le hoja SQL Server e le mokhoa o rarahaneng oa tsamaiso ea lisebelisoa tsa basebetsi, tsebo ea mantlha e lokela ho u lebisa lithulusi tse fumanehang ho thusa batsamaisi ba litaelo lisebelisoa tsa bona tsa SQL Server mme ba supa tsela e nepahetseng ea ho ithuta ho eketsehileng ka lefatše la SQL Server.
Ha u ntse u tsoela pele leetong la hao la ho ithuta la SQL Server, ke u mema hore u batlisise mehloli e mengata e fumanehang mocheng ona. U tla fumana lithuto tse koahelang mesebetsi e mengata ea tsamaiso e etsoang ke batsamaisi ba SQL Server hammoho le keletso ea ho boloka litsi tsa hau tsa SQL Server tse sireletsehileng, tse ka tšeptjoang le tse nepahetseng.
Hape o memeloa hore o kene le rona Inthaneteng ea Databases eo ho eona basebetsi-'moho le uena ba bangata ba teng ho buisana ka litaba tsa SQL Server kapa liforomo tse ling tsa database.