SQL Server 2012 Tutorial
Microsoft SQL Server 2012 yana da cikakkiyar siffofi game da tsarin kula da bayanai (RDBMS) wanda ke samar da kayan aiki da yawa don sauƙaƙe nauyin bunkasa bayanai, goyon baya, da kuma kulawa. A cikin wannan labarin, za mu rufe wasu kayan aikin da ake amfani da su akai-akai: SQL Server Management Studio, SQL Profiler, Ma'aikatar SQL Server, Ma'aikatar Kanfigareshan SQL, SQL Server Integration Services da Books Online. Bari mu bincika kowane ɗan gajeren lokaci:
Cibiyar Gidan Ayyuka na SQL Server (SSMS)
Cibiyar Sadarwar Sadarwar Sadarwar SQL Server (SSMS) ita ce babban mahimmancin tsarin kulawa na SQL Server. Yana bayar da ku da kallon "tsuntsaye-ido" mai siffar duk kayan aikin SQL Server a kan hanyar sadarwarku. Zaka iya yin ayyukan gudanarwa na babban mataki wanda ya shafi ɗaya ko fiye da sabobin, tsara jadawalin kulawa na yau da kullum ko ƙirƙirar da gyara tsarin tsarin bayanan mutum. Kuna iya amfani da SSMS don ba da tambayoyi mai sauri da datti kai tsaye a kan kowane daga cikin bayanan SQL Server. Masu amfani da sababbin sassan SQL Server zasu gane cewa SSMS ya ƙunshi ayyukan da aka samo a cikin Bincike Query, Manajan Shirin Kasuwanci, da kuma Ma'aikata Analyzer. Ga wasu misalai na ayyuka waɗanda za ku iya yi tare da SSMS:
- Create a SQL Server database tebur
- Tune aikin SQL Server tare da Mashawarcin Tuntuba na Masarrafin Intanet
- Sanya saitin bayanan SQL Server
- Kafa SQL Server database tsari
Profiler na SQL
SQL Profiler yana samar da taga a cikin ayyukan ciki na kwamfutarka. Za ka iya saka idanu da yawa iri-iri iri da kuma tsayar da bayanai a cikin ainihin lokacin. Profiler na SQL yana baka dama ka kama da sake sauya tsarin "hanyoyi" wanda ke shiga ayyukan daban-daban. Yana da babban kayan aiki don ingantawa bayanan bayanai tare da maganganu na aiki ko warware matsaloli na musamman. Kamar yadda tare da yawancin ayyukan SQL Server, za ka iya samun damar SQL Profiler ta hanyar SQL Server Management Studio. Don ƙarin bayani, duba koyaswarmu Ƙirƙirar Bayanan Labarai tare da Profiler na SQL .
Asusun SQL Server
Ma'aikaci na SQL Server ya ba ka damar sarrafawa da yawa ayyuka na yau da kullum da ke cinye lokaci mai gudanarwa. Zaka iya amfani da wakilin SQL Server don ƙirƙirar ayyukan da ke gudana a kan lokaci, ayyukan da aka faɗakar da su ta hanyar faɗakarwa da kuma ayyukan da aka farawa ta hanyoyin da aka adana. Wadannan ayyuka na iya haɗa da matakan da suke yin kusan kowane aikin gudanarwa, ciki har da tallafawa bayanan bayanan, aiwatar da tsarin tsarin aiki, gudana SSIS kunshe kuma mafi. Don ƙarin bayani game da SQL Server Agent, gani mu tutorial Automating Database Administration tare da SQL Server Agent .
Ma'aikatar Kanfigareshan SQL Server
Ma'aikatar Kanfigareshan SQL Server shi ne kullun don Microsoft Management Console (MMC) wanda ke ba ka damar sarrafa ayyukan SQL Server da ke gudana a kan sabobinka. Ayyuka na SQL Server Kanfigareshan Manager sun hada da farawa da dakatar da ayyuka, gyara kayan aikin sabis da kuma daidaitawa haɗin zaɓin cibiyar sadarwa na cibiyar sadarwa. Wasu misalai na SQL Server Kanfigareshan Manager ayyuka sun hada da:
- Farawa na SQL Server Agent Service (ko wasu ayyukan SQL Server) tare da Kanfigareshan Manager
- Encrypting SQL Server database haɗi tare da SQL Server Kanfigareshan Manager
Ayyukan Sadarwar SQL Server (SSIS)
Sadarwar Sadarwar Sadarwar Sadarwar (SSIS) ta samar da wata hanya mai sauƙi don sayo da aikawa da bayanai tsakanin Microsoft SQL Server shigarwa da kuma manyan nau'o'in sauran tsarin. Yana maye gurbin Data Transformation Services (DTS) da aka samo a cikin asali na SQL Server. Don ƙarin bayani game da yin amfani da SSIS, duba koyaswar Kasuwancin Ana shigowa da Ana fitarwa da SQL Server Integration Services (SSIS) .
Books Online
Littattafai a kan layi ne sau da yawa kayan aiki wanda ba a kula da shi ba tare da SQL Server wanda ya ƙunshi amsoshin da dama na administrative, ci gaba da shigarwa al'amurran da suka shafi. Yana da babbar hanya don tuntubar kafin juya zuwa Google ko goyon bayan sana'a. Za ka iya samun damar yin amfani da Lissafi na SQL Server 2012 a kan shafin yanar gizon Microsoft ko kuma za ka iya sauke kwafin littattafan Littattafai na Lantarki a tsarinka na gida.
A wannan batu, ya kamata ka fahimci fahimtar kayan aiki da ayyuka masu dangantaka da Microsoft SQL Server 2012. Duk da yake SQL Server na da hadari, tsarin kula da bayanai mai zurfi, wannan ilimin ilimi ya dace ya dace da kayan aikin da za a iya taimaka wa masu gudanarwa na bayanai su SQL Server shigarwa da kuma nuna muku a cikin hanya madaidaiciya don ƙarin koyo game da duniya na SQL Server.
Yayin da kake ci gaba da tafiyar da koyaswar SQL Server, na kira ka don bincika albarkatun da yawa a wannan shafin. Za ku sami tutorials da ke rufe da dama daga cikin muhimman ayyuka na gwaninta da aka gudanar da masu amfani da SQL Server da shawara a kan kiyaye your SQL Server databases amintacce, abin dogara da optimally saurare.
Ana kuma gayyatar ku zuwa cikin mu a cikin About Databases Forum inda yawancin abokan hulɗarku suna samuwa don tattauna batutuwa game da SQL Server ko wasu dandamali na dandalin bayanai.