Microsoft amaseva SQL ngabaphathi semininingwane uhlelo

Okokuqala Microsoft amaseva SQL okufushane yethulwa yinkampani emuva ngo-1988. Database ngokushesha isebangeni njengoba zingubudlelwane egciniwe, esesikhundleni, ngokuvumelana umkhiqizi, izinzuzo ezintathu:

• egcinwe izinqubo ezenza yashesha idatha isampula kanye ubuqotho bayo inakekelwa kwimodi multi-umsebenzisi;
• ukufinyelela unomphela database ukunqamula i nabasebenzisi ngaphandle kokuphathwa;
• platform iseva evulekile, ukuvumela ukudala zabama-third party ezisebenzisa SQL Server.

Microsoft SQL Server 2005 ngaphansi kwegama ikhodi Yukon nge scalability ethuthukisiwe baba inguqulo yokuqala isekela ngokuzeleko .NET ubuchwepheshe. Okuthuthukisiwe usekelo idatha zisakazwe, amathuluzi lokuqala zokubika kanye nokuhlaziywa.

Ukuhlanganisa i-Inthanethi avunyelwe ukusetshenziswa SQL amaseva 2005 njengesisekelo ukudalwa e-commerce izinhlelo nge ukufinyelela elula nephephile idatha nge iziphequluli ezidumile usebenzisa esakhelwe firewall (firewall). I Usekelo lwezamabhizinisi parallel Computing ku esingenamkhawulo ukuthi zonke izilimi.

Ukuze bavale isikhala salo version 2005 weza Microsoft SQL Server 2008, okuyinto namanje omunye ethandwa kakhulu semininingwane amaseva, futhi kamuva kancane uvele version elilandelayo - SQL amaseva 2012, ngokusekelwa ukuhambisana ne Framework nezinye eziphambili Imininingwane ekucubunguleni ubuchwepheshe kanye e-Visual Studio ukuthuthukiswa imvelo. Ukufinyelela isitoreji samafu uphiko oluyisipesheli sidaliwe SQL Azure.

Transact-SQL

Kusukela ngo-1992, i- nombuzo ulimi SQL lwedatha ukufinyelela semininingwane ejwayelekile. Cishe zonke uHlelo izilimi ukuyifinyelela usebenzisa database yayo, ngisho noma umsebenzisi wokuthi akusebenza ngolwazi ngqo. I-syntax eziyisisekelo zalolo limi uhlala ingashintshiwe kungasebenziswa, kodwa ngamunye umthengisi semininingwane nohlelo lokuphatha wazama ukugcwalisa ezengeziwe SQL imisebenzi. A ebucayini ayikwazanga ukutholakala, futhi ngemva "amazinga impi" babe abaholi ababili: PL / SQL, Oracle, futhi transact-SQL e-Microsoft amaseva SQL.

T-SQL zenqubo ubabonisa SQL ukufinyelela Microsoft amaseva SQL. Kodwa akusho ukuthi lokhu ukubeka eceleni ukuthuthukiswa kwezicelo ezitatimendeni "okuvamile".

Ukushintsha ibhizinisi lakho nge SQL Server 2008 u-R2

ukusebenza onokwethenjelwa izicelo ibhizinisi kubalulekile ibhizinisi namuhla. I kancane semininingwane elula kungaholela ukulahlekelwa omkhulu. Iseva database Microsoft SQL Server 2008-R2 ikuvumela ukuba ngokuphephile nangokuvikeleka ukugcina imali cishe angenamkhawulo Imininingwane usebenzisa zokulawula ajwayelekile bonke abalawuli. Asekelwe ukunciphisa kuze kube 256 izilimi.

ubuchwepheshe Hyper-V ngempumelelo isebenzisa amandla esiphezulu yesimanje multi-core izinhlelo. Ukusekela sebuningini virtual processor izinhlelo kunciphisa izindleko futhi kuthuthukisa scalability.

ukuhlaziya idatha

Ukuze ngokushesha sihlaziye real-time idatha ukusakaza imodi esetshenziswa ingxenye SQL Server StreamInsight, elungiselelwe lolu hlobo imisebenzi. Asikwazi ukwakha ngokwezifiso izicelo esekelwe .NET.

Ukuqhubeka nedatha yezokuphepha

nganoma isiphi isikhathi esisodwa asekelayo lusebenze kahle ihlinzeka esakhelwe iseva izinsiza control. Umlawuli ungaphatha umsebenzi kanye system imithombo, ukuze ubeke umkhawulo izinhlelo zokusebenza ukusebenzisa i-CPU kanye inkumbulo. izici Ukubethela unikeze yokuvikelwa kokwaziswa futhi ukufinyelela log nezimo futhi ezethembekile yizona kuye.

Unlimited Usayizi semininingwane

A izimpahla idatha kungaba sikala ngokushesha futhi ngokuphepha. Abasebenzisi angasebenzisa Fast Track Usuku Warehouse ka-izifanekiso ukusekela disk afanayo-48-TB. ukumiswa Basic isekela imishini kusuka izinkampani okuholela ezifana HP, EMC futhi IBM. idatha umsebenzi ejwayelekile UCS 2 ukuvumela ukusetshenziswa ukonga ngaphezulu sediski.

Ukuthuthukisa nekusebenta Onjiniyela nabaphathi

Isofthiwe entsha wizadi likuvumela ukuthi ususe ngokushesha amaseva underloading, ukuthuthukisa ukulawulwa kanye nokwandisa ukusebenza ngaphandle kwesidingo zangaphandle ochwepheshe third-party. Control kwemigomo isicelo kanye database, thola ngamathuba okwenza ngcono ukusebenza amadesibhodi ukusheshisa ukuthuthukisa kanye ukufakwa.

Amathuluzi siqu ukuhlaziywa yebhizinisi

Le nkampani iye Angikaze umbono olulodwa ngokuthi ubani okufanele zenziwe analytics - IT-iminyango noma ngqo kubasebenzisi. siqu kwesistimu yokubika ukuzixazulula le nkinga esebenzisa amathuluzi yesimanje ukwakhiwa iphephile futhi isebenza ngempumelelo, inqubo ibhizinisi ukuhlaziywa kanye yokumodela. Kuvumela ukufinyelela ngqo yolwazi e-Microsoft Office futhi isihlonzi Server. Imininingwane Corporate kungenziwa ihlanganiswe nezinye izinhlobo izinto, ezifana amabalazwe, izithombe kanye namavidiyo.

imvelo esilungele besebenza ndawonye

Nikeza nabasebenzi bakho ukufinyelela emininingwaneni, ukuthuthukiswa ngokuhlanganyela kanye nedatha analysis besebenzisa isicelo PowerPivot i isipredishithi Excel. Uhlelo ivumela ukuhlaziywa ulwazi kanye ukumodeliswa izinqubo zebhizinisi nokushicilela imibiko ukwabelana Web noma isihlonzi uhlelo.

Ukuze indalo ezibukwayo, isimiso sangaphakathi ibika Umbiko Builder 3.0, olusekela ezihlukahlukene izakhiwo kanye anhlobonhlobo izifanekiso achazwe.

Sebenza yolwazi khulula

Le nkampani inikeza amaphrojekthi amancane Onjiniyela imfundamakhwela Microsoft SQL Server Express ekhethekile version free. Lokhu kuhlanganisa database ubuchwepheshe obufanayo, ukuthi version "esigcwele" SQL Server.

Isekela Visual ukuthuthukiswa Studio imvelo kanye Web Unjiniyela. Yakha amathebula eyinkimbinkimbi futhi imibuzo, ukuthuthukisa izinhlelo zokusebenza Inthanethi nokusekela egciniwe, ukufinyelela ngqo ulwazi kusuka PHP.

Sebenzisa zonke izici transact-SQL futhi eziphambili kakhulu ukufinyelela ubuchwepheshe ADO.NET nedatha LINQ. Isekela egcinwe izinqubo, trigger nemisebenzi.

Gxila izingxenye zebhizinisi logic, futhi iqhakambisa isakhiwo semininingwane uzokwenza uhlelo ngokwakho.

Dala imibiko ocebile yanoma yimuphi yinkimbinkimbi. Sebenzisa search imibiko subsystem ukuhlanganiswa ne izicelo-Microsoft Office, bese yengezwa ulwazi idokhumenti isikhundla womhlaba.

Izinhlelo lakhiwa ingaqalisa ku engekho uxhumano leseva database. Ukuvumelanisa kwenziwa ngokuzenzakalelayo usebenzisa nokuphathelene ubuchwepheshe emibhalombiko ukufanisana Vumelanisa Framework.

Qondisa ingqalasizinda yabo usebenzisa inqubomgomo ukuphathwa kubo bonke yolwazi kanye nezicelo. Jikelele yokusebenza zimo kunciphisa isikhathi nokwandisa imibuzo, ukudala nokubuyisela izipele ibhizinisi.

SQL Server 2008-R2 Express Edition ekahle ukuthunyelwa okusheshayo amasayithi kanye ezitolo inthanethi, isofthiwe ukusetshenziswa siqu, ibhizinisi elincane. Lena kukho olukhulu zokuqalisa nokufunda.

Phatha yolwazi ngokusebenzisa SQL Server Management Studio

Microsoft SQL Management Iseva indawo ezikhethekile ukuze kwakhiwe, ukufinyelela kanye nokuphathwa yolwazi kanye nazo zonke izingxenye SQL Server, kuhlanganise Ukubika Services.

Uhlelo usungula esibonakalayo olulodwa zonke izici kwezinhlelo ezinguqulweni ngaphambili, ezifana Umbuzo Analyser kanye Enterprise Manager. Abalawuli zinesofthiwe neqoqo elikhulu ihluzo design nokuphatha, eziphambili scripting kolimi ukusebenza database.

Umhleli Microsoft Server Management Studio ikhodi ufanelwe ukuqashelwa okukhethekile. It ikuvumela ukuthuthukisa imibhalo iskripthi transact-SQL, uHlelo imibuzo multidimensional ukufinyelela idatha futhi ukuhlaziya nabo ukusekelwa ukuze ulondoloze imiphumela njengoba XML. Yakha imibuzo kanye nemininingwane kungenzeka ngaphandle yokuxhuma kwinethiwekhi noma iseva, kulandele ukuqaliswa kanye isikhathi. Kukhona ezihlukahlukene izifanekiso esethiwe futhi inguqulo uhlelo.

I module "Into Isiphequluli" lets ubheka uphinde uphathe yonke ihlanganiswe Microsoft amaseva SQL izinto zonke amaseva kanye database izimo. Ukufinyelela okulula ulwazi olulungile kubalulekile okusheshayo kwentuthuko yohlelo lokusebenza futhi version control.

Uhlelo isekelwe e-Visual Studio gqwa Shell uhlelo esekela ukucushwa anwebekayo kanye ukunwetshwa Onjiniyela third-party. Kuyi-Internet, zikhona imiphakathi eminingi lapho ungathola zonke kunesidingo ulwazi kanye isampula ikhodi ukuthuthukisa amathuluzi abo ukuphathwa siqu kanye nedatha.

Ngokusho ucwaningo ngokuqinile Forrester Research, Database Microsoft SQL Server 2012 semininingwane server phezulu abaholi idatha Warehousing emakethe ezintathu ibhizinisi ekupheleni 2013. Ochwepheshe ukuthi share emakethe kanye nokukhula ngokushesha kwalezi Microsoft kungenxa indlela edidiyelayo yenkampani inqubo ibhizinisi ezishintshayo. Microsoft SQL Server is a platform yesimanje ukuphathwa kanye yokugcina zonke izinhlobo, kwahambisana by amathuluzi sokuhlaziya nokuthuthukiswa. Endaweni ehlukile, kuyafaneleka kalula ukuhlanganiswa imikhiqizo nezinye yenkampani, ezifana Office futhi isihlonzi.