Microsoft Zatsabola SQL kasamalidwe dongosolo Nawonso achichepere

Choyamba Microsoft Zatsabola SQL Baibulo zinakambidwa ndi kampani kumbuyo mu 1988. Nawonso achichepere yomweyo pabwino monga ubale Nawonso achichepere, amene ali, monga Mlengi, ubwino zitatu:

• kusungidwa njira imeneyi inapita patsogolo deta nyemba komanso ngati anakhalabe mu mode Mipikisano wosuta;
• mwayi mpaka kalekale Nawonso achichepere kuti kusagwirizana ogwiritsa popanda utsogoleli;
• lotseguka Seva nsanja, wakupatsani kulenga ntchito lachitatu chipani kuti ntchito SQL yawonongeka.

Microsoft SQL Server 2005 pansi malamulo dzina Yukon ndi kuzikonzanso scalability anakhala Baibulo loyamba limathandiza luso .NET. Kukweza chithandizo cha deta anagawira, zipangizo woyamba kukonza malipoti ndi kusanthula.

Kusakanikirana ndi Internet abomawo ntchito SQL Zatsabola 2005 monga maziko kwa chilengedwe cha machitidwe e-malonda ndi mwayi losavuta ndi otetezeka kwa deta kudzera asakatuli otchuka ntchito anamanga-makhoma oteteza (makhoma oteteza). The ogwira thandizo kufanana kompyuta pa chiwerengero malire mapurosesa.

M'malo Baibulo 2005 anabwera Microsoft SQL Server 2008, limene liri limodzi la maseva wotchuka kwambiri Nawonso achichepere, ndipo kenaka anaonekera Baibulo lotsatira - SQL Zatsabola 2012, mothandizidwa ndi ngakhale ndi M'chilamulo cha .NET ndi zina zotsogola zambiri luso processing ndi Zooneka situdiyo chitukuko chilengedwe. Azitsegula yosungirako mtambo ndi gulu lapadera wakhala analenga SQL Azure.

Transact-SQL

Popeza 1992, chinenero kafufuzidwe SQL ndi deta Nawonso achichepere kupeza muyezo. Pafupifupi onse mapulogalamu zinenero kulumikiza pogwiritsa ntchito Nawonso achichepere ake, ngakhale wosuta kumva kuti ntchito zambiri mwachindunji. The malembedwe chinenerocho akhala zikutsatiridwa kwa ngakhale, koma bizinezi Nawonso achichepere machitidwe kasamalidwe anayesa lembani ntchito zina SQL. Osanyengelera A sanapezeke, ndipo pambuyo "mfundo nkhondo" anali tsogoleri awiri: PL / SQL, Oracle, ndi transact-SQL mu Microsoft Zatsabola SQL.

T-SQL procedural chimafikira SQL kulumikiza Microsoft Zatsabola SQL. Koma si kukusalani chitukuko cha ntchito mawu "muyeso".

Automate malonda anu ndi SQL Server 2008 R2

Odalirika ntchito ofunsira ntchito ndi ovuta ntchito lero. Lokhoza yosavuta Nawonso achichepere kungachititse zomvetsa yaikulu. The Nawonso achichepere Seva ndi Microsoft SQL Server 2008 R2 limakupatsani bwinobwino ndipo adzatsekeredwa kusunga ndalama pafupifupi malire mudziwe ntchito amazilamulira bwino oyang'anira onse. Anathandiza makulitsidwe mpaka 256 mapurosesa.

Hyper-V luso bwino yagwiritsa ntchito mphamvu pazipita kachitidwe kamakono Mipikisano pachimake. Support kwa kuchuluka kwa kachitidwe pafupifupi purosesa kumachepetsa ndalama ndi bwino scalability.

yosanthula deta

Mwamsanga yosanthula zenizeni nthawi deta mitsinje mode ndi ntchito chigawo SQL Server StreamInsight, wokometsedwa mtundu wa ntchito. Timayamba ntchito mwambo zochokera .NET.

Business kupitiriza ndi deta chitetezo

pa nthawi ina iliyonse akuthandiza mulingo woyenera ntchito imapereka anamanga-mu ulamuliro chuma Seva. Woyang'anira akhoza kusamalira wakewo ndi dongosolo chuma, kuika malire ntchito kugwiritsa ntchito CPU ndi kukumbukira. Kubisa mbali kupereka kugawa mandala deta chitetezo ndi mwayi chipika ndi kwa iye.

MALIRE Nawonso achichepere kukula

A nyumba yosungiramo katundu deta akhoza onga mofulumira ndi mosamala. Mapulogalamuwanso angathe ntchito Fast Track Date yosungira zidindo kuthandiza litayamba magulu mpaka 48 TB. Kuweta kasinthidwe amathandiza zida ku makampani kutsogolera monga HP, EMC ndi IBM. deta psinjika ntchito muyezo UCS 2 kulola ntchito kwambiri ndalama za malo litayamba.

Kuwonjezera pa dzuwa la kutukula ndi olamulira

Yatsopano mapulogalamu mfiti limakupatsani mwamsanga kuchotsa maseva underloading, kusintha kulamulira ndi konza ntchito popanda kufunika kunja akatswiri lachitatu chipani. Control magawo a ntchito ndi Nawonso achichepere, kupeza mwayi kuti muzikhoza mu dashboards ndi imathandizira Mokweza ndi unsembe.

Zida kwa kusanthula munthu malonda

kampaniyo sanakhalepo ndi maganizo okha amene ayenera chinkhoswe mu analytics - IT-m'madipatimenti kapena mwachindunji owerenga. dongosolo malipoti munthu kusiya zochimwazo kumathetsa mavuto pogwiritsa ntchito zipangizo zamakono otetezedwa ndi ogwira ntchito yomanga, kusanthula ndondomeko malonda ndi kumutsatira. Timatha mwachindunji mwayi zinasokoneza makompyuta mu Microsoft Office ndi SharePoint yawonongeka. mudziwe Corporate akhoza Integrated ndi zina zipangizo, monga mapu, zithunzi ndi makanema.

chilengedwe yabwino ntchito pamodzi

Perekani anu antchito ndi wodziwa zambiri, chitukuko olowa ndi kusanthula deta ntchito PowerPivot ntchito kwa spreadsheet kupambana. pulogalamu amalola kuti kusanthula mfundo ndi kumutsatira njira malonda ndi kufalitsa malipoti kugawana Web kapena SharePoint dongosolo.

Pakuti cholengedwacho zithunzi, dongosolo la mkati inati Report Zomangamanga 3,0, amene amathandiza zosiyanasiyana akamagwiritsa ndi osiyanasiyana zidindo predefined.

Ntchito ndi zinasokoneza makompyuta ufulu

kampani imapereka ntchito ang'ono ndi kutukula novice kwa Microsoft SQL Server Express wapadera Baibulo kwaulere. Izi zikuphatikizapo yemweyo Nawonso achichepere luso, wa Baibulo "chokwanira 'cha SQL yawonongeka.

Iwo amathandiza zithunzi chilengedwe situdiyo chitukuko ndi Web Wolemba Mapulogalamu. Pangani matebulo chipangizo ndi mafunso, kukulitsa ntchito Internet ndi thandizo Nawonso achichepere, malowedwe zambiri kuchokera Php.

Gwiritsani ntchito mbali zonse za transact-SQL ndi zapamwamba kwambiri kupeza luso ADO.NET ndi deta LINQ. Iwo AMATHANDIZA kusungidwa njira, akapsa ndi ntchito.

Muzilimbikira zigawo zikuluzikulu ntchito mfundo zomveka, ndi optimizing kapangidwe Nawonso achichepere adzapanga dongosolo nokha.

Pangani malipoti wolemera cha kapangidwe iliyonse. Gwiritsani kusaka malipoti subsystem cigawo ndi ntchito Microsoft Office, ndipo anawonjezera kuti mudziwe chikalata pa malo m'mayiko ambiri.

ofunsira anayamba akhoza kuthamanga, pakalibe kugwirizana Nawonso achichepere Seva. Kalunzanitsidwe zichitike basi ntchito kampani luso kupeza ndalama kugawanika kulunzanitsa M'chilamulo.

Kupereka zomangamanga pogwiritsa ntchito mfundo kasamalidwe kwa zinasokoneza makompyuta onse ndi ntchito. General zitsanzo opaleshoni amachepetsa nthawi konza mafunso, kulenga n'kulola backups ntchito.

SQL Server 2008 R2 Express Edition ndi abwino kwa analamula mofulumira malo ndi masitolo online, mapulogalamu ntchito ndekha, tochepa. Izi lalikulu mwina chifukwa kuyambapo ndi kuphunzira.

Sinthani zinasokoneza makompyuta pogwiritsa ntchito SQL Server Management situdiyo

Microsoft SQL Server Management ndi apadera malo chilengedwe, mwayi ndi kasamalidwe zinasokoneza makompyuta ndi zinthu zonse SQL Server, kuphatikizapo Kusimba Services.

Kachitidwe amakhazikitsa mawonekedwe umodzi mbali zonse za utsogoleli wa mapulogalamu m'mabaibulo kale, monga akafufuzidwe chowunikira ndi Manager ogwira ntchito. Olamulira ndi mapulogalamu ndi akonzedwa lalikulu la zithunzi kapangidwe ndi kasamalidwe, ndi chinenero patsogolo malembedwe ntchito ndi Nawonso achichepere.

Editor Microsoft Server Management situdiyo malamulo kuliganizira wapadera. Timatha kukhala ndi zolembedwa script transact-SQL, mapulogalamu mafunso multidimensional kulumikiza deta ndiponso musanachite kuwathandiza kupulumutsa zotsatira monga XML. Pangani mafunso Chibugariya zotheka popanda kulumikiza kwa maukonde kapena Seva, kenako kukhazikitsa ndi nthawi. Pali zosiyanasiyana zidindo preset ndi dongosolo versioning.

The gawo "chinthu msakatuli" amalola inu kuona ndi kukonza zonse Integrated Microsoft Zatsabola SQL zinthu pa maseva onse ndi nthawi Nawonso achichepere. mosavuta mfundo yoyenera ndi ovuta chitukuko mofulumira ntchito ndi Baibulo kulamulira.

Kachitidwe zachokera zithunzi situdiyo Wakutali dongosolo Nkhono zothandiza expandable kasinthidwe ndi kukula kwa kutukula lachitatu chipani. Pa Intaneti, pali madera ambiri kumene mungapeze zonse zofunikira kudziwa ndi chitsanzo code ku kupanga chida chawo kasamalidwe ndi deta.

Malinga ndi kafukufuku olimba Forrester Research, Nawonso achichepere Microsoft SQL Server 2012 Nawonso achichepere Seva pamwamba atsogoleri atatu ogwira ntchito deta warehousing msika kumapeto kwa 2013. Akatswiri amanena kuti msika kuchulukana kwa Microsoft a gawo chifukwa njira Integrated kuti makampani ndondomeko malonda zokha. Microsoft SQL Server ndi nsanja ano chifukwa kasamalidwe ndi kusunga mitundu yonse, lowonjezera ndi zipangizo kusanthula ndi chitukuko. Payokha, ndi Dziwani omasuka wa kusakanikirana ndi mankhwala ena kampani, monga Office ndi SharePoint.